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,081 of 19,505   
   Erland Sommarskog to web12master@gmail.com   
   Re: two instances of mssql 2008   
   19 Jan 11 08:37:11   
   
   From: esquel@sommarskog.se   
      
   m (web12master@gmail.com) writes:   
   > So every time we made restart named instance will get different port.   
      
   Not really. First time it will make a choice, on restart the port will be   
   resued unless some other program have grabbed it.   
      
   > Can we manage for named instance to have static port?   
      
   Yes, you can set this up in the SQL Server Configuration Manager.   
      
      
      
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Books Online for SQL Server 2005 at   
   http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx   
   Books Online for SQL Server 2000 at   
   http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- 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