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.
| Author |
Topic |
|
robmo
Starting Member
4 Posts |
 Posted - 2008-09-03 : 21:18:53
|
| Hi,I need to be running SQL 2005 SP2 for a application.I am running SBS 2003 and installed SQL 2005 Standard with SP1 and did a down load of SP2 and did the install the Product version is 8.0.2050 SP4 but I need it to be 9.0.3042.I have followed all the upgrade paths but cant seam to get the correct version running.Any help would be great or pointers.thanksRob |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-03 : 22:10:15
|
| How did you install 8.0.2050 SP4(SQL 2000) in SQL 2005? You must be confused. 9.0.3042 is SP2 for SQL 2005. |
 |
|
|
robmo
Starting Member
4 Posts |
Posted - 2008-09-03 : 23:37:06
|
| HI,What happened was I was asked to install in SQL 2005 on the server, So put the 2005 disk in and did the install.I thought that would just do a upgrade to 2005 from 2000.I now get this message, but can find the Syntax for it.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. |
|
|
|
robmo
Starting Member
4 Posts |
Posted - 2008-09-08 : 01:17:51
|
| Managed to run the SKUUPGRADE but when you open SQL management Studio it still shows 8.0.2050,Any further pointers?thanks |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-09-08 : 11:46:10
|
| It sounds like you have two instances of SQL Server installed. One is SQL 2000, and one is SQL 2005. Check in the Services applet to see what you have for services that start with "MSSQL" and "SQL Server" |
|
|
|
robmo
Starting Member
4 Posts |
Posted - 2008-09-08 : 20:59:47
|
| Looks like you are right what is the best way to just use the 2005 instances? |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-09-09 : 10:54:14
|
| You will have to change each application that connects to the SQL 2000 instance, to connect to the SQL 2005 instance. How to do that varies greatly from application to application, though. Once that is done, though, you can shut down the SQL 2000 instance for a month or so, and if no one notices, uninstall it. |
|
|
|
|
|
|
|
|
SQL Server 2005 incorrect version