Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Installing a 2nd SQL Server 2008 named instance

Posted on 2012-04-03
3
Medium Priority
?
207 Views
Last Modified: 2012-04-04
Hey experts,

 I have an SQL Server 2008 named instance installed a Windows Server 2008 machine, and I want to install another named instance on that same server so I can have more control, but I couldn't find anywhere online how to do that; any help on doing it?

Note: The one installed is SQL Server 2008 R2 Enterprise Edition (64-bit)
0
Comment
Question by:mte01
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
Deepak Chauhan earned 1680 total points
ID: 37802451
if you are installation is graphical than  run  sql server setup.exe and fill the installation requirement  and follow the instructions but take a stop when  instance configuration page appear in this page you have have two options

1.default instance  2. named instance. Click on named instance radio button and fill the INSTANCE name in the text box ..

for step by step below url will help you

http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2008-step-by-step-guide.aspx
0
 
LVL 16

Expert Comment

by:Deepak Chauhan
ID: 37802634
OR INSTALLATION in console mode

Setup.exe /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>" /SQLSYSADMINACCOUNTS="<DomainName\UserName>" /AGTSVCACCOUNT="NT AUTHORITY\Network Service"


for more information

http://technet.microsoft.com/en-us/library/ms144259%28v=sql.100%29.aspx
0
 
LVL 3

Author Comment

by:mte01
ID: 37805431
>>deepakChauhan

Thanks deepakChauhan! That did the trick! So turns out installing a second named instance is the same as installing a first named instance (I had thought it should be different).
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question