2nd Post - Problem installing SQL Server 2005 Express SP2

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

2nd Post - Problem installing SQL Server 2005 Express SP2

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

2nd Post - Problem installing SQL Server 2005 Express SP2

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

2005Express trying to enable Full text indexing.

We have an installation of SQL2005 Express that was loaded via the "SQL2005Express with advanced services" download .exe.

Full text indexing wasn't enabled during installation.

It says to go to add/remove programs. Going that route when it goes to install FTI it says that it can't find the installation files in what looks to be the origonal "TEMP" folder created and removed during installation.

If I run the program installer from the download again it states that SQL is already installed and to use "add/remove programs".

We are stuck at this point. Is there an ISO available that could be burned to disk?

Thanks in advance.

We've seen this error a few times during Express reinstalls and I haven't heard of a nice solution. One option is to backup your databases, uninstall your Express instance and reinstall it with FTI enabled.

Thanks,
Sam Lester (MSFT)

|||

What you should be able to do is run the original program installer from a command line with the "\X" switch. This will display a dialog that will allow you to extract the files inside the package to wherever you want. You should be able to put them anywhere you like on you local hard drive. Then when you use Add/Remove programs to maintain your Express instance, and it asks for the files, make sure you browse to the "Setup" directory underneath where you extracted the bits. That should work without you having to uninstall your existing instance.

|||This will also be documented in the requirementssqlexp2005.htm file located at the root of the folder where you extracted out the bits. It is under the section titled "Modifying SQL Server Express Installed Components".|||After unpackaging using /x I get the following error, when trying to add FTI via the "add remove programs".

"The file G:\myfilepath is not a valid installation package for the product Microsoft SQL Server 2005 (SQLEXPRESS). Try to find the installation package 'sqlrun_sql.msi' in a folder in which you can install Microsoft SQL Server 2005 (SQLEXPRESS)."

The file is there in the folder.

Any other ideas short of uninstalling/reinstalling?|||

You need to make sure to browse to the "Setup" folder underneath where you extracted. If the setup folder is not there, than the extraction may not be correct. G:\myfilepath should contain a setup.exe file, and then a setup folder. In the setup folder there should be a bunch of MSIs, one of which is sqlrun_sql.msi.

Also, make sure the Sqlexpr.exe you are running to extract is the same as what was used initially to install. If the editions don't match than you could see that error as well. For example, don't mix and match SQL Express with SQL Express with Advanced Services.

|||I did point to the file in the setup folder (it was there).

This is the same .exe that was downloaded one month ago.|||I just tried this out myself and it does appear to work, so hopefully this should be easy to resolve. Could you post two logs so I can see what might be failing for you? Both the latest *_WI.log and *_SQL.log files would be needed (located in %programfiles%\microsoft sql server\90\setup bootstrap\log), thank you!|||

Sorry, I'm new here and didn't realize you can't post attachments. Here is what I need from the *_WI.log. Search for this string:

Doing action: ResolveSource

And then copy and paste the contents of the log up until this string:

ResolveSource. Return value

Let's just start with that, and then see if I need the *_SQL.log.

2005 Express Edition: installing full-text search

Hello,
I have installed SQL Server 2005 Express Edition Advanced Services and
SQL Server 2005 Express Edition Toolkit SP1. I cannot use full-text
search. When I called:

exec sp_fulltext_service 'load_os_resources', 1;
exec sp_fulltext_service 'verify_signature', 0;
go

I got error:

Full-Text Search is not installed, or a full-text component cannot be
loaded.

What should I do to be able to use full text search? Could you help me
please? I cannot find solution in Internet...
/RAM/On Wed, 19 Jul 2006 11:22:14 +0200, RAM wrote:

Quote:

Originally Posted by

>Hello,
>I have installed SQL Server 2005 Express Edition Advanced Services and
>SQL Server 2005 Express Edition Toolkit SP1. I cannot use full-text
>search. When I called:
>
>exec sp_fulltext_service 'load_os_resources', 1;
>exec sp_fulltext_service 'verify_signature', 0;
>go
>
>I got error:
>
>Full-Text Search is not installed, or a full-text component cannot be
>loaded.
>
>What should I do to be able to use full text search? Could you help me
>please? I cannot find solution in Internet...
>/RAM/

Hi RAM,

I just posted a reply to this question in the original thread. Let me
know if you can't find it!

--
Hugo Kornelis, SQL Server MVP