Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samrat
Yak Posting Veteran
94 Posts |
 Posted - 2003-02-03 : 19:37:46
|
| Greetings,I am trying to run service pack 3 (desktop installation) to upgrade by existing MSDE 2000 Installation. Following are the steps that i m following 1. Change the sa Password to Testpwd2. Stop the services on the machine3. Run the following commandSetup.exe /upgradesp SQLRUN INSTANCENAME= SECURITYMODE=SQL UPGRADEUSER=TestUser UPGRADEPWD=TestpwdI am leaving InstanceName parameter as blank as i wanna run the service pack 3 on default installation of MSDECan anyone see or suggest from what i m doing that might not work ?Any help would be appreciated.SamratEdited by - samrat on 02/03/2003 21:53:17 |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2003-02-12 : 23:41:55
|
Have you tried specifying the .msi file to use? I have upgraded about 5 installations of MSDE over the past couple of weeks and this method worked fine.Setup.exe /upgradesp c:\SQL2KSP3\MSDE\Setup\SqlRun01.msi Check out the readme file that came with SP3 - it's all detailed in there. |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
|
|
|
Service Pack 3 and MSDE