Hello everybody,

does anybody know in case we have two instances of mssql 2008 installed on
the same machine do they need to work on different ports?
one of them on 1433 (default mssql) and the other on some other port?

thanks,

regards

m wrote:
You can leave the ports as they are; see
http://msdn.microsoft.com/en-us/libr...sql.90%29.aspx for an
explanation of what SQL Server Browser does.

--
Andrew

m (web12master (AT) gmail (DOT) com) writes:
Yes, you cannot have two servers listening on the same port. As Andrew
says, you don't take any extra precaution for this to happen. A default
instance will use port 1433, and a named instance will use a dynamic port.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Thanx for help.

So every time we made restart named instance will get different port.

Can we manage for named instance to have static port?
This is important for firewall configuration.
If we have different ports after every restart we should applay that changes
to firewall configuration, this makes extra work?

Thanx.



"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

I have found what I'm looking for
http://msdn.microsoft.com/en-us/libr...v=sql.90).aspx

thanx again.

Regards

"m" <web12master (AT) gmail (DOT) com> wrote

m (web12master (AT) gmail (DOT) com) writes:
Not really. First time it will make a choice, on restart the port will be
resued unless some other program have grabbed it.

Yes, you can set this up in the SQL Server Configuration Manager.





--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx