Our application has a triple set up of servers(Web, App, DB). Web tier consists of the UI and app layer consists of the services. Each has their own dedicated server. Recently our client asked for migration of the DB server to 2016 (Its in 2008 now). So i have taken a DB backup from 2008 and restored in the 2016 DB server. Then i configured the app layer services(WCF & WebServices) to point the 2016 DB. Now i couldnt login. and i checked the services using WCF test client and i got the following error
The underlying provider failed on Open. FULL EXCEPTION: System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: The underlying provider failed on Open. (Fault Detail is equal to An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true
Detailed Inner Exception Message:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInterna...). System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at : at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at client.services.SSO.validatesptoken()..
And sometimes i get this inner exception error msg too
Test ERROR MESSAGE:Execution of the command requires an open and available connection. The connection's current state is broken. FULL EXCEPTION: System.ServiceModel.FaultException
1[System.ServiceModel.ExceptionDetail]: Execution of the command requires an open and available connection. The connection's current state is broken. (Fault Detail is equal to An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is: System.InvalidOperationException: Execution of the command requires an open and available connection. The connection's current state is broken. at System.Data.Objects.ObjectContext.EnsureConnection() at System.Data.Objects.ObjectQuery1.GetResults(Nullable`1 forMergeOption) at
But this error only comes for the services using entity framework, the other web services are working fine. I will post the EF connection string too
<add name="SSOObjectContext" connectionString="metadata=res://*/SSOModel.csdl|res://*/SSOModel.ssdl|res://*/SSOModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=myDBServer;initial catalog=***;Persist Security Info=True;User ID=***;Password=***;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />
This has nothing to do with the user privileges or connection strings as i have tried and modified using the answers but could not find any luck. this turning out to be a thorn as any help would be much appreciated.