Unable to Connect to C8_Audit Database

[jaminsk1]

Hi

I am currently running Cognos 8.1 sp2 on a windows 2003 server and had originally been using SQL2000 databases for our cm (Content Store) and c8_audit databases which have been working correctly for a while now (As you can guess from the software versions)

Originally these were located on the same box as the Cognos server but we have recently been suffering some performance problems and decided to move the sql databases off onto a new seperate SQL2005 instance.

The migration worked ok for the cm database and everything appears to be running ok for that however cognos does not seem to be able to connect to the c8_audit database? I recieve the following error when I restart the c8 services -

6. 15:09:02, 'AuditDatabaseConnection', 'Execute', 'Failure'.
Log Server generic error

I have changed the database and instance to reflect the new location for both Content Store and Audit as well as the logon details and one works while the other doesn't. The user logon account is a dbo on the c8_audit db and I have tried connecting to the db through SQL server, creating an ODBC and through cognos connection. Is there another config setting I need to change or possibly a file that needs deleting or replacing to be able to change the auditing to a new DB? I have looked through the IBM procedures and couldn' see anything?

The migration was to backup the c8_audit db on original location and then restore database onto new location - we didn't get cognos to recreate the tables.

Any ideas? Anyone else ever had the same problem?

thanks in advance

[MFGF]

If you create an empty database in SQL Server 2005, then point your C8 server at it as an Audit database, does the error still occur?  If not, do all the tables get created successfully?  If they do, can you see any differences between the tables in your 2005 database vs the old 2000 database?

MF.

[jaminsk1]

We tried that this morning.

I deleted the exisiting tables and the audit database settings in config manager and then recreated them all again through config manager - it created all the new tables correctly but then when we saved the settings and restarted the services we got the same error message again...?

very very strange.