I've set up an app pool with WCF 4.0 integrated and hosted my WCF application in IIS. The pool identity was set up as a network service. I have already read other posts that are relevant to this problem but was unable to fix it.
Exception below is what I receive
System.Data.Entity.Core.EntityException was unhandled by user code HResult=-2146233087 Message=The underlying provider failed on Open. Source=EntityFramework
I attempted to change the app pool from the network service to the localsystem, and it was successful. Any ideas as to why, in the previous instance, it uses my system name as my login?
It was a dumb error! The absence
NT AUTHORITY\NETWORK SERVICE
account in my logins for my SQL server. It has been added with the necessary permissions. It now functions properly with my app pool settings.
The Entities Framework is unrelated to the issue. Your SQL Server is not accessible. I would look through the following:
Make sure SQL Server is running at going strong. Verify the status of any active services to see if Service for SQL Server is up.
In order to see if TCP/IP connectivity is enabled, I would examine the Configuration Manager for SQL Server.
I would examine my 34-zzz. Perhaps there is a blockage between the client and SQL Server.
If another program from the same client can connect to the same server, I'd verify that. I would then verify the different connection strings.
I would check the privileges for the account I'm attempting to connect to on the specified SQL Server and database if all of the aforementioned were playing properly. As a first step, permit everyone to access this database to see if the issue is with account rights. With this particular arrangement, (
) denotes a disregard for your account and password. You should either leave out the specific statement in the connection string or set it to false if you wish to access the SQL server with a specified username and password.
You might look at this post demonstrates connection strings.
I hope I was of assistance.