Trouble added a new Nmaed Instance

[jpotucek]

I have a Windows Server hosting our SQL Server 2005 (Standard Edition) Databases.

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:

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.


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?

 

[mrdenny]

Go through the installer again and only select the database engine. Don't select anything else.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[jpotucek]

mrdenny,

My company's internet policy will not let me go to box.net 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..

 

[mrdenny]

Are you sure you aren't running the SQL Express Management Studio installer or something else funky?

Are the other options there but greyed out, or not there at all?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog