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.
| 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 |
 |
|
|
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 |
 |
|
|
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 restrictions2. sql server user restriction3. have you registered the server? (check client network utility or host file)--------------------keeping it simple... |
 |
|
|
|
|
|