C# SQL Server authentication string

Question

The IT changed the SQL Server to a new Microsoft SQL Server 2017, and some apps stopped working. These apps (C#) use a connection string like this:

SqlConnection conn = new SqlConnection("Data Source=192.168.100.101;Initial Catalog=Warehouse;Persist Security Info=True;User ID=****;Password=******");

But the new server works with Windows authentication. I'd like to know how to change the authentication for the new SQL Server to make apps work again.

Thanks guys.

Check connectionstrings.com or simply remove the User ID and Password keys and Add Trusted_Connection=Yes — Steve
– Steve, Commented Jan 18, 2019 at 21:59
I tried this string, but still cannot connect to DB. Is there a way to change the authentication type from Windows Authentication to sort of network authentication, just as it was before with a username and password? — Claude
– Claude, Commented Jan 18, 2019 at 22:38

Frankely Diaz · Accepted Answer · 2019-01-18 22:32:21Z

1

In that case you can use the Integrated Security options, so the windows account that is running your C# program will be used

SqlConnection conn = new SqlConnection("Data Source=192.168.100.101;Initial Catalog=Warehouse;Integrated Security=True");

More info here https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectionstring?view=netframework-4.7.2

answered Jan 18, 2019 at 22:32

Frankely Diaz

9061 gold badge9 silver badges16 bronze badges

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

2 Comments

Jaskier Over a year ago

What if it's multiple users? Should all users have access to the SQL Server? What if the database has a specific login account that it uses?

Claude Over a year ago

I tried this string but still cannot connect to DB.

Collectives™ on Stack Overflow

C# SQL Server authentication string

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related