Upgrading MSDE RTM to SP4
I’m reformatting my laptop tonight and went to upgrade the Microsoft SQL Server Desktop Edition (MSDE) from the 1.0 RTM to SP4.
Damn the dreaded “The instance name specified is invalid” error!
I’ve installed this setup countless times and always had to futz, mess, finagle, tweak my setup command to get the darn thing to run. So today I’m documenting it here, forevermore:
setup /upgradesp sqlrun sapwd=mypassword securitymode=sql
Note that this works when you’ve already connected to MSDE and setup Mixed-Mode authentication (with an SA login) as opposed to just Windows authentication.
Hope this helps someone!
BTW, did you know you can run SQL 2005 with SQL 2000 on the same machine, so long as you’ve upgraded to SP4 on 2k? GOod to know, eh?
GOD BLESS YOU! AND GOD BLESS GOOGLE FOR INDEXING THIS! THANK YOU!
Comment by happy user — October 24, 2006 @ 12:00 am
Haha, I just helped myself! While installing for a client, I just couldn’t get the install to work right. I love it when I help myself!
Now if I could just make more MEs.
Comment by Nat Papovich — January 18, 2007 @ 12:00 am
Thanks for this, also note that using setup /upgradesp sqlrun BLANKSAPWD=1 can give you a get out of jail free card when you’re working with mickey mouse apps that install MSDE instances without asking how you want to configure them.
Comment by jprior — October 30, 2007 @ 12:00 am
Who would have guest that five years on I would still need this fix
thanks
Comment by paintball — March 23, 2012 @ 3:31 am
I just added the instance name! Thank god for this post!
setup /upgradesp sqlrun INSTANCENAME=instancename sapwd=mypassword securitymode=sql
Comment by Chris — April 2, 2012 @ 6:00 pm