01-25-2012 03:23 AM
Solved! Go to Solution.
01-25-2012 12:55 PM
For odbc check, use the %system%\syswow64\odbcad32.exe !
Make sure you are logged in as the VSA. Verify odbc connection using that. It might be that it points to old server? Is the registry updated to reflect the new server? (kvs\directory somewhere)
If this all fails, make an alias in DNS: oldsql.domain.local = newsql.domain.local
01-25-2012 03:48 AM
Are the errors only for the Audit database? If there are connectivity issues then I would expect that error for all db's. If it is just the audit database then check the ODBC connections from the EV server within the control panel and the permissions to the DB for the EV service account.
Basic ping tests should highlight any connectivity issues too.
01-25-2012 12:55 PM
For odbc check, use the %system%\syswow64\odbcad32.exe !
Make sure you are logged in as the VSA. Verify odbc connection using that. It might be that it points to old server? Is the registry updated to reflect the new server? (kvs\directory somewhere)
If this all fails, make an alias in DNS: oldsql.domain.local = newsql.domain.local
01-26-2012 01:33 AM
Thanks guy
I went backup to my not and realise that one step. It stated in case of sql error verify TECH75498.
It all good now.