Solved

Install SP4 using an SA account with blank password

Posted on 2008-06-19
8
471 Views
Last Modified: 2010-04-21
Greetings Experts!  Here is the situation.  I have MSDE SP/3 installed on a Windows 2003 server that I use for Websense.  I am installing SP4 and I can't figure out the command string since the password for the sa account is blank.  Does anyone know the command?

This is what I have so far:
 setup /upgradesp sqlrun /L*v C:\msdelog.log

Your help is greatly appreciated.
0
Comment
Question by:samiam41
  • 4
  • 4
8 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 500 total points
ID: 21825281
0
 
LVL 9

Author Comment

by:samiam41
ID: 21825314
Thank you!

I am running it now and will update accordingly.
0
 
LVL 31

Expert Comment

by:James Murrell
ID: 21825335
cool hope all is ok with it
0
 
LVL 9

Author Comment

by:samiam41
ID: 21825350
How do you know if it was successfully upgraded?  The window just closed....
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 31

Expert Comment

by:James Murrell
ID: 21825396
unsure been a while since i usd msde... sorry... if you check properties it might sqy.... or run it again it might say already done...
0
 
LVL 9

Author Comment

by:samiam41
ID: 21825416
Hahahaha!!!  I'll give it a shot.  I don't use MSDE very much at all.  Servers, networking, backups...  No prob.  Databases and programming..  Big prob.  
0
 
LVL 9

Author Closing Comment

by:samiam41
ID: 31468928
Thanks for your help!  Take care.

-Aaron
0
 
LVL 31

Expert Comment

by:James Murrell
ID: 21825439
i use sql 2000 a lot and sql 2005 a bit and a fair amunt ofr web work and programming. so i know how it feels when i have to configred the kvmoip next week behind new firebox friewall. i will be asking loads f quetsions
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now