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:
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?