Follow these steps to verify the database privileges in the SQL Server.
-
Log into the SQL Server with valid credentials.
-
In Object Explorer, expand Security and Logins.
- If you have previously set up a user with the necessary database privileges:
-
Right-click on the
user's name and select Properties.
-
Select Server Roles.
-
Ensure that public and sysadmin have been selected.
-
If you need to set up a user with database privileges:
-
Right-click Logins > New Login.
-
Type the login name of the user that is to be granted database privileges. Select the
Windows authentication radio button.
-
In the left pane, select Server Roles. Select the checkboxes as shown below,
and click OK.