3 Methods to Change SQL Server Password
来源:互联网 发布:淘宝商家互刷群 编辑:程序博客网 时间:2024/06/07 03:06
"I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, I don't want to reinstall the SQL server, Thanks in advance."
There are many more similar situations that people forgot the SA password shortly after installing the MS SQL Server. This article shows you 3 methods to help you change forgotten SA password for your SQL Server 2000/2005/2008 database installation.
Option 1: Change SQL Server Password in Management Studio
If you've forgotten the sa password for your SQL server, you are probably in a panic. Fear not, for you can change the password and once again have access to the powers of the SA account using Windows Authentication mode.
- Login into SQL Server using Windows Authentication.
In Object Explorer, open Security folder, openLogins folder. Right click on SA account and go to Properties.
Change SA password, and confirm it. Click OK.
Option 2: Change SQL Server Password Using SQL Script
- Open the SQL Server Management Studio.
- Open a New Query.
Copy, paste, and execute the following:
GOALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]GOUSE [master]GOALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGEGO
where NewPassword is the password you wish to use for the sa account.
Option 3: Change SQL Server Password with Third Party Software
- Download SQL Server Password Changer on your local PC, install and launch it.
Click the Open File button. Select the SQL Server master database file (master.mdf). Typically it is located in the folder: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.
The program will automatically decrypt the master database file and display all user accounts in your SQL Server. Select the SA account, click theChange Password button. Type a new password and click OK.
- The old password will be replaced with your new password. Now you are able to log into the SA account using your new password.
- 3 Methods to Change SQL Server Password
- How to change Password Policy in Windows Server 2003
- HOW TO CHANGE SYSADM PASSWORD?
- Oracle 11 g:how to change the password with PL/SQL
- Informatica: Change the Repository Server Administrator password
- How to change the SQL Server 2008 default install path
- How to change the SQL Server 2008 default install path
- Change asp.net membership database to SQL Server
- How to change Bootstrap admin password
- How To Change ASM SYS PASSWORD
- How to change Bootstrap admin password
- How to change password of Thunderbird
- How to Change Windows Password Policy?
- 为CAS server添加Change Password和Forget Password功能
- Steps to change the default location of SQL Server /SQL Server Agent - Error log files
- java.sql.SQLException: Your password has expired. To log in you must change it using a client that s
- MS SQL Server - How to change an existing column to auto-increment column
- several methods for uploading files to server
- 设计模式(四)原型模式Prototype(创建型)
- 汉诺塔问题的python实现
- Lucene.net 高数据检索量时怎样显著提高查找效率(从无到有学习Lucene)
- 获取客户端的ip地址
- css 元素累积点滴
- 3 Methods to Change SQL Server Password
- 《深入理解计算机系统》--系统级I/O
- Extjs自定义样式
- 虚拟机下网络设置
- Multiple operations have reported errors.Select an error to view its details.
- 头插入法建立链表
- ruby gem install rails 错误解决方法
- PageRank的经济学效用解释
- svn清除客户端保存的用户名和密码