Switching Database To Microsoft SQL Server

 Top  Previous  Next

To use Microsoft SQL Server AggreGate Server'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:

1. Download and install the latest Microsoft SQL Server JDBC Driver. At the time of this writing, it is available at http://msdn.microsoft.com/data/jdbc/.
2. Put sqljdbc4.jar into the /lib subfolder of AggreGate Server installation folder.
3. Set Database Driver in AggreGate Server 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][:port]][;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.