How to connect VB.net to SQL Server 2005 Express using Windows Authentication?

Question

 Public DbCon = "Data Source="";User ID="";Password="";Initial Catalog="";"

So far this is the code for SQL Server Authentication that I know.

I want to know the connection string for Windows Authentication

https://www.connectionstrings.com/sql-server/ – JodyT Mar 05 '15 at 06:16 — JodyT, Mar 05 '15 at 06:16

score 0 · Accepted Answer · answered Mar 05 '15 at 06:29

0

Use the following code for an Sql Express connection on the local machine:

     Public DbCon = "Data Source=.\sqlexpress;Trusted_Connection=True;"

answered Mar 05 '15 at 06:29

masterw

score 0 · Answer 2 · answered Mar 05 '15 at 14:12

The 2005 specific connection string is:

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Unless you have specified an instance name during SQL Express setup, in which case use:

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;

2 Answers2