C# Connect to MS SQL Server using Active Directory Service Account

Question

I have a stand alone application that works great with a Local user account in MS SQL. When I try to use an active directory service account instead I appear to be running into problems.

It appears Microsoft want's the exe to run as the domain user service account which is not an option for me. Looking at alternatives, one person mentioned having main exe launching a second exe that does the work or having a local windows service.. neither of these are an option either. It feels like this is getting more complex then it needs to be.

Here is an example of the piece of code I am working with:

private void MakeConnection(){
    string ServerNM = @"MyServer";
    string Database = @"Test01";
    string Username = @"testdomain\testuser";
    string Password = @"testpass";

    string connection_string = "Server=" + ServerNM 
        + "; Database=" + Database 
        + "; User ID=" + Username 
        + "; Password=" + Password
        + "; Max Pool Size= 1000;";

    try {
        SqlConnection oSqlConnectionTest = new SqlConnection(connection_string);
        oSqlConnectionTest.Open();

    }catch(Exception oException){
        MessageBox.Show("Error: " + oException.ToString());
    }
}

Is this a real limitation or am I missing something?

You're missing something. Are you sure the service account has permissions to the database? Are you catching an exception? What's the error? — itsme86
– itsme86, Commented Apr 24, 2014 at 16:04

Oskar Sjöberg · Accepted Answer · 2015-07-09 11:52:19Z

1

SQL Server does not accept domain accounts in the connection string for security reasons.

answered Jul 9, 2015 at 11:52

Oskar Sjöberg

2,91831 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

C# Connect to MS SQL Server using Active Directory Service Account

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