DVD Talk
Upgrading MS SQL Server 2000 to SP3a [Archive] - DVD Talk Forum
 
Best Sellers
1.
2.
3.
4.
5.
6.
7.
8.
The Longest Day
Buy: $54.99 $24.99
9.
10.
DVD Blowouts
1.
2.
3.
4.
5.
6.
7.
Alien [Blu-ray]
Buy: $19.99 $9.99
8.
9.
10.

PDA
DVD Reviews

View Full Version : 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.