Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Error 17 and 10060

Author  Topic 

Thrish
Starting Member

3 Posts

Posted - 2005-05-06 : 03:49:24
Hi,

I am trying to get the connect to a SQL server. In the client machine, I went to Control Panel-Administrative Tools-Data Source(ODBC) and added SQL Server.

While configuring, I am able to select the server but not the database in that server. It throws me an error as SQL Server Error:10060 (TCP/IP Sockets)Connectionopen(Connect())
SQL Server Error:17 Server does not exist or access denied.

What should i do?





Thrishna Selvaraj

vijayakumar_svk
Yak Posting Veteran

50 Posts

Posted - 2005-05-06 : 05:17:52
Check the selected server has SQL server Instance running.
Please type the command sqlmangr in run in your server and check.
If not start the service.

Work smarter not harder take control of your life be a super achiever
Go to Top of Page

Thrish
Starting Member

3 Posts

Posted - 2005-05-06 : 07:10:21
command sqlmangr works in the server, and all the services are running but still in the client system there is the same error...

Thrishna Selvaraj
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-05-06 : 07:27:57
are you allowed to connect to the server?

1. check for firewall restrictions
2. sql server user restriction
3. have you registered the server? (check client network utility or host file)

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -