Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 18,079 of 19,505    |
|    Erland Sommarskog to web12master@gmail.com    |
|    Re: two instances of mssql 2008    |
|    18 Jan 11 23:30:24    |
      From: esquel@sommarskog.se              m (web12master@gmail.com) writes:       > 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?              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@sommarskog.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              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca