Connection Issue !

  • Hi,

    I had sql server 2000 client installed. At the same time had sql server 2005 express installed on the same machine. It was workin well nd fine.Later I upgraded the client version of 2000 to server (as named instance).

    I can connect to both my instances locally but am not able to connect to the 2000 named instance through the network.

    Tried many things like changing the settings, installing sp3 and all but in vain.

    Please help me out !

    Thanks in Advance

    Santhosh

    Sanz
  • I would try a couple troubleshooting steps just to narrow down the problem.

    1)  Look at the SQL Serrver error log to find what TCP/IP port the 2000 instance is listening on and note it.  (In the mean time, check if there are any errors, etc.)

    2)  Connect to a windows client machine in the same network (any will do).  Open a command prompt and try "telnet <IP> <port>" and hit enter.  If it opens to an empty window, then you know SQL can take client connections.  If not, it insn't listening over TCP/IP.

    Well, that's a start, anyhow.

     

    Good luck.

    Eric

  • Tried it !

    It's listening over TCP/IP

    Sanz
  • What do you mean you can't connect to it? How are you trying? Did you register the new instance in SSMS/Enterprise Manager? Are you getting any error messages?

    -SQLBill

  • It's already registered in the server(named instance). No other client machines are able to connect to it through the network.

    Is this issue because of the coexistance of both sql server 2000 and 2005 on the same machine ????

    Sanz
  • Issue solved !

    I tried giving the sql server 2000 port number i.e,1433 nd it got connected.

    The whole server name will look like this

    [server name]\[Instance],1433

    Was plannin for another installation actually. Thanks guys for all the help.

     

    Sanz

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply