Upgrading MS SQL Server 2000 to SP3a

DVD Polizei · 10-04-03, 01:38 AM

How in the hell do you do this? I don't know about this at all, as I have just started using it. I try to update with SP3 and I get:

"A strong sa password is required for security reasons. Please use SAPWD switch to supply the same...."

And I don't know where to input any code, either.

Any help?

X · 10-04-03, 11:19 AM

You need to go into the SQL Server Enterprise Manager and change the sa's password to a more secure one than you have now. You probably have a blank one now. Then apply the service pack.

10-04-03, 01:38 AM	#1
DVD Polizei DVD Talk Hero Join Date: Jan 2002 Location: Overpricedville, OR Posts: 36,738	Upgrading MS SQL Server 2000 to SP3a How in the hell do you do this? I don't know about this at all, as I have just started using it. I try to update with SP3 and I get: "A strong sa password is required for security reasons. Please use SAPWD switch to supply the same...." And I don't know where to input any code, either. Any help? __________________ Blu-ray Titles: ~380 \| HD DVD Titles: ~323 "I don't sell airplane parts. I've never sold airplane parts."

10-04-03, 11:19 AM	#2
X Administrator Join Date: Oct 1987 Location: AA- Posts: 10,144	You need to go into the SQL Server Enterprise Manager and change the sa's password to a more secure one than you have now. You probably have a blank one now. Then apply the service pack.