Cannot Install Service Pack 2!!!!!!!

[07974]

I keep getting the error message: Error running script: SP1_repl.sql(1) Has anybody seen this before or can anyone shed any light on the situation, I am using my sa login.... any suggestions

Thanks in advance

 

[bperry]

You don't mention the version, or the OS, but here's a report at Microsoft that mentions your error: seems to have something to do with the authentication mode? use SQL instead of Windows NT ??

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303680

 

[07974]

Thanks for the response, I'm running a windows 2000 IBM server with SQL 2000 and currently no service packs, I will check your link... Thanks very much

 

[07974]

I have looked at that page already, it seems to be refering to a similar problem but its on a 98 machine and i've tried doing what it says in the article and it doesn't work.

I am using the sa acount for authentication with a blank password but still doesn't seem to work, even with the setup.ini edited to read UPGRADEUSER:sa!!!

HELP... I'm losing my patients!!!

 

[carrr]

Obtain and install service pack 1 before jumping into sp2.

 

[07974]

I have also tried that, installing SP1 first, but seen as the service packs are cumulitive this results in exactly the same error message at exactly the same point.

 

[carrr]

OK. Here's something I came across. Maybe this will help.

http://dbforums.com/archive/70/2001/10/3/166308

 

[07974]

Thanks, I've printed that off already, seems those two pages are the only ones out there regarding this problem. I will try it tommorow and post the outcome on this thread

Cheers anyway, I can only hope editing that registry key helps.