- Connecting to MS SQL Server

Connecting to MS SQL Server

To allow connections, your SQL SERVER instance MUST allow REMOTE CONNECTIONS and have TCP/IP enabled.

This video demonstrates how to enable these configuration steps.

WOW supports MS SQL Server 2000 and above, which is supported by the latest JDBC driver.

You may have connection problems if trying to connect to a version under MS SQL Server 2000.

URL - jdbc:microsoft:sqlserver://hostname:port;databasename=dbname

Example: jdbc:microsoft:sqlserver://192.169.1.71:1433;databasename=Northwind

The above example uses SQL Server authentication and requires a User to be set up on the SQL Server.

In WOW version 7.1 the ability to use Trusted (also known as Windows) Authentication was added via the use of the jTDS driver. The following describes how to set up your JDBC string for Trusted Authentication.

URL - jdbc:jtds:sqlserver://hostname:port;databasename=dbname;integratedSecurity=true;authenticationScheme=JavaKerberosDomain;domain=serverdomain

Example: jdbc:jtds:sqlserver://192.169.1.71:1433;databasename=Northwind;integratedSecurity=true;authenticationScheme=JavaKerberosDomain;domain=na

For more information on SQL Server Authentication Modes or help in deciding which mode to use, please see this Microsoft article:

https://msdn.microsoft.com/en-us/library/ms144284.aspx

Web Object Wizard must be able to resolve the host name or specified IP.

Port 1433 is the default port and is optional. A particular database instance can be identified by databasename.

Connection Properties can be supplied on the connection to influence driver behavior.

http://msdn.microsoft.com/en-us/library/ms378988.aspx

For example, the following may be specified on the connection properties:

responseBuffering=adaptive;sendStringParametersAsUnicode=false;

SQL Server Docs: http://msdn.microsoft.com/en-us/library/bb545450.aspx

SQL SERVER CONNECTION Requirements:

To enable WOW to connect to SQL Server, ensure the following:

* You must have a valid SQL SERVER Userid and Password

* SQL SERVER TCP/IP must be enabled: http://technet.microsoft.com/en-us/library/hh231672.aspx

* SQL SERVER Remote Connections must be enabled:

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx