EV 11.0.1 trying to connect to two sql servers after DR failover
Hi all,
Wondering if someone could help me or if had similar issues.
i did a DR failover test from our production to our DR site.
1.eDiscovery
2. Mail Archive
3. Journal archive
our EV's are on vmware as too our SQL servers.
our Dba did a db mirror of the databases from our production sql server (SQL01) over to our DR sql server (SQL05)
the only change i applied with a sql alias change from sql01 to sql05
After failing back to production. i removed the sql alias from my mail archive server, so expected it would talk about to my production sql server SQL01
my Mail Archive server is trying to connect back to our Dr sql server. ive checked on the registry and did a dns flush. i had tech support on and they dont know how this is possible.
Due to the connectivity issues connecting to the sql server.
my Enterprise Vault services keeps shutting down.
below are one of the examples of the error im getting.
Log Name: Symantec Enterprise Vault
Source: Enterprise Vault
Date: 28/01/2016 15:03:07
Event ID: 6479
Task Category: Storage Crawler
Level: Error
Keywords: Classic
User: N/A
Computer: EUR0NWENTMASP01.domain.com
Description:
Error accessing Vault Store database.
[Internal reference CStorageDBAccess::OpenDatabase()/AddConnection failed]
Database DSN: [EVVSMailboxVaultStore1_1]
================================================================================================================
Log Name: Symantec Enterprise Vault
Source: Enterprise Vault
Date: 28/01/2016 14:47:14
Event ID: 40966
Task Category: (132)
Level: Error
Keywords: Classic
User: N/A
Computer: EUR0NWENTMASP01.domain.com
Description:
A program fault has raised an exception.
Exception: Cannot open database "EnterpriseVaultDirectory" requested by the login. The login failed.
Login failed for user Domain/'EURSVCEVAdmin'.
Diagnostic: Num:4060 State:1 Sev:11 Svr:EURSQL05\INFRA03 Proc: Line:65536
Type: System.Data.SqlClient.SqlException
Reference: DL/Archive/GetEntry/1AEB92A2AC3DE684CB520B1DA9119884B1110000ENTMASP01
any help would be great.
thanks,
Noel
Howdi All,
Just an update on this issue if you come across it and could not find the reason. The reason was down to the windows firewall port were only configured for 300 open ports.
After having a 3rd party veritas vender in. the found the fault to do with there was not enough ports configured
I found a tool also to use it may help called EV_Best_Practice_Analyzer_V2.0.7.exe its a very handy tool.
From the report it stated below.
DYNAMIC USER PORTS
Ports should start from 1500 and have 63000 available portsUse the below command from cmd line or Powershell to 'correct' the Dynamic TCP User Port Settings:-
netsh int ipv4 set dynamicport tcp start=1500 num=63000hope this helps ..
Thanks to everyone for all their help and input
Regards,
Noel