Solved

Install SP4 using an SA account with blank password

Posted on 2008-06-19
8
477 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 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
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 
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

Upcoming Webinar: Securing your MySQL/MariaDB data

Join Percona’s Chief Evangelist, Colin Charles as he presents Securing your MySQL®/MariaDB® data on Tuesday, July 11, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7).

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

707 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