home bbs files messages ]

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