To create a database connection cache for the SQL Server database over the TCP/IP protocol:
Specify the Server host field according to the following table. The TCP/IP protocol will be used by default.
|
Server name |
Connection String |
Description |
|---|---|---|
|
172.25.13.1 |
Data Source=172.25.13.1;Initial Catalog=SnapTest;User ID=sa;Password=appeon; |
Connect by IP |
|
127.0.0.1\sql2016 |
Data Source=172.25.13.1\sql2016;Initial Catalog=SnapTest;User ID=sa;Password=appeon; |
Connect to the specific instance by IP |
|
RemoteDBMachineName |
Data Source=RemoteDBMachineName;Initial Catalog=SnapTest;User ID=sa;Password=appeon; |
Connect to the remote database by its machine name |
|
RemoteDBMachineName\instancename |
Data Source=RemoteDBMachineName\instancename;Initial Catalog=SnapTest;User ID=sa;Password=appeon; |
Connect to the specific instance by its machine name |
|
tcp:(local)\MSSQLSERVER01 |
Data Source=tcp:(local)\MSSQLSERVER01;Initial Catalog=SnapTest;User ID=sa;Password=appeon;" |
Force to use TCP/IP protocol to connect to the specified local instance |
