My connection string using Windows authentication for SQL Server doesn't work

Question

I'm having problems whenever I run my application, it says that the connection is wrong. The error is User '' has failed.

I think I didn't specify the user id and password but I don't know what is the user id and my password.

Here's my connection string

public SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=PayrollDB;Persist Security Info=True;");

Thanks in advance!

Akshey Bhat · Accepted Answer · 2016-05-11 16:47:26Z

6

public SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=PayrollDB;Persist Security Info=True;Integrated Security=true;");

add Intergrated Security=true to connection string.

edited May 11, 2016 at 16:47

answered May 11, 2016 at 12:22

Akshey Bhat

8,6772 gold badges23 silver badges20 bronze badges

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

6 Comments

mark333...333...333 Over a year ago

error says " Additional information: Keyword not supported: 'intergrated security'."

Akshey Bhat Over a year ago

Change it to Integrated Security. I spelled it incorrectly

mark333...333...333 Over a year ago

I already tried, no error has found but while running, it instantly stopped and I don't know why :(

Akshey Bhat Over a year ago

Debug and check for any errors. Are you able to open connection using con.Open()

mark333...333...333 Over a year ago

Thank you so much :D It is really crucial when you missed the name of the database. VS doesn't even recognize the error and I really need to check each lines of my connection to find the persisting bug. Thank you @Akshey. God bless! + :)

|

MarPreSI · Accepted Answer · 2016-05-11 12:35:57Z

2

You need to add the connection string attribute: Integrated Security = true. And this will work correctly.

answered May 11, 2016 at 12:35

MarPreSI

213 bronze badges

1 Comment

mark333...333...333 Over a year ago

Error says " Additional information: Keyword not supported: 'intergrated security'."

andrew.fox · Accepted Answer · 2021-05-26 20:36:32Z

1

To allow windows authentication, you need to add integrated security set as tru in your connection string like this:

public SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=PayrollDB;Persist Security Info=True;Integrated Security=true;");

edited May 26, 2021 at 20:36

andrew.fox

8,0696 gold badges56 silver badges83 bronze badges

answered May 11, 2016 at 12:29

error_handler

1,21112 silver badges19 bronze badges

2 Comments

mark333...333...333 Over a year ago

Error says " Additional information: Keyword not supported: 'intergrated security'."

andrew.fox Over a year ago

I've fixed the typo. It's Integrated Security=true

Collectives™ on Stack Overflow

My connection string using Windows authentication for SQL Server doesn't work

3 Answers 3

6 Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related