?
Solved

Install SP4 using an SA account with blank password

Posted on 2008-06-19
8
Medium Priority
?
478 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 2000 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
Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

 
LVL 9

Author Comment

by:samiam41
ID: 21825350
How do you know if it was successfully upgraded?  The window just closed....
0
 
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

770 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