What is the default password for SQL Server 2012 if I didn't put a password in the setup?
I installed SQL Server 2012 without putting a password .
What is the default password for SQL Authentication , where the login is sa ?
Login : sa and Password : blank , didn’t do the trick .
2 Answers 2
If you install SQL Server with Windows Authentication mode and want to change it, you need to do 2 different things:
Go to SQL Server Properties/Security tab and change the mode to SQL Server authentication mode
Go to security/logins, open SA login properties
a. Uncheck «Enforce password policy» and «Enforce password expiration» check box there if you decide to use weak password
КАК узнать какой пароль на sa ?
«SQL state 28000
Native 18452
Message [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘sa’.
«SQL state 28000
Native 18452
Message [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘Ну тут мой логин!’.
Разберем по порядку.
1. Заходим в скуль(«Сервак») под пользователем «Юзер» с паролем «пшелнах».
2. Создаем базу «Хрень».
3. Проверяем аутентификацию в скуле — проверка силами скуля а не винды.
4. Лезем в 1С — «Администрирование|ПараметрыБазыСКЛ»
5. Заполняем Сервер — «Сервак», База данных — «Хрень», Пользователь — «Юзер», Пароль — «пшелнах».
Default SA password of SQL Server automatically installed by SharePoint Server 2010 setup
I installed SharePoint server 2010 recently on a test server. It was installed in standalone mode .
After the installation, I realized that it had installed SQL Server Express 2008 ( 10.0.2531.0 ) automatically as well.
I need to know the password for the sa user of this SQL server instance that it automatically installed. (I was not prompted for a password during the SharePoint installation)
Reason that I need the sa password of the SharePoint SQL instance:
SharePoint is working without any issues. However, I need to create a new login on the SQL server and give it permissions to some of the databases.
I can login to the SQL server using Windows Authentication. However, using this login, I do not have permissions to create a new login.
Default SA password of SQL Server (edit)
You can also use the following SQL query to do the same:
[Note: 2 indicates mixed mode authentication. 1 is for windows only authentication]
Setting a password on the sa account:
- Under the SQL instance, expand Security and Logins
- Right click on sa and click on Properties
- Type the new password in the Password and Confirm Password boxes
You can also use the following SQL query to do the same:
[Note: CHECK_POLICY=OFF ensures that Windows password policies of the computer on which SQL Server is running will NOT be enforced on this login]
Enabling the sa account:
- Under the SQL instance, expand Security and Logins
- Right click on sa and click on Properties
- Click on Status on the left pane
- Click on Enabled under the Login section
You can also use the following SQL query to do the same:
Question
How to change a password for the `sa` user in MS SQL?
Answer
This can be done using the osql utility in a command prompt or using Microsoft SQL Management Studio.
1. Using the command prompt:
-
For a local MS SQL server use the following command:
osql -E -Q «exec sp_password NULL,’new_password’,’sa'»
osql -S servername_or_address -E -Q «exec sp_password NULL,’new_password’,’sa'»
2. Using Microsoft SQL Management Studio:
- Open Microsoft SQL Management Studio. It can be done from the command line by executing ssms.exe .
- Login into Microsoft SQL Management Studio with Administrator user credentials.
- Go to Security > Logins > sa > properties .
- Change the password.
Note: These actions are possible for Administrator account only.
If Windows administrator does not have permissions to reset ‘sa’ user password, follow instructions from the article: Connect to SQL Server When System Administrators Are Locked Out