Using an Existing SQL Server on the same computer

This procedure steps you through creating a new WhatsUp database on an existing SQL Server installation that is on the same computer with WhatsUp Gold.

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

  1. Move the database to the SQL Server instance.
    1. Back up the clean MSDE 2000 WhatsUp database.

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

      Or, from the command line, enter:

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

    2. Restore the backup to your SQL Server. From the directory where the you saved the backup file, run:

      osql -E -S <sql server name> -Q "restore database whatsup
      from disk='<the .dat file> with Move 'whatsup_dat' to
      '<location for the mdf file>', Move 'whatsup_log' to
      '<location for the ldf file>'"

      Substitute the <...> with your values:

      <sql server name> = machine name\instance name
      <the .dat file> = the backup file from the previous step (step a)
      <location for the mdf file> = where you would like to keep the mdf file (data file used by the database)

      <location for the ldf file> = where you would like to keep the ldf file (log file used by the database)

      For example:

      osql -E -S rra997\mySqlServerInstanceName -Q "restore
      database whatsup from disk='D:\WhatsUpcleanDB.dat' with Move
      'whatsup_dat' to 'D:\Program Files\Microsoft SQL
      Server\MSSQL$mySqlServerInstanceName\Data', Move
      'whatsup_log' to 'D:\Program Files\Microsoft SQL
      Server\MSSQL$mySqlServerInstanceName\Data'"

  2. 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 Ipswitch WhatsUp Gold v11 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: NmService /Service:<MS SQL Server Service Name>

      For example: NmService /Service:MSSQL$mySqlServerInstanceName

    3. Go to Control Panel > Administrative Tools > Services, then start the Ipswitch WhatsUp Engine Service.
  3. Configure the 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. Click Configure to modify the WhatsUp DSN. In the Server box, enter: <machine name\sql server instance name>

      For example:

      computer123\mySqlServerInstanceName

    3. Click Finish.
  4. 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.