|
To use Microsoft SQL Server LinkServer's database engine, follow the generic instructions from Switching To Another Database Engine article. Here is a list of notes specific to Microsoft SQL Server:
| 2. | When adding Microsoft SQL Server JDBC Driver driver library to .vmoptions file, specify the full path to sqljdbc.jar that is located in JDBC Driver's installation directory. |
| 3. | Set Database Driver in LinkServer Global Configuration Setting to com.microsoft.sqlserver.jdbc.SQLServerDriver. This is the java class name for the Microsoft SQL Server driver. |
| 4. | The Database URL setting for the Microsoft SQL Server database has the following format: jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]], where jdbc:sqlserver:// is known as the sub-protocol and is constant, serverName is the DNS name or IP address of the server to connect to (can be locahost), instanceName is the instance to connect to on serverName (If not specified, a connection to the default instance is made), portNumber is the port to connect to on serverName (The default is 1433). For example, if your Microsoft SQL Server runs on 192.168.0.1, on the default port, use the following URL to connect to the default instance: jdbc:sqlserver://192.168.0.1:1433. You can also omit the default port and use jdbc:sqlserver://192.168.0.1 instead. |
| 5. | Set Database Dialect setting to SQLServerDialect. |
|