Why won't my c# connection string to a SQL server work with Windows authentication?

Question

Why won't my connection string to SQL server work with Windows authentication? A sql user works fine, acme\administrator or [email protected] won't work. This is a Win Form app written in C#.

    {
        OdbcConnection cn = null;
        String connectionString;
            connectionString = "Driver={SQL Server};Server=" + cbxDataSources.Text +";Database=" + strDatabase + ";";

            connectionString += "UID=" + textBoxUserName.Text + ";";
            connectionString += "PWD=" + textBoxPassword.Text + ";";

        cn = new OdbcConnection(connectionString);
        return cn;
    }

Thanks guys

I like this site a lot for helping out with these types of questions: connectionstrings.com — Eric Tuttleman
– Eric Tuttleman, Commented Oct 15, 2008 at 22:51

yfeldblum · Accepted Answer · 2008-10-15 22:41:02Z

15

You are using SQL Server authentication.

Windows authentication authenticates your connection with the Windows identity of the currently executing process or thread. You cannot set a username and password with Windows authentication. Instead, you set Integrated Security = SSPI.

answered Oct 15, 2008 at 22:41

yfeldblum

65.5k12 gold badges132 silver badges169 bronze badges

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

Comments

JamesSugrue · Accepted Answer · 2008-10-15 22:50:15Z

7

You have to connect using a Trusted Connection.

2005:

Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;

2000:

Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes;

answered Oct 15, 2008 at 22:50

JamesSugrue

15k10 gold badges63 silver badges93 bronze badges

Collectives™ on Stack Overflow

Why won't my c# connection string to a SQL server work with Windows authentication?

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