This document provides a set of step-by-step instructions for setting up SQL Server Express for Netaphor SiteAudit™.
SQL Server Express Configuration
The actions described in this article are not required when using the SQL Prerequisites installer obtained from the Netaphor website unless the database content is to be shared with users on different machines.
The following actions must be taken in order for the SQL Express database to be accessed from a remote machine:
Enable the TCP/IP protocol
Configure the TCP/IP port (default 1433)
Enable SQL Browsing
The following instructions explain how to accomplish these tasks
Run Start -> All Programs -> Microsoft SQL Server(edition) -> Configuration Tools -> SQL Server Configuration Manager. Expand SQL Server (edition) Network Configuration and click Protocols for SQLEXPRESS.
Right-click the TCP/IP protocol name and click Properties.
On the Protocol tab, set Enabled to Yes.
On the IP Addresses tab, set the Enabled property to Yes for every IP address listed and the TCP Port is 1433.
Click OK.
Click OK to dismiss the following warning:
In the left pane, click SQL Server Services or SQL Server 2008 Services (depending on SQL Server version).
In the right pane, right-click SQL Server (SQLEXPRESS) and click Restart.
Close SQL Server Configuration Manager.
Remote Connections to SQL Express
If users want to connect to the SiteAudit database from a remote machine, such as the case when installing multiple viewers in the same organization, it is necessary to start the SQL Browse service.
Open the Services panel and locate the SQL Server Browser service
Right click to open the menu and select Properties
Set the Startup typetoAutomatic and close the dialog. This ensures that the service starts automatically when the computer is powered on or rebooted
Right click to open the menu and select Start
When complete, both the SQL Server Browser and SQL Server (SQLEXPRESS) must be running
