Download and install the driver for MS SQL Server
If a client wants to run SQL Server as their mobile server database, then they need to download the driver for MS SQL Server.
About this task
Procedure
- Visit the Microsoft Developer Network site. https://msdn.microsoft.com
- Search the site for Microsoft JDBC Driver for SQL Server.
- Click Microsoft JDBC Driver for SQL Server.
- On the resulting page, click Download the Microsoft JDBC Driver 6.0 (Preview), 4.2, 4.1, or 4.0 for SQL Server.
- Select your language, and then click Download.
- Choose the download files you want according to your mobile server’s host environment.
-
Click Next.
The download should begin, and the completed download files should be in your usual downloads folder.
- To install the driver, stop Tomcat.
- Copy the downloaded sqljdbc4.jar file into the tomcat/webapps/<sis-mobileserver>/WEB-INF/lib folder on the web server.