Entity framework connection string enable to connect to DB server

Question

I'm using the entity framework in a winforms application.

When i set scsb.DataSource ="localhost" every thing works fine but when i try to connect to onother DB server i got an exception:

"The underlying provider failed on Open."

public DistributionSSEntities1 Connection()
{
    var scsb = new SqlConnectionStringBuilder();
    scsb.DataSource = "192.168.1.100";
    scsb.InitialCatalog = "DistributionSS";
    scsb.IntegratedSecurity = true;
    //------------------------
    EntityConnectionStringBuilder builder = new EntityConnectionStringBuilder();
    builder.Metadata ="res://*/Model.Model.csdl|res://*/Model.Model.ssdl|res://*/Model.Model.msl";
    builder.Provider = "System.Data.SqlClient";
    builder.ProviderConnectionString = scsb.ConnectionString;
    DistributionSSEntities1 db = new DistributionSSEntities1(builder.ToString());
    return db;
}

Do that server works? try to access it first using your vs studio. check also your web config connection string. — BizApps
– BizApps, Commented Jun 5, 2013 at 10:09
are you sure you have windows authentication account for the server you are trying to access — rajansoft1
– rajansoft1, Commented Jun 5, 2013 at 10:16
The "The underlying provider failed on Open" exception has an InnerException which tells you exactly what is wrong. Either TCP/IP access is not enabled, the server is not running or not accessible (firewall?), or the user you try to access the database with is not authorized to do so. — CodeCaster
– CodeCaster, Commented Jun 5, 2013 at 10:17
@CodeCaster: if the sql server rejected the connection/login attempt you're almost certainly NOT going to get valid info from an inner exception - see my edit on why. — Quinton Bernhardt
– Quinton Bernhardt, Commented Jun 5, 2013 at 15:36

Quinton Bernhardt · Accepted Answer · 2013-06-05 15:48:36Z

Has the remote Sql been setup to allow remote connections? Has the remote Sql been allowed access through the windows firewall... there's so many reasons why it wouldn't connect.

You're using Integrated Security - which may work great for a local Sql; but the network user that your WinForm app is running under must have the correct rights to access the remote box.

I'd suggest to start eliminating possibilities do the following:

Check the Sql logs on the target server. That always has the exact reason why an attemp failed - not the watered down version you get through the exception. (eg. C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Log)
Connect to it using a sql username password - not integrated security to make sure it's not that
Firewall

EDIT

It's important to remember that the error messages return to the client regarding login attempt failures are purposefully obscure or without information - to limit an attacker gaining enough information to improve the attack (see the technet article for proof). So checking the Sql Server logs is a necessity - if your login/connection attempt actually made it to the server.

From Article:

To increase security, the error message that is returned to the client deliberately hides the nature of the authentication error. However, in the SQL Server error log, a corresponding error contains an error state that maps to an authentication failure condition. Compare the error state to the following list to determine the reason for the login failure.

Anouar · Accepted Answer · 2013-06-05 15:10:53Z

0

 public DistributionSSEntities Connection()
    {
        string ConString = "SERVER=192.168.1.100;DATABASE=DistributionSS;UID=sa;PASSWORD=125;";
        SqlConnectionStringBuilder SCB= new SqlConnectionStringBuilder(ConString);
        //------------------------
        EntityConnectionStringBuilder builder = new EntityConnectionStringBuilder();
        builder.Metadata = "res://*/Model.Model.csdl|res://*/Model.Model.ssdl|res://*/Model.Model.msl";
        builder.Provider = "System.Data.SqlClient";
        builder.ProviderConnectionString = SCB.ConnectionString;
        DistributionSSEntities db = new DistributionSSEntities(builder.ToString());
        return db;
    }

answered Jun 5, 2013 at 15:10

Anouar

752 silver badges12 bronze badges

Collectives™ on Stack Overflow

Entity framework connection string enable to connect to DB server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related