Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Microsoft SQL Server SP 3 error

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-01-31 : 09:03:04
Roman writes "Hi,

I installed the Microsoft SQL Server on my Computer and it didn't work. Microsoft Knowledge Base gave me the advise to install the SP 3. I tried to installed the SP 3 and I got the following error message:

"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."

I hope you can help me. Thanks!
Roman"

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-01-31 : 09:20:02
do you have a password on the sa account.
if not create a strong password and try again.


Go to Top of Page

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-01-31 : 15:36:12
Sounds like you actually have MSDE2000. You can either use osql and sp_password to supply an sa password before trying the install, supply one during the install using the SAPWD=sa_password switch or specify a blank password (NOT RECOMENDED!) using BLANKSAPWD=1. Please refer to sp3readme.htm that comes with SP3. It is also available online here [url]http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp#_install_desktop_engine_sp3[/url]


HTH
Jasper Smith
Go to Top of Page
   

- Advertisement -