SQL Server Performance Forum – Threads Archive
New Instance on Cluster
Hello. How do I create a new sql server instance on a virtual sql server in a cluster so that we can point to it: virtualsqlserversqlserverinstance Is it a new resource through cluster administrator? Thanks!KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;815431 fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
hi
> SQL Server 2000 has the ability to run multiple virtual instances on the same server at the same time
> Tools, COM components, and MDAC are shared among all instances
> Can support as many 16 instances on each cluster
> SQL registry settings are isolated between instances
> Clustering supports one default instance and multiple Named Instances For server Servername, instance “SQL2000â€, listens on:
NP: \.Pipe$$VIRTSQLMSSQL$Instancename sqlquery
TCP: Servername,1433
Default of “0†for named instances means dynamic selection of port by the server when it starts
UDP port 1434 is used for the new listener service
Exposes which instances are installed, their network endpoints, and so forth, to clients ………….well this wat i can help u
thank u
trinee dba failure is elder brother of sucess
]]>