Hi Gertjan,
Sorry in the late reply.
Yes the databases are RW and the DBA did mirror over the db and reverted back to the production server.
Yes i am able to RDP onto the sql server and able to access the databases using sql mangement studio.
Ive checked the connections with my other 2 ev servers and they are able to connect to the sql db with no problems or errors.
the strange thing is that the services stop as they cant make the connection. or it is overloaded. while the EV services are stopped. i am able to make an odbc connection to the directory and MailboxVaultStore. When i start the services again and then test. it failes and i get the following error message from event viewer
========================================================================================================================
A program fault has raised an exception.
Exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.)
Diagnostic: Num:10055 State:0 Sev:20 Svr: Proc: Line:0
Type: System.Data.SqlClient.SqlException
Reference: DL/Archive/GetEntry/1B1EF54BF39AF724AB731875D3206C7CB1110000ENTMASP01
Command Line: "e:\Program Files (x86)\Enterprise Vault\EVIndexVolumesProcessor.exe" -URL:tcp://x.x.x.197:49311/8ad99778_bca4_469c_a981_ce76afcb374b/KVS.EnterpriseVault.ProcessManager62954519
Application Domain: EVIndexVolumesProcessor.exe
Process Id: 6540
Thread Id: 10968
========================================================================================================================
Then followed by
A program fault has raised an exception.
Exception: An attempt was made to access a socket in a way forbidden by its access permissions
Diagnostic: Error Code is 10013
Type: System.Net.Sockets.SocketException
Reference: MonitoringMiddleTier - MiddleTierDataManagerDriver::Main()
Command Line: "e:\Program Files (x86)\Enterprise Vault\MonitoringMiddleTier.exe" 9632
Application Domain: MonitoringMiddleTier.exe
Process Id: 6452
Thread Id: 4068
Stack Trace: at Symantec.EnterpriseVault.OperationsManager.MiddleTierDataAccessLayer.MiddleTierDataManagerDriver.ConfigureRemoting()
at Symantec.EnterpriseVault.OperationsManager.MiddleTierDataAccessLayer.MiddleTierDataManagerDriver.Main(String[] args)
========================================================================================================================
A program fault has raised an exception.
Exception: Could not connect to SQL database:'EVVSMailboxVaultStore1_1' at SQL Server:'EURSQL01\AMSDOC'
Diagnostic:
Type: System.Exception
Reference:
Command Line: "e:\Program Files (x86)\Enterprise Vault\EVStorageQueueBroker.exe" -URL:tcp://x.x.x.197:49291/4547eca7_db45_4faf_b8f0_330d5379497c/KVS.EnterpriseVault.ProcessManager33736294
Application Domain: EVStorageQueueBroker.exe
========================================================================================================================
A periodic Index Admin check could not determine the status of one or more Index Volumes that are managed by this server. (Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.))
========================================================================================================================
i did also have an error that there are too many connections going to the sql server from this one. is there away to reduce the amount of connections from EV to SQL server?
I have an average between 476 to 268 attempted connections to the sql server and i believe the sql server cant handle them?
someone suggested in reinstalling the binarys and it should clear up the miss confusion? Currently i only have EV11.01.1 CH1 installed.