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.
| Author |
Topic |
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
 Posted - 2010-05-14 : 13:27:45
|
| Hi, I recently did a fresh install on a Windows 2003 SP2 server, I installed SQL Server 2008 first as the default instance, then I installed Windows Server 2000 Developer edition as a new instance (called SQL2000). I can connect remotely to the SQL Server 2008 machine no problem, but I can't see the 2000 instance at all, even when I use [servername]\SQL2000. Is it because they are sharing the same port? Any suggestions? thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-05-14 : 13:39:36
|
| Thanks for the reply, I have done in that order locally, but not on a server. How do I change the port? I know I can change the port in the Network Client Utility, what should I change it to? I tried changing it to 1434 but that didn't work. thank you. |
 |
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-05-14 : 13:52:39
|
| Actually, I followed this link [url]http://www.serratedsoftware.net/Blog/tabid/54/EntryID/21/Default.aspx[/url]and discovered that it was listening on port 2359. I was able to connect using [servername]\SQL2000,2359. Thanks for your help! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Installing 2000 Instance on SQL Server 2008 mchn
It's recommended to use a port with 5 digits (>=10000) for security reasons.Tara Kizer