Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Multiple MSDE instances in WinXP SP2

Author  Topic 

zawmn
Starting Member

2 Posts

Posted - 2007-03-17 : 10:22:58
I have installed two mssql 2000 MSDE sp4 instances on WinXP SP2.
I can connect both instances from local machine.
But when I try from remote PC, I can only connect to one with default instance name and can't connect to another one ComputerName\InstanceName.

I set the windows firewall off in WinXPSP2. But still can't connect.

I also try with mssql2000 MSDE sp3 instances. It is same ask sp4.
Please help!!!!!!

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-03-17 : 11:00:12
May be it can't resolve the port number for named instance, so pass the port number along with Intance name...
ComputerName\InstanceName,PortNumber
You can get the port number from Client Network utility/Server properties...
http://www.sqlmag.com/Article/ArticleID/38444/sql_server_38444.html


MohammedU
Go to Top of Page
   

- Advertisement -