Hi,
I started applying "SQL server Express with advanced tools SP2" and had to stop on following items which I'm not too sure about what I must understand from step "Existing components". Those three items listed were:
- "SQL Server DataBase Services 9.1.2047.00"
=> which I can check
- "Reporting Services 9.1.2047.00"
=> which I can check
- Workstation components and development tools 9.1.2047.00
=> which is simply disabled?
If I then look at the details of that last item, I can see the following warning:
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.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Now, following the suggestion of one person answering previous thread,
"If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change..."
I followed suggestion and got following result:
DEVELOPPEMENT
The following components are installed on this server
SQLEXPRESS
Database Engine
[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]
Reporting Services
[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]
Common components
Workstation Components
[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]
Looking at the results, everything seems to be normal. Only Express Edition, all same level which should be SP1. What step should I take to be able to upgrade to SP2 properly?
Thanks in advance,
Stphane
P.S.
From "Add/Remove Programs" I have, all listed, the following SQL Server installed programs:
- Microsoft SQL Server 2005
- Microsoft SQL Server 2005 Backward compatibility
- Microsoft SQL Server 2005 Books Online (English) (July 2006)
- Microsoft SQL Server 2005 Compact Edition (ENU)
- Microsoft SQL Server 2005 Compact Edition Books Online (ENU)
- Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit (ENU)
- Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 (ENU)
- Microsoft SQL Server Management Studio Express
- Microsoft SQL Server Native Client
- Microsoft SQL Setup Support Files (English)
- Microsoft SQL Server VSS Writer
Hi,make sure you are applying the same language SP as the base installation. Cross language updates are not supported.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
Hi Jens,
Today, following your note, I downloaded again same SP2 install program from following link:
http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en
I then compared the downloaded program with the one I originaly used to apply SP2 and could verify that they were the same. As a conclusion, I can conclude that I was using SP2 English language version, same language my current setup is using. So, if I'm OK, I think that the language might not be the issue of my problem. Any other hint?
Thanks for your help, hope to hear back!
Stphane
|||
Hi Stephane,
Missed your response in the other thread, sorry.
I can see that your tools are from the Express Edition, but that still may be mis-leading. Did you ever installed the Express Edition Toolkit? Since the tools are shared, each flavor of Express (Express -> Express Advanced -> Express Toolkit) contains a super-set of the tools from the previous flavor. If you installed the Express Edition Toolkit then you will need to install the Express Edition Toolkit SP2 update to update the Workstation Components. The report in Add/Remove Program can't tell the difference between the three flavors of the tools in Express, so it shows them all as Express Edition.
If you want to check the actual flavor of the tools before you download the Toolkit update (but what would be the fun of that!) You can do so in the registry at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup. Look at the Edition Type value and it will show the actual flavor that installed the tools.
Mike
|||Hi,
Many thanks for follow-up! I really appreciate. Lots of infos in your reply! Let's start.
Yes, I have the Express Edition Toolkit SP1 currently installed on my machine. For the registry value you refer to:
"You can do so in the registry at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup. Look at the Edition Type..."
The value I get from registry is the following: "Express Edition Toolkit".
As a conclusion, should I understand that I must apply the "Express Edition Toolkit SP2" before applying the "SQL Server 2005 Express with advanced Services SP2"?
Many thanks again for your help,
Stphane
|||Hi again,
I'm still stuck with my problem. Following explanations from Mike, a question still remain:
Starting from the fact that I originally applied SP1 with success using following sequence:
SQL Server 2005 Express Edition with advanced services SP1
SQL Server 2005 Express Edition Toolkit SP1
and that I could verify, following Mike's suggestion, that all SQL Server Software found in registry (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90...) are listed (vs Edition type) as Express editions:
==> Should I apply the "Express Edition Toolkit SP2" before applying the "SQL Server 2005 Express with advanced Services SP2"?
Many thanks for your support,
Stphane
|||Hi everyone,
For follow-up of this discussion, please read following thread:
http://forums.microsoft.com/forums/ShowPost.aspx?PostID=1307730&SiteID=1
Stphane
No comments:
Post a Comment