| Author |
 Topic  |
|
ricky_newbee
Posting Yak Master
126 Posts |
 Posted - 10/06/2004 : 15:15:13
|
| Every thing is so normal. Services are set to automatic and i am using the same port for the instances. |
 |
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:16:20
|
| I am using 1433 for one instance and 1533 for the other... |
|
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
Posted - 10/06/2004 : 15:18:34
|
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 |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:21:00
|
| No!! my client QA is not connecting to both instances . but i could able to connect to both instances from Query Analyzer |
|
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
Posted - 10/06/2004 : 15:21:45
|
I don't understand. Does it work from the server? Does it work from the client?
Tara |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:24:12
|
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. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
Posted - 10/06/2004 : 15:25:54
|
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 |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:27:32
|
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) |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:30:14
|
That's some thing i need to find out about the FireWall.
For EM i am using the same ServerName\Instance Name. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
Posted - 10/06/2004 : 15:30:34
|
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 |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:33:07
|
| No!! There is no Default instance. Is it necessary to install atleast 1 default instance. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
Posted - 10/06/2004 : 15:35:17
|
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 |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:40:38
|
Database Server:
ServerName\Instance1 1433 ServerName
ServerName\Instance2 1533 ServerName
Client:
ServerName\Instance1 1433 ServerName
ServerName\Instance2 1533 ServerName
|
|
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
Posted - 10/06/2004 : 15:42:21
|
That should work then. I think you've either got a firewall in between these two machines or some network problem causing this.
Tara |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:42:56
|
In Server Network Utility(Server Site)
I have enable only one TCP/IP and Using
ServerName\Instance1 1433
ServerName\Instance2 1533
|
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:44:25
|
| 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. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
Posted - 10/06/2004 : 15:45:42
|
In EM, try using ServerName,1533. Does that work?
Tara |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:50:46
|
| No Luck Tara!! |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:51:39
|
| But why does it say SQL Server does not exist. |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 10/06/2004 : 15:53:33
|
| Error: Servername\Instance: SQL Server does not exist or access denied. ConnectionOpen(Connect) |
|
|
|
Topic |
|
Multiple SQL Server 2000 Instances
