SQL2008 composed of two physical server cluster database services, services for hospital HIS system database, 2 server Settings have 2 IP client software through cluster setup a virtual IP address to connect to the database, now found that 18 o 'clock virtual IP database service suddenly fault, suddenly at around 8 well,
Database failure with SQL database connection error during image is as follows:


Picture 2

Consulting the problem you have encountered a similar phenomenon, how to solve

CodePudding user response:

Ping the IP address database can test

CodePudding user response:

Virtual IP address will be a problem?

CodePudding user response:

Is MS SQL cluster set inside foreign virtual database service IP address
This is the hospital HIS system database service, more than 8 o 'clock in the morning the IP database service connection is normal, more than 18 points and then suddenly the abnormal
We have encountered such phenomenon

CodePudding user response:

Don't die at database side, you couldn't see what come of,
Look at the cluster log and the Windows event log,