C# connects sqlserver to two types of connection strings for windows and sqlserver authentication

summer · Posted on 11/15/2019 2:25:20 PM

sql server authentication connection string private string ConnstrSqlServer = "server=server name; uid=login name; pwd = login password; database=database name";

windows authentication connection string private string connstrWindows = "server=server name; database=database name; Trusted_Connection=SSPI";

Access the SQL Server 2008 database in C# code using SqlClient

.NET Framework Data Provider for SQL Server standard writing
Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword;

.NET Framework Data Provider for SQL Server is another standard way to write it
Server=myServerAddress; Database=myDataBase; User ID=myUsername; Password=myPassword; Trusted_Connection=False;

.NET Framework Data Provider for SQL Server Trust Connection Writing
Data Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI;

The .NET Framework Data Provider for SQL Server is another way to write trust connections
Server=myServerAddress; Database=myDataBase; Trusted_Connection=True;

[Communication] C# connects sqlserver to two types of connection strings for windows and sqlserver authentication

Sections viewed