Follow

Changing SQL from Windows Authentication to Mixed Mode

Symptom:

SQL Server was installed as Windows Authentication.

 

Resolution:

1. Open SQL Management Studio and connect to the local database by typing (local) in the server name box and pressing connect.

2. Right click on the "(local) (SQL Server...)" at the top of the tree and choose "Properties."

3. Click on "Security" on the left and then change the radio button from "Windows Authentication" to "SQL and Windows Authentication." Press OK.

4. A message will appear stating to restart the server.

5. Right click on the "(local) (SQL Server...)" at the top of the tree and choose "Restart." 

6. Click the "New Query" button.

7. Enter the following text and press Execute.

USE [ESM5_2]
GO
ALTER USER webcam
WITH LOGIN = webcam
GO

8. Enter the following text and press Execute.

USE [ESM5_2_Cental]
GO
ALTER USER webcam
WITH LOGIN = webcam
GO

9. Enter the following text and press Execute.

USE [aspnetdb]
GO
ALTER USER webcam
WITH LOGIN = webcam
GO

10. Open command prompt as administrator and type iisreset and press enter.

 

 

If you are still experiencing issues, please send an email to support@ipconfigure.com.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk