Cannot Connect To Remote Sql Server With ConnectionString

Question

I'm developing a Winform project that needs to connect to a remote Sql server. I'm using Entity Framework as ORM. Here is my connectionstring

<add name="RemoteConnection" connectionString="Data Source=*****;Initial Catalog=****;User Id=****;Password=*****;Integrated Security=True;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

I get the following error when i want to connect remote sql server

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Everything works fine with SQL server management studio, i'm able to see databases and have access to them, but when in comes to code i get error

You have chose Windows authentication while adding entity model, instead select SQL Server Authentication. — SᴇM
– SᴇM, Commented Nov 6, 2017 at 12:03

sepupic · Accepted Answer · 2017-11-06 12:08:49Z

2

User Id=****;Password=*****;Integrated Security=True

is wrong. If you want to use Integrated security, you should not pass any credential (leave only Integrated security= True).

If instead you want to use SQL Server login (+ password), pass only them and exclude Integrated security= True

answered Nov 6, 2017 at 12:08

sepupic

8,7371 gold badge11 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot Connect To Remote Sql Server With ConnectionString

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related