DVD Talk
Upgrading MS SQL Server 2000 to SP3a [Archive] - DVD Talk Forum

PDA

View Full Version : Upgrading MS SQL Server 2000 to SP3a


DVD Polizei
10-04-03, 02: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, 12:19 PM
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.


Content Relevant URLs by vBSEO 3.2.0