| Author |
Can not connect to SQL Server
|
|
| Snoopstah 2006-01-18, 8:23 pm |
| A user who has been connected to our server for several years can not longer
connect.
The error through ODBC shows the following :
Connection failed:
SQLState: '01000'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server not
found.
No one else in the firm is having troubles connecting to the server. The
server has SP4 applied.
| |
| Hilary Cotter 2006-01-19, 3:23 am |
| Can he ping the server by hostname? Check to his ODBC connection to ensure
that it is correct. It sounds like a name resolution problem.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Snoopstah" < Snoopstah@discussion
s.microsoft.com> wrote in message
news:84167888-D06E-4E37-8030- 103ABF66F29D@microso
ft.com...
>A user who has been connected to our server for several years can not
>longer
> connect.
>
> The error through ODBC shows the following :
> Connection failed:
> SQLState: '01000'
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open
> (Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 6
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server
> not
> found.
>
> No one else in the firm is having troubles connecting to the server. The
> server has SP4 applied.
| |
| Snoopstah 2006-01-19, 3:23 am |
| They can ping and connect to other named instances on the server.
I have since found if they put " SERVERNAME\PortNumbe
r" instead of
" SERVERNAME\INSTANCEN
AME" in their definition it all works.
Why is that ?
"Hilary Cotter" wrote:
> Can he ping the server by hostname? Check to his ODBC connection to ensure
> that it is correct. It sounds like a name resolution problem.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Snoopstah" < Snoopstah@discussion
s.microsoft.com> wrote in message
> news:84167888-D06E-4E37-8030- 103ABF66F29D@microso
ft.com...
>
>
>
|
|
|
|