--- id: AA-00530 title: "Providing SiteAudit Database Access" url: http://netaphor.com/kb/AA-00530/providing-siteaudit-database-access product: "SiteAudit OnSite" type: "How-to & configuration" updated: 2020-11-10 access: public --- # Providing SiteAudit Database Access To access the Netaphor SiteAudit™ database, a user must have owner privileges first. This article describes how to give new users access to the SiteAudit database. Functional Security Once the SiteAudit administrator is able to access the SiteAudit database, it is possible to create new SQL users and roles from within SiteAudit in order to provide access for other users. Refer to the [Functional Security](http://netaphor.com/kb/AA-00828) articles to learn how to provide role access for users ### Contents - Before You Begin - Determine Your Authentication Method for Database Access - Install SQL Server Management Studio - Integrated Security - SQL Security ### Before You Begin ### Determine your authentication method for database access The process of giving a user privileges for database access differs depending on whether you use integrated security (Windows authentication) or SQL authentication. To see which kind of authentication you use: On the **Setup** menu, click **Database**. If the **Windwos Authentication** is selected, you are using integrated security. If it is not selected, you are using SQL authentication. SiteAudit version 6.8 supports SQL Servers 2016 and 2017. Version 7.0 and later support SQL Server 2019 ![](http://netaphor.com/kb/media/AA-00530/win-auth.png) ### Install SQL Server Management Studio If your installation of SQL Server does not include SQL Server Management Studio, you should download and install it. For example, if you installed SQL Server 2016 Express from the Netaphor web site, you should go to [http://www.microsoft.com/en-us/download/details.aspx?id=30438](http://www.microsoft.com/en-us/download/details.aspx?id=30438) and download *SQLManagementStudio_x64_ENU.exe* (for 64-bit Windows) or *SQLManagementStudio_x86_ENU.exe* (for 32-bit Windows). ### Integrated Security If you use integrated security, the Windows user name and password of the user who is logged into Windows are passed to SQL Server. 1. Click **Start**, type **SQL Server** in the search box and click** SQL Server Management Studio**. ![](http://netaphor.com/kb/media/AA-00530/add-user-start-ssms.jpg) 1. Connect to SQL Server. ![](http://netaphor.com/kb/media/AA-00530/add-user-connect-to-sql-server.jpg) ![](http://netaphor.com/kb/media/AA-00530/add-user-connect-to-sql-server.jpg) 1. Expand the **Security** node and the **Logins** node. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-02.jpg) 1. Listed below Logins are the users who have permission to access SQL Server. 2. Right-click **Logins** and click **New Login**. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-03.jpg) 1. Make sure that the **Windows authentication** option is selected, and click **Search**. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-04.jpg) ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-04.jpg) ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-04.jpg) 1. If necessary, click **Locations** and select the needed domain or other location. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-05.jpg) 1. Type the name of the user to be added, and click **Check Names**. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-06.jpg) 1. Click **OK**. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-07.jpg) 1. Click **Server Roles** and make sure that the **public** check box is selected. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-08.jpg) 1. Click **User Mapping**. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-09.jpg) 1. Select the check box for your SiteAudit database. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-10.jpg) 1. Select the **db_owner** check box. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-11.jpg) ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-11.jpg) 1. Click **OK**. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-12.jpg) ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-12.jpg) The user is now in the list of users who have access to the SiteAudit database when they are logged on to Windows. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-13.jpg) Now when user JOHNT7X64\\Lee Smith logs into the machine, he should be able to access the SiteAudit database by using Integrated Security as shown below. To confirm, click the Test button to ensure the connection succeeds. ![](http://netaphor.com/kb/media/AA-00530/win-auth.png) ![](http://netaphor.com/kb/media/AA-00530/win-auth.png) ### SQL Security 1. Click **Start**, type **SQL Server** in the search box and click **SQL Server Management Studio**. ![](http://netaphor.com/kb/media/AA-00530/add-user-start-ssms.jpg) 1. Connect to SQL Server. ![](http://netaphor.com/kb/media/AA-00530/add-user-connect-to-sql-server.jpg) ![](http://netaphor.com/kb/media/AA-00530/add-user-connect-to-sql-server.jpg) 1. Expand the **Security** node and the **Logins** node. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-02.jpg) 1. Listed below Logins are the users who have permission to access SQL Server. 2. Right-click **Logins** and click **New Login**. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-03.jpg) 1. Do the following: - Type the new user's **Login name**. - Click **SQL Server authentication**. - Make sure that **Enforce password expiration** is not selected. - This prevents problems that can occur if a password is changed. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-15.jpg) 1. Click **Server Roles** and make sure that the **public** check box is selected. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-08.jpg) 1. Click **User Mapping**. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-16.jpg) 1. Select the check box for your SiteAudit database. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-17.jpg) 1. Select the **db_owner** check box. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-18.jpg) 1. Click **OK**. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-19.jpg) The user is now in the list of users who have access to the SiteAudit database. ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-20.jpg) At this point, one can enter the credentials for Tyler to access the SiteAudit database as shown below. Click the Test button to confirm that it succeeds. ![](http://netaphor.com/kb/media/AA-00530/sasecurity.png) ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-20.jpg) ![](http://netaphor.com/kb/media/AA-00530/add-user-ssms-20.jpg)