install. Service Pack 1 SQL2005 gives RTM product level

[stanja]

Hello,

I've installed the SQLServer2005SP1-KB913090-x86 and all went fine(no error messages) but when i check the version in SQL studio management it's still the same.
After installation it gives product version : 9.00.1399.06
product level : RTM
edition : standard
when it should give at least for the product level SP1

So how can i be sure that the installation is ok ?

tx
Stanja

 

[SQLBill]

How did you check the version? I always use this:

SELECT ServerProperty('Edition'),
 ServerProperty('ProductLevel'),
 ServerProperty('ProductVersion')

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

Find the physical sqlservr.exe file and right click properties on it. What version does it show? If that shows 9.00.1399.06 then the service pack definetly didn't install.

Run through the installer again. It should write a log somewhere and tell you what's happening.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[stanja]

sqlbill that is indeed the instruction i've been using.

mrdenny it shows indeed the version 9.00.1399.06 , how can this , it diidn't gave me any error messages during installation.

tx

Stanja

 

[SQLBill]

Which version of SQL Server 2005 are you running? MSDE, 32bit, 64 bit??? There is a different SP1 for each one and maybe you used the wrong one - even though I would expect it to show an error. Also, there are versions for the database, analysis services, reporting services, and the tools. You may want to confirm which you were installing. If you picked the wrong one by mistake, that would explain the lack of errors - you did upgrade, but not the database.

SP2 is out for SQL Server 2005, have you considered skipping SP1 and going with SP2?

-SQLBill

Posting advice: FAQ481-4875

 

[stanja]

i've used SQLServer2005SP1-KB913090-x86-ENU.exe because i have the following version
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

I've selected also all options to upgrade

Is this the wrong SP1 exe ?

grtz
Stanja

 

[SQLBill]

Nope, that looks like the right one.

There is a file where you can check to see what version it is, but at the moment I can't remember the name. Soon as I remember it, I'll post it - unless someone beats me to it.

-SQLBill

Posting advice: FAQ481-4875

 

[sqlsadie108]

Look at c:\windows\hotfix\hotfix.log(s) for the full story

 

[stanja]

sqlsadie i've checked the log and there were no error messages.
these are the last lines , indicating that everything was succesful
So what i'm i missing / doing wrong ???

02/04/2007 20:02:41.706 Attempting to install product: Redist9
02/04/2007 20:02:47.972 Successfully installed product: Redist9
02/04/2007 20:02:48.050 Reboot will be required
02/04/2007 20:06:18.393 One or more of the files patched have operations pending as they were locked by other processes running on the computer. Reboot your computer for the changes to take effect.
02/04/2007 20:06:18.393
02/04/2007 20:06:18.393 Product Status Summary:
02/04/2007 20:06:18.393 Product: SQL Server Native Client (64-bit)
02/04/2007 20:06:18.393 SQL Server Native Client (64-bit) (RTM ) - Reboot Required
02/04/2007 20:06:18.393
02/04/2007 20:06:18.409 Product: Setup Support Files
02/04/2007 20:06:18.409 Setup Support Files (RTM ) - Success
02/04/2007 20:06:18.409
02/04/2007 20:06:18.409 Product: MSXML 6.0 Parser (64-bit)
02/04/2007 20:06:18.424 MSXML 6.0 Parser (64-bit) (RTM ) - Success
02/04/2007 20:06:18.424
02/04/2007 20:06:18.424 Product: SQLXML4 (64-bit)
02/04/2007 20:06:18.424 SQLXML4 (64-bit) (RTM ) - Success
02/04/2007 20:06:18.424
02/04/2007 20:06:18.424 Product: Backward Compatibility (64-bit)
02/04/2007 20:06:18.440 Backward Compatibility (64-bit) (RTM ) - Success
02/04/2007 20:06:18.440
02/04/2007 20:06:18.440 Product: Microsoft SQL Server VSS Writer (64-bit)
02/04/2007 20:06:18.440 Microsoft SQL Server VSS Writer (64-bit) (RTM ) - Success
02/04/2007 20:06:18.440
02/04/2007 20:06:18.440 Hotfix package completed
02/04/2007 20:06:38.721 Hotfix package closed

 

[SQLBill]

Try this.

Find the file sqlservr.exe where you installed SQL Server. Right click on the file and select Properies. There should be a tab for Version. Match it to:

The following table lists the Sqlservr.exe version number: Release Sqlservr.exe
RTM 2005.90.1399
SQL Server 2005 Service Pack 1 2005.90.2047


-SQLBill

Posting advice: FAQ481-4875

 

[stanja]

product version : 900139906
file version : 20050901399.00
so it seems not to be upgraded.
Do i've to stop the sql services (and other ?) in order to perform the sp1 install. ?

 

[mrdenny]

The log that you posted doesn't show that you patched the SQL Server. It shows that the Driver, Support Files, MSXML parser, Backward Compatibility, and VSS writter were all upgraded but not the SQL Server. Rerun the SP1 installer and make sure to check the box to upgrade the SQL Service.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[stanja]

mrdenny ,
I thought that it would something like that , only the problem is that the SP1 checks the system and let's see what it's installed and ALL the options are selected.
So is it possible that the sql service for some reason isn't detected ??

 

[mrdenny]

Not that I can think so. Is it displayed on the screen when you run the installer for the service pack?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[stanja]

no , only those mentioned in the log above.

 

[mrdenny]

Is this 64 bit hardware? From the log it appears that it is and that you have the 64bit edition of SQL installed. The file name that you give at the begining is the 32bit service pack.

Try the 64bit service pack?

Are you sure that you are installing the service pack on the correct machine?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com