SQL Server Connection Strings

Standard Kullanım

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

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

Trusted Connection İle Kullanım

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

1	Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

SQL Server Instance Name ile Bağlanma

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

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

Farklı Port Kullanan Sunucuya Bağlanma

Server=myServerName,myPortNumber;Database=myDataBase;User Id=myUsername;Password=myPassword;

1	Server=myServerName,myPortNumber;Database=myDataBase;User Id=myUsername;Password=myPassword;

İp Adresi Üzerinden Bağlanma

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

1	Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;