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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-17 : 08:24:20
|
| Sherry writes "I installed SQL Server 2000 instance in Windows 2000 and SQL Serer client in WindowsNT. But ODBC connection failed by using SQL Server login ID. I got the following error message: Connection failed SQLState '01000' SQL Server Error: 10061 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] Connection open[Connect()] Connection failed SQL State '08001' SQL Server error: 17[Microsoft>[ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. Would you please let me know the reason. Thanks a lot.Sherry" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-17 : 08:57:47
|
| When connecting to the SQL Server, are you using the server's IP address, or did you create a network alias for that server? You can use the Client Network Utility to create an alias for the server, and then try using the alias name to connect.Also make sure that the login you're using has rights to that SQL Server, in case you're using a trusted connection. |
 |
|
|
|
|
|
SQL Server connection problem