July 12, 2007 at 7:06 am
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
July 12, 2007 at 8:27 am
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
July 12, 2007 at 9:50 am
Tried it !
It's listening over TCP/IP
July 12, 2007 at 10:32 am
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
July 12, 2007 at 10:51 am
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 ????
July 12, 2007 at 12:07 pm
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.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply