multiple instances in a single system

Question

multiple instances in a single system

venki.ffcl

Old Hand

Points: 326
More actions
December 29, 2008 at 5:47 am

#197971

hi friends,
Can i have two or more instances of sql server running in my machine and access the same simultaneously. If yes how?
Please help...
thank you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Dugi SSCoach Points: 17998 More actions · Answer 1

venki.ffcl (12/29/2008)
hi friends,
Can i have two or more instances of sql server running in my machine and access the same simultaneously. If yes how?
Please help...
thank you

I see you question is also there : http://www.sqlservercentral.com/Forums/Topic626499-359-1.aspx

Don't do double post plz and post in right section!

Yes you can run multiple instances in SQL Server Express also in Standard or Enterprise editions!

You should install again the SQL Server and during installation you will installed named instance, simply you will give a name for second instance. The first one is default instance and as usually it has the machine name! You can connect with SSMS same like default instance but you should check the combo box and you will see the list of all installed instances!

The same is also with SQL Server other editions Standard or Enterprise!

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Lowell SSC Guru Points: 323518 More actions · Answer 2

yes of course you can have multiple instances...and the instances can be different versions as well;

simply re-run the installation CD or msi...one of the steps is a prompt that asks you to install a default or named instance;

choose a named instance, and the next step is what the name is...something like on my machine I've got MACHINENAME\SQLEXPRESS, as well as a default instance....so I could create an additional named instance, say MACHINENAME\SQL2005 or whatever name you desire.

although it's easy to do and supported, you yourself need to determine whther you really need a whole additional SQL service running, or whether simply adding a new database will do the job for whatever you want to do.

At one point, I had SQL7 as a default, SQL2000 and SQL 2005 both as named instances, and the only reason was for customer support in case I needed to return a database for testing...I could create a backup to SQL 7 and send to clients that hadn't upgraded yet....nwo I'm 2005 only, but will install 2008 as another named instance soon.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!