MSDE SA Password (Newbie)

• andreask

  Mr or Mrs. 500

  Points: 542

  More actions

  February 27, 2004 at 4:06 am

  #76131

  Dear All,

  I struggled to install an MSDE named instance with a Strong SA Password without any success.

  Is it possible to change the SA Password after installation.  If yes, (a) how do I achieve this? and (b) will this have any effect on my existing DBs?

  Thanks,

  Andreas

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 27, 2004 at 4:29 am

  #496140

  (a) Take a look at sp_password.

  (b) None that I'm aware of.

  Du kannst das in der Onlinedokumentation unter Systemadministrator, Kennwörter nachlesen

  

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]