September 22, 2009 at 4:06 am
Hi there,
I have a SQL 2005 box with a instance called - MHSVI-OSMARTDB\LIVE
The server is called - MHSVI-OSMARTDB
This is currently at Service Pack 3 (Version 9.00.4035.00)
What do I need to do in order to create a new instance of SQL2005 on the same physical server.
I propose to call the instance interact.
I've read around the internet that I need to run the install again on the server. Is this correct?
Also will this instance be installed at Service Pack 3 also?
Thanks
Ryan
September 22, 2009 at 4:10 am
Ryan Keast (9/22/2009)
Hi there,I have a SQL 2005 box with a instance called - MHSVI-OSMARTDB\LIVE
The server is called - MHSVI-OSMARTDB
This is currently at Service Pack 3 (Version 9.00.4035.00)
What do I need to do in order to create a new instance of SQL2005 on the same physical server.
I propose to call the instance interact.
I've read around the internet that I need to run the install again on the server. Is this correct?
Also will this instance be installed at Service Pack 3 also?
Thanks
Ryan
Yes that is correct and no, you will need to apply the service pack once you have finished the install.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 22, 2009 at 7:07 am
That is correct, but you will not be able to run installation like normal because your server already has SP3 applied. That means your installer's version is lower that server's version, so you will get the error message.
You will have to run installation from a command line with a parameter SKUUPGRADE=1 in this case and apply SP3 after all as Silverfox said.
September 28, 2009 at 2:55 am
If I am installing another instance on a live production server (after testing) will it have any effect on the current instance that is running on there?
Do I need to stop the services of my current instance before I install the new one?
Thanks
September 28, 2009 at 4:28 am
Trying to install a second instance of SQL SERVER 2005.
The current instance is at SP3.
Running the install from command prompt of the SQL Server 2005 disk. As below
D:\Tools>setup.exe skuupgrade=1
This fires up the installer.
When doing the System Configuartion Check I get
To Change an exsisting instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Set up from Command Prompt and include the SKUUPGRADE=1 parameter.
But aren't I doing this already?
September 28, 2009 at 8:04 pm
During the installation, there is no opportunity to select the database instance before the setup program runs the checks and so therefore the installer must assume that the installation will be applied to the default instance. Continue with the installation and specify a name for the second instance; you would have no problems with the installation.
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic21511.aspx
MJ
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply