We're speaking at
CFUnited 2008:
CFUnited - The Premiere ColdFusion Technical Conference

Search

Calendar

SunMonTueWedThuFriSat
    123
45678910
11121314151617
18192021222324
25262728293031

Subscribe Enter your email address to subscribe to this blog. You'll receive an email when we write a new post.

Recent Entries Come On In, Rails-The Water's Warm
Shan's Simple Examples: File uploads with Flex and ColdFusion

Recent Comments Google Calendar API - Creating a new Calendar with ColdFusion
Steve Julian said: When and where are you going to post the finished CFC's ? Thanks [more]

Three Phases of Programmer Development
Pat Branley said: I normally think of those phase 2 people as 'programmers' and the phase 3 people as 'developers'. I... [more]

New Job Title: Front End Engineer
Sean Corfield said: Well, there's always the excellent Fusion Authority Quarterly Journal... [more]

Down To The Wire: HTTP Sniffers
Brian M said: I second the mention of the Charles Web Debugging Proxy that Tariq mentioned. It is fantastic. It s... [more]

New Job Title: Front End Engineer
Patrick said: Heya Sean. Good point. I never understood how they did things over there at SysCon, and I understand... [more]

Archives By Subject Business of Software (4) [RSS]
ColdFusion (318) [RSS]
Conferences (6) [RSS]
Databases (87) [RSS]
Flex & Flash (109) [RSS]
Fusebox (87) [RSS]
General Development (29) [RSS]
Google (9) [RSS]
Hardware (5) [RSS]
JVM & Java (132) [RSS]
Linux (20) [RSS]
Miscellaneous (254) [RSS]
Performance (8) [RSS]
SeeFusion (36) [RSS]
Shan's Simple Examples (7) [RSS]
User Interface (3) [RSS]
Windows (5) [RSS]

Archives By Poster Daryl Banttari (10)
Nat Papovich (29)
Patrick Quinn (36)
Shannon Hicks (22)
Steve Nelson (21)
Tyson Vanek (3)


bottom corner

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?

Comments
GOD BLESS YOU! AND GOD BLESS GOOGLE FOR INDEXING THIS! THANK YOU!
# Posted By happy user | 10/24/06 2:18 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.
# Posted By Nat Papovich | 1/18/07 9:20 PM
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.
# Posted By jprior | 10/30/07 9:56 AM

bottom corner