running sp_password for MSDE upgrade

From: Rick Hollinbeck (rickh-msnews@westernwares.com)
Date: 01/30/03

Next message: Carlos Souza: "Re: Need to Re-Index after SP4 on SQL7 ?"
Previous message: Richard Waymire [MS]: "Re: SQL Service Not Starting"
Next in thread: SQLServer Development Team[MSFT]: "Re: running sp_password for MSDE upgrade"
Reply: SQLServer Development Team[MSFT]: "Re: running sp_password for MSDE upgrade"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

From: "Rick Hollinbeck" <rickh-msnews@westernwares.com>
Date: Thu, 30 Jan 2003 12:22:49 -0700

Updating my full SQL Server to SP3 was easy because
sql2ksp3 prompted me to enter a new non-blank sa password.

I'm now trying to update the MSDE that was installed as part of my
.NET development environment.

After downloading sql2kdesksp3 and figuring out the proper setup command
line to update the
VSdotNET instance from the readme, setup won't run, telling me to set a
non-blank
sa password with sp_password.

Dumb question: how do I do this? - readme doesn't say.

Thanks

Next message: Carlos Souza: "Re: Need to Re-Index after SP4 on SQL7 ?"
Previous message: Richard Waymire [MS]: "Re: SQL Service Not Starting"
Next in thread: SQLServer Development Team[MSFT]: "Re: running sp_password for MSDE upgrade"
Reply: SQLServer Development Team[MSFT]: "Re: running sp_password for MSDE upgrade"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: 1 server 2 SQL apps
... Does it make sense in this situation to use MSDE 2000 SP3, ... MSDE has a limitation of 2 GB per database as well as you will not get the ... clients lke query analyzer, Enterprise manager. ... Best option for you might be, Install a default installation of SQL server ...
(microsoft.public.sqlserver.server)
Re: SP3 for MSDE 2000
... instances of SQL Server and MSDE. ... International customers should call their local subsidiaries. ... > Better than that - I just found out that the default new instance that SP3 ...
(microsoft.public.sqlserver.security)
Re: SP3 for MSDE 2000
... instances of SQL Server and MSDE. ... International customers should call their local subsidiaries. ... > Better than that - I just found out that the default new instance that SP3 ...
(microsoft.public.security)
Re: SQL Patch not working on Professional
... Then you have MSDE and need to download the MSDE patch. ... > the information saying system info the version shows SQL ... >>What edition of SQL Server and which SP3 are you using? ...
(microsoft.public.sqlserver.security)
Problem with SP3 upgrade
... On applying SP3 update to our MSDE running on W2KPro, ... When the SQL server was started, ... Then MSDE won't uninstall until all files in the ...
(microsoft.public.sqlserver.security)