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 |
petek
Posting Yak Master
192 Posts |
Posted - 2009-01-22 : 08:17:08
|
Hi all,I cannot connect to my SQL Server. i need to create a ODBC connection but it fails.Microsoft SQL Server Login---------------------------Connection failed:SQLState: '01000'SQL Server Error: 11004[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).Connection failed:SQLState: '08001'SQL Server Error: 6[Microsoft][ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found.Connection failed: SQL State: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). Connection Failed: SQL State: '08001' SQL Server Error: 6 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found. the server is there and i can connect to it locally but not from remote connections.i have checked surface area configuration and it allows remote connections.any ideas??Kind RegardsPete. |
|
petek
Posting Yak Master
192 Posts |
Posted - 2009-01-22 : 08:49:52
|
SQL Browser was disabledKind RegardsPete. |
|
|
|
|
|