?
Solved

try to install MSDE 2000 Release A, got error 'A strong SA password is required for security reasons

Posted on 2005-05-16
1
Medium Priority
?
2,554 Views
Last Modified: 2010-05-18
While trying to install MSDE 2000 Release A, I received an error 'A strong SA password is required for security reasons.   Please use SAPWD switch to supply the same.  Refer to readme for more details.  Setup will now exit."  

what can I do to make the installation be successful? I have no idea where to set SA password.

I am running windows xp professional, however, I am using remote desktop to install MSDE runing windows server 2003, all installation files are located on the remote server machine. I have administrator right to that machine.

Thanks
0
Comment
Question by:kindy
1 Comment
 
LVL 5

Accepted Solution

by:
Viggee earned 500 total points
ID: 14008771
use this in your command prompt (or in the run menu)

if u want to access MSDE from remote machines (thu Query Analyser) then use
setup SAPWD="AStrongPassword" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0


or
setup SAPWD="AStrongPassword" SECURITYMODE=SQL


Viggee
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

839 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