June 14, 2006 at 8:42 am
Hi !
I have a terrible annoying bug when I install the SP4.
I have some SQL Server 2k with replication. To correct other bugs, I must install the SP4.
In almost all of my company‘s servers, The SP4 was installed without any problems but one of my server is really crazy.
When I run the install, It doesn’t ask any questions. It doesn’t ask for authentication mode, for instance name. Nothing. It just ask for the CLUF and say that it have enough information to start the install.
I start it but it just coping some files (2-3 temp files), registering activeX, etc.. Any important files are copied. At the end, it say that files are copied and doesn’t ask to reboot.
When I go to the server properties, it’s always the SP3a and not the SP4. grrr…
When I read the file sqlsp.log, two lines intrigues me.
« 11:41:30 This machine has SQL Server 2000 SP4 already installed
11:41:30 Version of installed Service Pack: 8.00.2039 »
IT’S NOT TRUE !! SP4 ISN’T ALREADY INSTALLED!!!!!
How can I force the installation or correct this wrong information (that it’s already installed) ????
Because I’m in a really stressed situation!
Please! Help-me !!!
Thanks
June 15, 2006 at 7:22 am
When you execute SELECT @@VERSION, what do you get back? Also, when you check the sqlservr.exe file, what does the file version say?
K. Brian Kelley
@kbriankelley
June 15, 2006 at 8:37 am
quote: At the end, it say that files are copied and doesn’t ask to reboot.
Have you rebooted it anyways? I seem to recall that there is at least one condition where it won't ask to reboot - I think it's if the services are stopped. But there might be others.
-SQLBill
June 15, 2006 at 9:00 am
I rebooted couple of time (each time that I try to install it). It doesn’t change the SP.
SELECT @@version gives me that result
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
And sqlserv.exe is the old one (~7345 Ko and Not ~8936 Ko).
The instance is installed on C:\Program Files\MSSQL and not in C:\Program Files\Microsoft Sql Server\MSSQL ….Maybe it can affect the installation but I don’t think so…
I cannot reinstall the server…it’s too much work (and I already have a lot of work….) and I have a big replication topology…..
Thanks for your help....Hope I will do it..
June 15, 2006 at 10:54 am
This is an MSDE instance. Are there any other instances of SQL Server on this machine?
K. Brian Kelley
@kbriankelley
June 15, 2006 at 12:01 pm
I'll second BKelly's comment......I'll bet you have more than one instance and just keep updating the default instance. You MUST apply service packs to each instance even if they are on the same server.
-SQLBill
June 16, 2006 at 12:48 am
Effectively, I think that MSDE is installed. But How can I specify the instance. If I uninstall MSDE. DO you think it will works ???
I'll try.....
June 16, 2006 at 6:06 am
I believe that when you run the install there is a window where it asks for the instance and has a checkbox for default. Check or uncheck the box as needed. I believe when you uncheck it, it might then show a drop down with the named instances you have installed.
-SQLBill
June 16, 2006 at 6:15 am
No. It doesn’t ask for the instance....it's the entire problem. It says directly that it have enough information to install.
Hope it'll work this week-end. It's my time limit.........
June 16, 2006 at 6:18 am
Okay...I understand...My predecessor installed MSDE....Not SQL server 2000....I will try MSDE service pack on this place.
June 16, 2006 at 10:52 am
Aha.......it's those little details that cause problems all the time.
Glad you figured it out.
-SQLBill
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply