The following error will occur while connecting the SQL server using windows authentication.
The root cause for above error is the user account has been disabled.
We need to enable the user account by login in to system administrator (Sa) account as shown below.
Go to Security --> Logins --> Select the user account ,right click the account and select properties.
The Login properties will be displayed as shown below.
In the above properties the permission is denied and login is disabled.
Grant the permission and enable the login as shown below.
Once done click OK button and you can login with the user account.
No comments:
Post a Comment