By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,265 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,265 IT Pros & Developers. It's quick & easy.

instance of sql server

P: n/a
I am learning SQL Server 2005 and I was told to install a second instance of
SQL Server 2005 on my machine. How can I install a second instance of SQL
Server 2005 on my machine

I already installed SQL Server 2005, I guess this is my first instance. To
install a second instance, do I just run setup again?
Apr 23 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Yes, just run setup again to create a 'named' instance. Setup will ask you
for an instance name.

A computer can have up to 1 default instance (probably what you installed
initially) but many named instances. To connect to the default instance
after installation, specify only the computer name. For the named instance,
specify computer name and instance name separated by a backslash
('ComputerName\InstanceName').

--
Hope this helps.

Dan Guzman
SQL Server MVP

"David" <da*******@hotmail.com> wrote in message
news:bM********************@comcast.com...
I am learning SQL Server 2005 and I was told to install a second instance
of SQL Server 2005 on my machine. How can I install a second instance of
SQL Server 2005 on my machine

I already installed SQL Server 2005, I guess this is my first instance.
To install a second instance, do I just run setup again?

Apr 23 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.