Entity Framework Login Failed Error

.net entity-framework wcf

Question

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?

1
4
4/29/2014 3:52:21 PM

Accepted Answer

It was a dumb error! The absenceNT 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.Network service and Integrated security=true connected string

0
4/11/2018 10:52:59 AM

Popular Answer

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, (Integrated Security=true ) 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.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow