error creating dsn

[Rina]

hi all, i'm new to Sql server, I'm getting an error while creating dns, like this::
SQLState:'01000'
SQL Server Error:53
[Microsoft] [ODBC SQL Server Driver] [DBNETLIB]Connection Open(connect())
Connection Failed
SQLState:'08001'
SQL Server Error: 17
[Microsoft] [ODBC SQL Server Driver] [DBNETLIB] SQL Server does not exist or access denied.

I'm trying it in my desktop, pls help.

From http://www.developmentnow.com/g/111_2003_12_0_0_0/sqlserver-odbc.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

[Lucas Kartawidjaja]

Hi Rina

What version and edition of SQL Server do you have? Also is the SQL Server
local to your desktop?

It can be one of several things:
-. If the SQL Server server is not local on your system, try to ping the
server where the SQL server is located. See if that's successful.
-. Is the SQL Server up and running? Can you try to connect to the SQL
Server using either Query Analyzer, Enterprise Manager or SQL Server
Management Studio.
-. If you have SQL Server Express installed on your system, make sure that
you connect using the SQL server instance. use .\SQLEXPRESS or
(local)\SQLExpress or [Computer Name]\SQLExpress (it is because normally SQL
Express is installed as named instance).
-. If you have SQL Server Express or SQL Server Developer installed, make
sure that you enable remote connection (if you are trying to connect from a
different system).

There are probably some others. Let us know how it goes.

Thank you
Lucas