hello all,

I am trying to connect to an named instance of sql server 2000 with sp4
unsuccessfully. I am getting the below error:

Connection Failed:
SqlState:'01000'
Sql Server Error:11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen(Connect()).
Connect Failed:
SqlState: '08001'
SQL Server Error:6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] Specified Sql Server not
found.

I am able to connect to other instances of sql. I should be connecting using
TCP/IP however in my sql logs I am geeting the below message.

SQL server listening on Shared Memory, Named Pipes.

Any help you all could provide would be greatly appreciated

Regards

Andre

nevermind guys,

It turns out that the server was having issues with tcp/ip and as a result I
could not remotely connect. The sql logs should have said listening with
shared memory tcp/ip and named pipes but it only had shared memory.

"Andre Gibson" wrote:

> hello all,
>
> I am trying to connect to an named instance of sql server 2000 with sp4
> unsuccessfully. I am getting the below error:
>
> Connection Failed:
> SqlState:'01000'
> Sql Server Error:11004
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen(Connect()).
> Connect Failed:
> SqlState: '08001'
> SQL Server Error:6
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] Specified Sql Server not
> found.
>
> I am able to connect to other instances of sql. I should be connecting using
> TCP/IP however in my sql logs I am geeting the below message.
>
> SQL server listening on Shared Memory, Named Pipes.
>
> Any help you all could provide would be greatly appreciated
>
> Regards
>
> Andre
>