You need to perform the database upgrade as documented in this
attachment.
Should attachment be blocked, file is available in your installation in
program files\ipswitch\whatsup professional 2005\db scripts\upgrade
scripts\db_upgrade.txt
Regards
Jonathan Holmes
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bernhard
Buchreiter
Sent: 10 March 2005 11:27
To: [email protected]
Subject: [WhatsUp Forum] no sqls connection after upgrade to sp1
After upgrading WhatsUp Professional with the Service Pack1 I get an
error-window:
//-------------------
Database connection error.
Database version mismatch.
Database version: 101206
Application version= 102202
//-------------------
Any hints?
Bernhard
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
WhatsUp Professional (Service Pack 1) Schema Update
===================================================
Features in WhatsUp Professional 2005 (SP1) mandate an
update of the original database schema. The following
instructions will guide you through the upgrade process if
you are upgrading an installation of WhatsUp Professional
2005 that is a non-default configuration. Non-default
configurations include any that do not meet the following
conditions:
- MSDE 2000 is installed on the computer on which you are
installing WhatsUp Professional
- The WhatsUp database instance exists in MSDE
- A WhatsUp DSN is configured to point to the WhatsUp
database instance.
The WhatsUp Professional installation program will notify
you if the database is in a non-default configuration.
The procedures differ depending on whether the database
server is on the same computer as WhatsUp Professional.
NOTE: Before updating the database schema, we recommend
that you take the time to backup your existing data.
To do so:
- Execute the following SQL Command within the SQL Server
Query Analyzer (this tool is part of the Enterprise
Manager that can be found on the SQL Server CDs):
BACKUP DATABASE WhatsUp TO DISK='{path}\db_backup.dat'
ex: BACKUP DATABASE WhatsUp TO DISK='C:\db_backup.dat'
Or,
- Use the osql command to backup the database:
Osql -E -D <DSN> -Q "BACKUP DATABASE WhatsUp TO
DISK= '{path}\db_backup.dat'"
Or,
Osql -E -S <machine\instance name> -Q "BACKUP DATABASE WhatsUp
TO DISK= '{path}\db_backup.dat'"
To upgrade the database from the WhatsUp Professional 2005
format to WhatsUp Professional 2005 (SP1) format, follow the
following steps:
1. If your database is not on the same computer as WhatsUp
Professional), copy the "DB Scripts" directory and the
"Upgrade Scripts" sub-directory to the remote server.
Make note of the fully qualified path to the "DB Scripts"
directory, as it will be required in the steps that follow.
2. On the computer on which the database server is installed,
from the command prompt window, go to "Upgrade Script"
sub-directory of the "DB Scripts" directory.
3. Run the upgrade scripts, by running the VB script which
executes each script in sequence, or by running each script
individually.
VB Script
---------
In the command prompt window, execute the following Visual
Basic script:
Note: If the Sql Server and WhatsUp Professional are on
the same machine, then run upgrade_db.vbs without
specifying any arguments.
upgrade_db.vbs -E -S <sql server name> -d whatsup
where the argument, sql server name, specifies the
machine name\database instance name.
For example:
upgrade_db.vbs -E -S computer123\MySqlServerInstanceName
-d whatsup
The VB script executes all the upgrade scripts that are
found in the current directory and have filename pattern
"upgrade_from_??????_to_*.sql"
The alternative to using the VB Script is to manually run
the upgrade scripts as described below:
Manually run the upgrade scripts:
---------------------------------
1. The Upgrade scripts will be found in a sub-directory
within the "DB Scripts" directory named "Upgrade Scripts".
Using Notepad or a similar text editor, open the file
"upgrade_from_102001_to_102002.sql" in the "Upgrade
Scripts" directory. Use the "Edit -> Replace" function to
find the two occurrences of the "<DATAFILESPATH>"
placeholder, and replace it with the path to the "DB
Scripts" directory from Step #1. Note: No trailing slash
should be used in the replacement string. Save the updated
file.
2. IMPORTANT!!! Open the SQL Server Enterprise Manager and
select the Server running the "WhatsUp" database. From the
Enterprise Manager, open the SQL Server Query Analyzer, and
select the "WhatsUp" database in the drop-down selector
found in the toolbar.
3. Using the SQL Server Query Analyzer, load, and then execute
(F5), the following scripts in the order listed:
1 - upgrade_from_101206_to_102.sql
2 - upgrade_from_102001_to_102002.sql (Script updated in
Step 2)
3 - upgrade_from_102002_to_102003.sql
4 - upgrade_from_102003_to_102004.sql
5 - upgrade_from_102004_to_102005.sql
6 - upgrade_from_102005_to_102102.sql
7 - upgrade_from_102102_to_102103.sql
Following successful execution of both scripts, your WhatsUp
Professional 2005 (SP1) database will have been updated and
should be ready for use by WhatsUp Professional 2005 (SP1).
All data previously collected should be present within the
updated database.
4. Open the Services Control Manager and verify that the status
of "Ipswitch WhatsUp Engine" service is "Started." If it is
not, start the service. You may now launch NMConsole.exe or
start the application via the program shortcuts.
