| Author |
 Topic  |
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
 Posted - 10/06/2004 : 16:00:59
|
And if you try ServerName,1533 in QA, it works on the server?
Tara |
 |
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 16:28:51
|
| No It doesn't work |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 10/06/2004 : 16:31:21
|
Seems like port 1533 isn't working on that server then which is probably why your client machine isn't able to connect to it.
Tara |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 10/06/2004 : 16:34:29
|
Open up the registry using regedit.exe on the server:
Navigate to this key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceName>\MSSQLServer\SuperSocketNetLib\Tcp
Double click on TcpPort. What value does it show? Do this for both instances.
Tara |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 16:43:26
|
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Client\SuperSocketNetLib\Tcp
Default REG_SZ (ValuNotSet)
Default Port REG_DWORD 0x00000599(1433)
I don't see Regit Entry like you mentioned:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceName>\MSSQLServer\SuperSocketNetLib\Tcp
|
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 16:47:59
|
Tara,
I take my work back. I am sorry about that. I was looking at client entry. Yes i navigated through and for each instance the port is same as i mentioned.
Instance1 1533
Instance2 1433 |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 10/06/2004 : 18:06:46
|
So now please post the the registry entries for these:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
You will find your instance name in the ConnectTo key. Please post the value of them here. Do this on both the server and the client. So you should have 4 answer for me:
Server:
Instance1-
Instance2-
Client:
Instance1-
Instance2-
Tara |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/07/2004 : 08:32:26
|
Server:
Instance1- DBMSSOCN,Server,1533
Instance2- DBMSSOCN,Server
Client:
Instance1- DBMSSOCN,Server,1533
Instance2- DBMSSOCN,Server
|
Edited by - ricky_newbee on 10/07/2004 10:10:07 |
|
|
|
jen
Flowing Fount of Yak Knowledge
Sweden
4110 Posts |
Posted - 10/07/2004 : 10:14:27
|
quote:
Originally posted by ricky_newbee
Server:
Instance1- DBMSSOCN,Server,1533
Instance2- DBMSSOCN,Server
Client:
Instance1- DBMSSOCN,Server,1533
Instance2- DBMSSOCN,Server
why do you have same instance name? |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/07/2004 : 10:58:34
|
| Didn't get your question? |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 10/07/2004 : 12:27:54
|
The same instance name isn't being used, Jen. The first part is the alias. The second part and the port number is what differentiates them.
According to previous posts that you've done, Instance1 should be listening on port 1433 and Instance2 should be listening on port 1533. That's not what those registry entries are telling us.
Tara |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/07/2004 : 13:03:18
|
My Mistake Tara...
Instance1 is 1433
Instance2 is 1533 |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 10/07/2004 : 13:04:57
|
Your registry entries should be:
Server:
Instance1- DBMSSOCN,Server,1433
Instance2- DBMSSOCN,Server,1533
Client:
Instance1- DBMSSOCN,Server,1433
Instance2- DBMSSOCN,Server,1533
Tara |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/07/2004 : 13:08:40
|
| Yes!! That's exactly what i have. I been trying to figure this out since 2 days...I wonder why server could not show me Instance2 in EM. I have every thing correctly in place.. EM is showing me Instance1 which has 1433 port and i tryed changing port for Instance2....It didn't work like that either... |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 10/07/2004 : 13:15:38
|
I'd suggest reinstalling the SQL Client Tools on both machines. After that, install service pack 3a on both machines. Make sure your MDAC is at least 2.7. If none of that works, you'll probably need to call MS.
Tara |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/07/2004 : 14:21:48
|
Yes! Tara...I would like to do that...
Thanks for your help...I shall post message once i am done with install process |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
Australia
4970 Posts |
Posted - 10/08/2004 : 00:35:37
|
Who's on first ?
Damian |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/11/2004 : 08:48:03
|
Tara,
I did fresh install and now every thing looks good. I can connect to my VM machine from any client. |
|
|
|
Topic |
|
Multiple SQL Server 2000 Instances
