Solved

Installing a 2nd SQL Server 2008 named instance

Posted on 2012-04-03
3
191 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 15

Accepted Solution

by:
deepakChauhan earned 420 total points
Comment Utility
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 15

Expert Comment

by:deepakChauhan
Comment Utility
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
Comment Utility
>>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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now