Search This Blog

Tuesday 14 March 2017

If you Installed on Contoso.com SQL Server and later changed the name of the domain to access the server are having difficulty due to which gross Today, we will tell you some facts on what causes your overall server will complete!

You got the error as below while open MS SQL Server:













Open SQL in SQL Server authentication Mode.

Enter the login and password is correct and click on connect.























After Login Expand the security and right on logins and click on New login…






















Click on search button and go to advanced click on find Now and choose Administrator (it.com/users).
Click OK again click OK.










Click on server roles and tick mark on all Roles.





















Click on User Mapping and tick mark on as below and click OK.

































You can Disconnect SQL Server and Reconnect Windows authentication.

No comments:

Post a Comment