cancel
Showing results for 
Search instead for 
Did you mean: 

Error 13397 After change SQLServer Audit Database

AG81
Level 5
Partner Accredited

Hello to all, 

I just had this error after changing the databases from SQLServer regarding the technote http://www.symantec.com/business/support/index?page=content&id=TECH35744&actp=search&viewlocale=en_U...

 

 

The connection 'Provider=SQLOLEDB;Server=OLDSQLSERVER;Database=EnterpriseVaultAudit;Trusted_Connection=Yes' was lost and the system is waiting to reconnect (Thread Id: 2244) 
 
For more information, see Help and Support Center at http://evevent.symantec.com/rosetta/showevent.asp?EvtID=13397
 
 
My first problem was that I not find any System DSN ODBC in the EVServer (like says step 8 at the KB)... but I tried to create It manually. After de OBDC creation the error still appearing. I can start all the EV services, but any user can restore o recall archived elements.
 
Then, the answer is, how the EV server now that the old Sqlserver is namded OLDSQLSERVER and the AuditDatabase is located there? I created the OBDC to reconfigure it...
 
And searching in the EVserver Registry I found this key:
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\EVAudit]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Description"="Enterprise Vault Audit Database"
"Server"="OLDSQLSERVER"
"Database"="EnterpriseVaultAudit"
"LastUser"="EVadmin"
"Trusted_Connection"="Yes"
 
Just Modifiying the "Server" key from OLDSQLSERVER to NEWSQLSERVER and restarted all the services, all work fine.
 
Regards!
 
 
 
1 ACCEPTED SOLUTION

Accepted Solutions

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

are you sure you checked using the 32-bit version of the ODBC Data Source Administrator tool? http://www.symantec.com/docs/TECH75498

View solution in original post

3 REPLIES 3

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

are you sure you checked using the 32-bit version of the ODBC Data Source Administrator tool? http://www.symantec.com/docs/TECH75498

AG81
Level 5
Partner Accredited

I can't confirm you it because now not have access to this environment. But thanks for the TechNote. In the future i will try it.

Thanks!.

AG81
Level 5
Partner Accredited

Hi AndrewB. Confirmed. This is de correct way.

 

Thanks!