connectionstring sql server versions supported
Connectionstring sql server versions supported
Microsoft SqlClient Data Provider for connectionstring SQL Server
Standard Security
Server=myServerAddress;Database=DatabaseName;User Id=UserName;Password=Password;
SQL Server 2019, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008,SQL Server 2005, SQL Server 2000, SQL Server 7.0
Trusted Connection
Server=myServerAddress;Database=DatabaseName;Trusted_Connection=True;
Connection to a SQL Server instance using connectionstring SQL Server
The server/instance name syntax used in the server option is the same for all SQL Server connection strings.
Server=ServerName\InstanceName;Database=DatabaseName;User Id=UserName;Password=Password;
SQL Server 2019, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008,SQL Server 2005, SQL Server 2000, SQL Server 7.0