Linked Servers

Sequenchel relies on Linked Servers to contact other SQL Servers in your network. You can easily create Linked Servers with the properties that Sequenchel favors.

Click on Tools / Linked Servers to open the Linked Servers screen.

The Linked Servers screen connects to a host server. It will connect to the server that is defined in the currently selected connection. If you have multiple Sequenchel databases on several servers, you should define a connection to each of them so you can make Linked Servers on all of them simply by changing the selected connection. If no connections have been defined and the connection XML document does not yet exist, your main database will be loaded as the default connection. If the main database also doesn’t exist (yet), the Linked Server screen has no target host and will not function.

If you enter Server, Instance, TCP Port and Domain the other fields will fill out themselves. If you use the default port of 1433, leave the field blank and uncheck the checkbox. The same is true for the field Instance if you are using the default instance.

If you check the checkbox for Linked Server or Data Source, you can manually edit the connection string and Linked Server Name.

The Linked Server screen does not (yet) support creating logins. If you need a SQL login to connect to another server we recommend that you use SQL Server Management Studio (SSMS) to create your Linked Server. Make sure the properties you select in SSMS match the defaults in Sequenchel.