Installed SQL Server 2000 Std Service Pack 4 - but Still Shows as RTM? 1

[JohnBates]

hi all,

Do I get a prize for posting the most questions within a 24-hour period? Didn't think so

Earlier today, I installed SQL Server 2000 Std onto a new server. Including the Analysis Services.

Just now I ran 2 of the install files for Service Pack 4
(the Database Components download and the Analysis Services Components download).

Rebooted server.

Problem: When I run Select @@version, it still shows the RTM version (8.00.194)

Note: No service packs were installed before I installed SP4.

The other 2 .EXE files for SP4 are related to the Desktop Engine and 64-bit components (we have the Std version so this should not be necessary for my instance of Sql Server, I think.)

Why does SQL Server not reflect SP4 now? is there another way to check which Service Pack is installed?

Thanks very much. John

 

[mrdenny]

Find the sqlservr.exe right click on it, properties. On one of the tabs you can see the version. If this hows 8.00.194 then you are RTM.

When you download the service packs and run them, all they do it decompress. They don't actually install. Look in the C:\ drive and you'll see a SQLSP4 folder (or something like that). In there run the setup.bat which will launch the actual installer. Same goes for the Analysis Services (it's in a sub folder named OLAP or something).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

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

http://www.mrdenny.com

 

[JohnBates]

Thanks Denny.

Ran the setups, now everything is good.
John

 

[lilboi]

Hi guys,

I'm doing update right now as well.

I just installed the AS update of sp4.

Do i need to update the MSDE? Also, how can i tell if I have a 32bit or a 64bit sql? I'm running a SQL 2000 Server.

Thanks

 

[mrdenny]

Unless you got a 64bit version from Microsoft (and you have SQL 2000 Enterprise) you have the 32bit. (You'll also need to have 64bit hardware of course.)

Assuming that you have the 64bit Windows on 64bit hardware, open the task manager. Find the sqlservr.exe process. If it says 32-bit next to it, then you have the 32bit edition. If it doesn't say 32-bit, then you've got the 64bit edition.

There are also an SP4 install for MSDE and yes it should be applied.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com

 

[lilboi]

thanks Mr. Denny

I installed the 32-bit as well. But while trying to install the MSDE, i foudn that I have to specify the "instance name" and "instance directory". What are my instance name and directory? How do i find this out?

 

[mrdenny]

You can install more than one copy of SQL Server 2000 or 2005 on a machine. This is done by having instances. Each instance is a copy of the server running and is intependant of any other instances which are running on the server.

The instance name is the unique name for the instance on the machine.

To connect to a named instance you connect to ServerName\InstanceName.

There should be a checkbox on the installer to select the default instance so that you can connect via just the name of the server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com