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 2005 Forums
 SQL Server Administration (2005)
 ODBC Connection

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 Regards

Pete.

petek
Posting Yak Master

192 Posts

Posted - 2009-01-22 : 08:49:52
SQL Browser was disabled

Kind Regards

Pete.
Go to Top of Page
   

- Advertisement -