• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

How to setup a SQL sa Password on SQL server 2008 R2

Hi
We have installed SQL server 2008 R2 on a Windows 2008R2 standard.
One of our IT services company is going to install a access control software on our SQL server and the engineer had asked me for the SQL sa Password which iam not  aware. My predecessors had installed the SQL server in the past.

I can login into the SQL with windows authentication, but it there a way to set up a SQL sa  Password  

Thanks
0
lianne143
Asked:
lianne143
3 Solutions
 
Haresh NikumbhSr. Tech leadCommented:
Please refer below link to change SQL sa account password.

http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/
0
 
Louis01Commented:
You have to change to mixed mode authentication:

http://msdn.microsoft.com/en-us/library/ms188670(v=sql.105).aspx
0
 
AbhishekJhaCommented:
1. Login into SQL server using Windows Authentication.
 2. In Object Explorer, open Security folder, open Logins folder. Right click on sa account and go to Properties.
 3. Type a new SQL sa password, and confirm it. Click OK to finish.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now