Installing WhatsUp Gold using an existing Microsoft SQL Server

You can use an existing Microsoft SQL Server 2005 or Microsoft SQL Server 2008 to store the data collected by WhatsUp Gold. To do this, these requirements must be met:

Microsoft SQL Server 2005 or Microsoft SQL Server 2008 English must be installed on the WhatsUp Gold host computer or another computer.

Important: Make sure that the "master" database for the existing SQL Server database instance that is hosting the WhatsUp database is configured to use case-insensitive collation.

Important: WhatsUp Gold does not support non-English versions of Microsoft SQL Server 2005 or Microsoft SQL Server 2008.

Microsoft SQL Server 2005 or Microsoft SQL Server 2008 must be configured to allow WhatsUp Gold to authenticate.
- If Microsoft SQL Server is installed on a remote computer, remote connections must be allowed. For more information, see How to configure Microsoft SQL Server to allow remote connections.
- We recommend using a Microsoft SQL Server user account to connect to the database. However, if the Microsoft SQL Server database exists on the same computer or both computers are members of the same domain, you may use Windows Authentication. For more information about enabling mixed mode authentication in Microsoft SQL Server, see the Microsoft article about Authentication Mode.
Microsoft SQL Server must be configured to have a user account that meets the following requirements:
- Full administrator privileges to Microsoft SQL Server, not just the WhatsUp Gold databases. WhatsUp Gold only supports accessing the database via an account with full administrator rights. WhatsUp Gold does not support using a limited access database user account.
- User's language is set to (United States) English. This can be set in the properties for the login used by WhatsUp Gold.

If you need assistance configuring or verifying these prerequisites, contact your database administrator or refer to the Microsoft SQL Server documentation.

To install WhatsUp Gold using an existing Microsoft SQL Server:

Important: WhatsUp Gold systems running on Microsoft Windows Vista require a reboot during the install process if .NET 3.5 (SP1) has not been installed prior to the WhatsUp Gold install.

Log in directly to Microsoft Windows using the Administrator account (if you do not have an account called Administrator, use an account that has full administrative privileges to the computer).
Caution: We do not recommend using Terminal Services or Remote Desktop to install WhatsUp Gold.

Note: When installing on Windows Vista, additional steps are necessary for the Task Tray application to work properly. For more information, see Task Tray Application fails on Windows Vista.
Start the installation program:
- If you downloaded an electronic version of WhatsUp Gold, double-click on the downloaded file.
- If you purchased a WhatsUp Gold CD-ROM, insert the CD-ROM into the appropriate drive. If it does not run automatically, click Start, select Run, then enter the CD path followed by AutoRun.exe (for example, D:\AutoRun.exe).
Read the Welcome screen.
Click a button next to an additional resource to view that resource.

Clear Hide advanced installation options. This checkbox must be cleared in order for you to use Microsoft SQL Server as the WhatsUp Gold database.

Click Next. The License Agreement dialog appears.
Read the license agreement. If you accept the terms of the license agreement, select I accept the terms of the license agreement.
- To print a copy of the license agreement, click Print. The license agreement is sent to the default printer.
- If you do not accept the terms of the license agreement, click Cancel to exit the installation program.
  Click Next to continue. The Microsoft SQL Server Installation Options dialog appears.
Select Use an existing installation of Microsoft SQL Server, then click Next. The Database Server Login dialog appears.
1. In Database server that you are installing to, enter the hostname of your database server.
  Important: Make sure that the "master" database for the existing SQL Server database instance that is hosting the WhatsUp database is configured to use case-insensitive collation.
  
  Note: If you are using a database instance other than the default instance, you must include the instance name using the format <Server_Name>\<Instance_Name>.
  
  Tip: If you cannot remember your database server's hostname, click Browse to see a list of all database servers detected on the domain. Database servers to which you can connect but which are not configured on the same domain as the computer where you are installing WhatsUp Gold are not shown. The Browse dialog scans your entire domain, so it may take some time before showing you a list of database servers.
2. Select the appropriate authentication method for your database server.
  - If your database server is a member of a domain and is configured to accept Windows user names, select Windows authentication. The user whose credentials you use to run WhatsUp Gold must be a member of the same domain as the database server.
  - If your database server requires SQL Server authentication, or if the Windows user account under which WhatsUp Gold runs does not have access to the database server via Windows authentication, select SQL Server authentication using Login ID and password below, then enter the correct Login ID and Password.
3. Click Next. The installation program attempts to validate the credentials you entered and checks for the existence of WhatsUp Gold databases on the database server. If WhatsUp Gold databases are found on the database server, the setup program alerts you and asks if you want to continue.
  - Select Yes to upgrade the databases and continue the installation.
  - Select No to select another Microsoft SQL Server.
    After the credentials are validated, the Enter Microsoft SQL Server 2005 Express Edition Paths dialog appears.
This dialog lists the third-party resources that the installation program installs, including Microsoft SQL Server 2005 Express Edition client tools (required for installations of WhatsUp Gold that use Microsoft SQL Server databases) and Microsoft .NET Framework 3.5.
Click Next. The Choose Destination Location dialog appears.
Select the installation directory for the WhatsUp Gold application files.
The default path is C:\Program Files\Ipswitch\WhatsUp. We recommend that you use the default path.

Tip: You can install WhatsUp Gold to a different location. To select a different location, click Change.

After you select the installation directory, click Next.

Note: If the installation program detects data from a previous installation of WhatsUp Gold, the Back up Web and Report Files dialog appears. We recommend that you select Back up the existing Web and report files, then click Next.

The Enable Web Server dialog appears.
Determine if you want to enable the WhatsUp web server.
- To enable the WhatsUp web server, select Yes and enter a port. The default port is 80.
  Note: You must select a port that is not already in use. If the port you enter is in use, you must enter a different port or stop the service using the entered port before you can continue installing WhatsUp Gold. If you choose to stop the service running on the port you want to use, you must disable it permanently. If you only disable it temporarily, a port conflict will occur the next time the disabled service is started.
- To use Microsoft Internet Information Services, select No, then see Configuring the web server.
  After making a selection, click Next.
  
  Note: If the firewall is enabled when WhatsUp Gold is installed, the port you specify is opened in the Windows Firewall. This allows other computers on the network to log on to the WhatsUp Gold Web interface.
Click Install to install WhatsUp Gold. The setup program installs and configures WhatsUp Gold.
When the installation completes, the InstallShield Wizard Complete dialog appears.
To see the release notes after the installation program closes, select View WhatsUp Gold release notes and documentation.

Click Finish. The setup program closes.