Installing a third Named Instance

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Installing a third Named Instance

Author

Topic

itsonlyme4
Posting Yak Master

109 Posts

Posted - 2009-10-02 : 09:40:04

I have a Windows Server hosting our SQL Server 2005 SQL Server Databases at SP3

I have a Default and two named instances and I need to add a third named instance.

These are the steps I am taking :
Run SQL Server 2005 Setup
accept licensing agreement.
Installing prerequisites - required componnets successfully install - click next
Performs system configuration check
System configuration check throws one warning:

quote:
To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.

Registration information - Next
Feature Selection - choose all and click Next

Next screen - get an error that setup is blocked:

Name: Microsoft SQL Server 2005 Tools
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

quote:
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.

Have idea what I'm doing wrong.. I've tried the process through Add\Remove Programs and I get the same results. can anyone help?

ddamico
Yak Posting Veteran

76 Posts

Posted - 2009-10-02 : 14:54:43

I believe this is only a warning, meaning that one of the current version is already at a new version. You should just upgrade the new instnace to SP3 once the install is complete.

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2009-10-05 : 09:06:53

ddamico,

My company's internet policy will not let me go to box.net or other file sharing sites to upload a word doc with screenshots.. (I could email it to you) but this is what I get when I run the sql server standard edition 2005 setup.exe:
- except EULA
- System Configuration check (warning on edition check)
- registration screen
- Feature selection screen - only choices it gives me are
client components and documention!!!??????

It's like it is not recognizing that I have multiple Instances. I installed SP3 a couple of weeks ago and that went fine.. updated all instances..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources