How to make the sql database installer setup in visual studio use Windows Authentication?

Question

I have been following this tutorial to install the database script using a setup. But it only works for the SQL login credentials.

Walkthrough: Using a Custom Action to Create a Database at Installation

How do I make this work with Windows Authentication credentials?

Answer 1

For C# you can start below: See if you can get a connection to open. If you are not using localhost change it to server address.

public class SQLconn{
    public  SqlConnection myConnection = new SqlConnection("user id=xxx;" +
                                       "password=xxx;server=localhost;" +
                                       "Trusted_Connection=yes;" +
                                       "database=dbname; " +
                                       "connection timeout=30");
    public void connect(){
      try {
         myConnection.Open();
      }catch (Exception e){
         MessageBox.Show(e.ToString());
      }
    }
}