Open Microsoft SQL Server Management Studio
Connect to your SQL Server
In the Object Explorer pane at left, go to Security > Logins
Right-click the Logins folder and select “New Login”
Click the Search button and locate the account to be given permission
Click OK when the account is found. If you are having trouble locating the account, enter the domain name first.
Select the Windows Authentication option
Change the default database to “ProTrackerAdvantage” or whatever name is used by your firm.
Select “User Mapping” from the list of pages at left.
Place a checkmark next to the ProTrackerAdvantage database.
In the membership role list at bottom, place a checkmark next to db_owner.
Close SQL Server Management Studio