SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Multiple SQL Server 2000 Instances
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 4

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2004 :  16:00:59  Show Profile  Visit tkizer's Homepage  Reply with Quote
And if you try ServerName,1533 in QA, it works on the server?

Tara
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  16:28:51  Show Profile  Reply with Quote
No It doesn't work
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2004 :  16:31:21  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2004 :  16:34:29  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  16:43:26  Show Profile  Reply with Quote
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
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  16:47:59  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2004 :  18:06:46  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/07/2004 :  08:32:26  Show Profile  Reply with Quote
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
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 10/07/2004 :  10:14:27  Show Profile  Send jen a Yahoo! Message  Reply with Quote
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?
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/07/2004 :  10:58:34  Show Profile  Reply with Quote
Didn't get your question?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/07/2004 :  12:27:54  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/07/2004 :  13:03:18  Show Profile  Reply with Quote
My Mistake Tara...

Instance1 is 1433
Instance2 is 1533
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/07/2004 :  13:04:57  Show Profile  Visit tkizer's Homepage  Reply with Quote
Your registry entries should be:

Server:
Instance1- DBMSSOCN,Server,1433
Instance2- DBMSSOCN,Server,1533

Client:
Instance1- DBMSSOCN,Server,1433
Instance2- DBMSSOCN,Server,1533

Tara
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/07/2004 :  13:08:40  Show Profile  Reply with Quote
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...
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/07/2004 :  13:15:38  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/07/2004 :  14:21:48  Show Profile  Reply with Quote
Yes! Tara...I would like to do that...
Thanks for your help...I shall post message once i am done with install process
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

Australia
4970 Posts

Posted - 10/08/2004 :  00:35:37  Show Profile  Visit Merkin's Homepage  Reply with Quote
Who's on first ?



Damian
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/11/2004 :  08:48:03  Show Profile  Reply with Quote
Tara,
I did fresh install and now every thing looks good. I can connect to my VM machine from any client.
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000