Hi, receiving the below error with event id 1474 and source MSSQL while server DB01 tries to connect to DB03 server. Database mirroring connection error 4 'An error occurred while receiving data:'64(the specified network name is no longer available)'.'for TCP://FQDNofserver:5023'. For your Information- We have database mirroring configured in between DB01 and DB03. Principal database is configured on DB01, Mirror is configured on DB03 and Witness is configured on DB02. Witness server check the connection in between Principal and Mirror database every 10 seconds and if the connection is not available DB Failover is initiated automatically. Please help...
This blog is a diary, which helps me as well as others while surfing about SQL Server. Some articles are written by me some were taken as reference from others websites. Box 36, Springville, Utah - 84663, USA +1 888 900 4529.
Sql Server Error 1474 State 10th
Sql Server Error 1474 State 1017
1 Show 0