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 | Next Page
Author Previous Topic Topic Next Topic
Page: of 4

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:15:13  Show Profile  Reply with Quote
Every thing is so normal. Services are set to automatic and i am using the same port for the instances.
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:16:20  Show Profile  Reply with Quote
I am using 1433 for one instance and 1533 for the other...
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2004 :  15:18:34  Show Profile  Visit tkizer's Homepage  Reply with Quote
From the database server, open up QA and try connecting via:

ServerName,1533

Does that work from the server?

If so, then do the same on the client machine. Does that work?

Tara
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:21:00  Show Profile  Reply with Quote
No!! my client QA is not connecting to both instances . but i could able to connect to both instances from Query Analyzer
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2004 :  15:21:45  Show Profile  Visit tkizer's Homepage  Reply with Quote
I don't understand. Does it work from the server? Does it work from the client?

Tara
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:24:12  Show Profile  Reply with Quote
Connecting through QA from Server works.
From server side i could able to connect to both instances using QA, but i could able to see only 1 instance from EM. I tried to register the other, it says SQL Server does not exist.

And from client site, using QA i couldn't connect to these instances.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2004 :  15:25:54  Show Profile  Visit tkizer's Homepage  Reply with Quote
On the server when trying to connect with EM, you must be using the wrong server name as if it works in QA then it'll work in EM.

On the client, is there a firewall between your machine and the databse server? If so, then you'll need to have the firewall administrator punch a hole in the firewall for port 1533.

Tara
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:27:32  Show Profile  Reply with Quote
Are there any other services which i need start..
MSSQL$Instance1(Automatic and started)
MSSQL$Instance2(Automatic and started)
SQLAGENT$Instance1(Automatic and started)
SQLAGENT$Instance2(Automatic and started)
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:30:14  Show Profile  Reply with Quote
That's some thing i need to find out about the FireWall.
For EM i am using the same ServerName\Instance Name.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2004 :  15:30:34  Show Profile  Visit tkizer's Homepage  Reply with Quote
I thought you only had one named instance and the other was the default instance. So you would have:

MSSQLSERVER
MSSQL$Instance1
SQLSERVERAGENT
SQLAGENT$Instance2

Tara
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:33:07  Show Profile  Reply with Quote
No!! There is no Default instance. Is it necessary to install atleast 1 default instance.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2004 :  15:35:17  Show Profile  Visit tkizer's Homepage  Reply with Quote
No it's not. It's just that the default instance usually uses 1433. It doesn't matter.

Could you (once again, I know) post the details of each alias? You should have two, one for each instance. Make sure they are the same on both the client and the database server (although the database server is smart enough to know about itself).

Tara
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:40:38  Show Profile  Reply with Quote
Database Server:

ServerName\Instance1 1433 ServerName
ServerName\Instance2 1533 ServerName

Client:
ServerName\Instance1 1433 ServerName
ServerName\Instance2 1533 ServerName
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2004 :  15:42:21  Show Profile  Visit tkizer's Homepage  Reply with Quote
That should work then. I think you've either got a firewall in between these two machines or some network problem causing this.

Tara
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:42:56  Show Profile  Reply with Quote
In Server Network Utility(Server Site)

I have enable only one TCP/IP and Using

ServerName\Instance1 1433
ServerName\Instance2 1533
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:44:25  Show Profile  Reply with Quote
I hope you are right in Client case. Why isn't EM (Server Site) able to connect to an Instance which is using 1533 port.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2004 :  15:45:42  Show Profile  Visit tkizer's Homepage  Reply with Quote
In EM, try using ServerName,1533. Does that work?

Tara
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:50:46  Show Profile  Reply with Quote
No Luck Tara!!
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:51:39  Show Profile  Reply with Quote
But why does it say SQL Server does not exist.
Go to Top of Page

ricky_newbee
Posting Yak Master

126 Posts

Posted - 10/06/2004 :  15:53:33  Show Profile  Reply with Quote
Error: Servername\Instance: SQL Server does not exist or access denied. ConnectionOpen(Connect)
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Previous Page | Next 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.11 seconds. Powered By: Snitz Forums 2000