Connection string for local database not working

Question

I have a database on my local machine on SQL Server Management studio.

The database connection information is as follows. DB info

In my c# application, I have a connection string to connect to this database. I get an error though saying my connection string is incorrect. I have tried a number of different ones.

This is my function to connect to a database.

  public virtual void openConnection()
    {
        con = new SqlConnection();
        con.ConnectionString = "Server=DESKTOP-8UDMQUI\\WILLIAMSQL;Initial Catalog=team3db;TrustServerCertificate=true;";

        try
        {
            con.Open();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex);
        }
    }

I have two \ in the server name because when I only have one, it has a red squiggle line under it throwing me an error on visual studio.

What should my connection string be? Note there is no password on this database.

If you want to use windows authentication in your conString. Then use con.ConnectionString = "Server=DESKTOP-8UDMQUI\\WILLIAMSQL;Initial Catalog=team3db;TrustedConnection=true;"; — Muhammad Hannan
– Muhammad Hannan, Commented Aug 8, 2019 at 20:56

David Donari · Accepted Answer · 2019-08-08 20:58:39Z

2

Replace TrustServerCertificate = true; with Integrated Security = true

answered Aug 8, 2019 at 20:58

David Donari

6679 silver badges18 bronze badges

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

1 Comment

David Donari Over a year ago

The TrustServerCertificate keyword is valid only when connecting to a SQL Server instance with a valid certificate.

Collectives™ on Stack Overflow

Connection string for local database not working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related