Using an Existing SQL Server on a remote computer

This procedure steps you through creating a new WhatsUp database on an existing SQL Server installation on a remote computer.

You must first complete the Ipswitch WhatsUp Gold v11 installation, then configure Microsoft SQL Server 2000.

1. Move the database to the SQL Server instance.
   1. Backup the clean SQL Server 2005 WhatsUp database.

      From the WhatsUp Gold console, select Tools > Database Utilities > Back Up SQL Database. Enter a name for the backup file, for example:

      WhatsUpcleanDB.dat

      - or -

      From the command line, enter:

      osql -E -D whatsup -Q "backup database to
disk='C:\SP1cleanDB.dat'"

   2. Restore the database.
2. Turn on TCP/IP.
   1. On the computer on which WhatsUp Gold was installed, from Windows Explorer, select C:\Program Files\Microsoft SQL Server\80\tools\bin\SVRNETCN.exe
   2. On the General tab, enable TCP/IP.
   3. Stop and then restart the SQL Server.
3. On the WhatsUp Gold computer, create a System Data Source Name (DSN).
   1. On the computer on which WhatsUp Gold was installed, click Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC).
   2. Click the System DSN tab. The recommended DSN Name used by WhatsUp Gold is: "WhatsUp"
   3. Select SQL Server Authentication. You can specify sa (the default) as the LoginID, and its password as an alternative. You can use any LoginID and Password with rights to the WhatsUp database, which requires additional configuration on the remote SQL Server.
   4. Make sure the Change the default database to option is selected, and that the default database is "WhatsUp".
   5. In the final screen of the DSN wizard, click the Test Data Source button. Make sure the test is successful.
4. Run NMCONFIG.EXE. This program makes sure that WhatsUp Gold has the account information needed to log on to the database. The NMCONFIG dialog opens.
   1. Enter the DSN name created in the previous step.
   2. Enter a Username ("sa" is the default).
   3. Enter the Password for this Username (the one you specified in Step 3). The default password is: "wug_sa"
5. Remove service dependencies. You need to remove the Ipswitch WhatsUp Engine service's dependence on MSSQL$WHATSUP, which is the MSDE instance created by the WhatsUp Gold installation. To do this:
   1. At the DOS prompt, navigate to the directory where Ipswitch WhatsUp Gold v11 is installed, and enter: Nmservice /Service:

      Note: On some operating systems, you may have to reboot the machine before continuing.

   2. At the DOS prompt, enter (for the second time:) NmService /Service:
   3. Go to Control Panel > Administrative Tools > Services, then start the Ipswitch WhatsUp Engine Service.
6. Launch the application.
   • Select Start > Programs > Ipswitch WhatsUp Gold v11 > WhatsUp Gold.

     - or -

   • Select Start > Programs > Ipswitch WhatsUp Gold v11 > WhatsUp Gold Task Tray Application.