Different instances of SQL Server

Hi there,

I was wondering if it's possible to create a new instance in the SQL Server something like this:

(Local)\\MSSMLBIZ

(Local)\\BUSINESS

Thank you

yes you can create as Server name \\ instance name where the Server name can be the same.......i have 3 instances where my server name is Deepak\\instance1 similarly instance2 and instnace3

|||

you can have multiple instances on one physical machine. One Defualt instance and all others are called Named Instance. Default instance will have same physical machine name. all other will have Physical machine name \Name of the instance

sql server 2005

sql server 32 bit 64 bit

Instances per computer

50 instances on a stand-alone server for all SQL Server 2005 editions except for Workgroup Edition. Workgroup Edition supports a maximum of 16 instances.

SQL Server 2005 supports 25 instances on a failover cluster.

50 instances on a stand-alone server.

25 instances on a failover cluster

http://technet.microsoft.com/en-us/library/ms143432.aspx

Madhu

|||

Does it apply to SQL Server Express? if yes how do I create (Local)\Myinstance in C#? or if I can't do it in C#, how do I create it manually?

Thank you

|||

Yes. You need to re-run setup to create a new instance of sql server with instance name = "MyInstance". The instance name page is on one of pages in the setup wizard. There is no way to automate creating a new instance with C# with an API like SMO. You can invoke setup with parameters to specify things like instance name, and run setup without user intervention. There is more information in BOL.