Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Password for SQL Server
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 18th March 18:07
marc melfi
External User
 
Posts: 1
Default Password for SQL Server


We have lost the sa password to the SQL server. Does any
one have a way or idears on how to find or get by this.
Thank you for any info.
Marc
  Reply With Quote


  sponsored links


2 18th March 18:07
jasper smith
External User
 
Posts: 1
Default Password for SQL Server


Assuming you can access the server via NT authentication you can run
sp_password to change the sa password using NULL as the old password value .
See BOL for details of sp_password

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

We have lost the sa password to the SQL server. Does any
one have a way or idears on how to find or get by this.
Thank you for any info.
Marc
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666