[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Install SP4 using an SA account with blank password

Posted on 2008-06-19
8
Medium Priority
?
479 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

649 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