Upgrading MS SQL Server 2000 to SP3a [Archive]

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


Best Sellers
1.	Man With The Plan
2.	Something New
3.	Nightmare in Silver
4.	Watershed
5.	Whines By Wives
6.	Dexter: The Seventh Season Buy: ~~$54.99~~ $24.99
7.	And Straight On 'Til Morning Buy: ~~$54.99~~ $24.99
8.	The Longest Day Buy: ~~$54.99~~ $24.99
9.	Man With The Plan [HD] Buy: ~~$54.99~~ $24.99
10.	For Immediate Release Buy: ~~$54.99~~ $24.99

DVD Blowouts
1.	Downton Abbey Seasons 1 & 2 Limited Edition Set - Original UK Version Buy: ~~$59.99~~ $44.99
2.	Saving Private Ryan (Sapphire Series) [Blu-ray] Buy: ~~$24.99~~ $16.91
3.	Anchorman: The Legend of Ron Burgundy (Unrated Widescreen Edition) Buy: ~~$12.98~~ $7.83
4.	Swamp People: Season 1 Buy: ~~$24.98~~ $5.99
5.	The Odd Life of Timothy Green Buy: ~~$29.99~~ $17.99
6.	Bambi (Two-Disc Edition) Buy: ~~$29.99~~ $18.33
7.	Alien [Blu-ray] Buy: ~~$19.99~~ $9.99
8.	Gi Joe: The Rise of Cobra [Blu-ray] Buy: ~~$22.98~~ $12.99
9.	Brazil (Criterion Collection) [Blu-ray] Buy: ~~$49.95~~ $27.99
10.	American Beauty (Widescreen Edition) Buy: ~~$12.99~~ $9.99

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?

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.