Problem changing database to MSSQL2008
Hi,
I'm running a trial version of Event Anayzer 5 on a virtual machine. If I setup the system to run in trial mode with the MySQL-database installed on the same machine, it runs fine, collecting data from 20 servers. I followed the instructions to change the database to a MSSQL2008 database hosted on another server by copying the necessary files, making a backup, changing the database and restoring the database. Now I get funny results: the whole system starts up fine, I can see the restored data in the database, make changes to the users, delete servers and even give sql-commands in the command interface, but suddenly, the system cannot connect to the remote servers to get their eventlogs! All green connection markers turn orange, indicating a connection problem. When I switch back to the MySQL-database on the same server, all the servers show green connection-markers and start logging eventdata from these servers... So both the connection to the MSSQL-database is OK and the connection to the servers is OK, but they just don't want to be OK together...
I tried to update the JRE (now at version 1.6 update 13), and even changed the International Settings to US, because otherwise the free space indicator on the c:-drive says 0.0 GB, as we use the '.' and the ',' charcters differently here in Belgium. This also gives errors in the backup/restore operation mentioned above, so this seems to be a fault in this program.
Is this a known problem or is there something else that I should try? I like this product, but our company policy only allowes MSSQL- and Oracle databases, so I need a fix for this problem or we need to search another tool for managing our eventlogs.
With regards,
Bertin Peeters
University of Antwerp
Systems Manager
I'm running a trial version of Event Anayzer 5 on a virtual machine. If I setup the system to run in trial mode with the MySQL-database installed on the same machine, it runs fine, collecting data from 20 servers. I followed the instructions to change the database to a MSSQL2008 database hosted on another server by copying the necessary files, making a backup, changing the database and restoring the database. Now I get funny results: the whole system starts up fine, I can see the restored data in the database, make changes to the users, delete servers and even give sql-commands in the command interface, but suddenly, the system cannot connect to the remote servers to get their eventlogs! All green connection markers turn orange, indicating a connection problem. When I switch back to the MySQL-database on the same server, all the servers show green connection-markers and start logging eventdata from these servers... So both the connection to the MSSQL-database is OK and the connection to the servers is OK, but they just don't want to be OK together...
I tried to update the JRE (now at version 1.6 update 13), and even changed the International Settings to US, because otherwise the free space indicator on the c:-drive says 0.0 GB, as we use the '.' and the ',' charcters differently here in Belgium. This also gives errors in the backup/restore operation mentioned above, so this seems to be a fault in this program.
Is this a known problem or is there something else that I should try? I like this product, but our company policy only allowes MSSQL- and Oracle databases, so I need a fix for this problem or we need to search another tool for managing our eventlogs.
With regards,
Bertin Peeters
University of Antwerp
Systems Manager