Create the SQL Server Login

Notes


The following steps details the procedure on how to give access to a user in SQL Server 2008 R2.

For the User account (e.g., OLAPAdmin) to have rights to the SQL Server, you must add the account to the SQL Server Logins Group, as described in the following steps:

1.   From the Start menu, launch the SQL Server Management Studio.

A dialog box will appear that will prompt user to specify the server type, server name and authentication.

2.   Select the server type, server name and authentication using the drop-down selection. For the type of authentication select Windows Authentication.   
Click Connect.

The Microsoft SQL Server Management Studio dialog box will be displayed.

3.   In the left-hand pane, expand the correct SQL Server Group, and then expand the correct Server itself.

4.   Double-click on the Security folder, then right click on the Logins folder and then select New Login.

Tip


Another way is to right click on the Security folder, select New and then Login….]

The SQL Server Login Properties - New Login dialog box will be displayed as shown below. The default page that will be displayed when opening this dialog box is the General page.

5.   In the Login name text box, enter appropriate <DOMAIN\UserName>; enable the Windows authentication radio button (you can also use the Search button to locate a user name).          
In the given example, DOMAIN\OLAPAdmin was entered.

6.   Select Server Roles page on the left hand pane and this next dialog will be displayed.

7.   In the Server roles list box, select the sysadmin.        
(Note: Selecting sysadmin as a server role will enable OLAPAdmin user to have access to all database running in the SQL Server.)

8.   Click OK. This will bring you back to the Microsoft SQL Server Management Studio. Notice that OLAPAdmin is now included in the Logins folder.         
Exit the dialog box.