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 |
|
scottd
Starting Member
11 Posts |
 Posted - 2008-06-02 : 08:53:43
|
| Hi,We have SQL2000 sunning in a shared environment, specifically multiple instances of SQL, dbs and apps on a virtual server. If this server is rebooted, Our SQL comes back up running on a different port which affects one of our apps. This is a problem since our firewall guys will only open a specific port at a time.Can someone explain to me where the port selection is made? I mean is it as simple as the OS (Windows Server 2000/2003) or is it SQL server?What role does the operating system and SQL Server play in determining port selections? Also, can this setting be limited to one or two ports and should it? Thanks I know this is quite a bit of info.~Scott |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 20:30:28
|
| Don't use dynamic port in your case, specify static port for each instance in sql server network utility. |
 |
|
|
|
|
|
Ports and SQL