Microsoft SQL Server Spatial

Select Home > Add Overlay > Databases > Microsoft SQL Server Spatial and click Next.

Before accessing spatial data from a SQL Server database, ensure the SIS Map Window is focused in the correct location and at a reasonable scale for the data being accessed (i.e 1:1250).

SIS Desktop will automatically select data from the database that coincides with the map extents of the map window.

Note: The Microsoft SQL Server Spatial requires SQL Server 2008 or later because it relies on the spatial datatype.

Enter your connection details for SQL Server or select a previously saved connection.

Option Description

Server name

Select a server name from the drop-down list or type the name of the SQL Server instance.

Selecting the database on the server is a separate action. Click Refresh to refresh the list.

If the server instance uses a port other than the default, specify the port after the server address like this: Server\SQL2016, 1434


Windows Authentication: If SQL Server has been set up to use Windows Authentication, select this option.

The SQL Server system administrator must have associated your Microsoft Windows network ID with a SQL Server login ID.

SQL Server Authentication: Select to use a supplied user name and password to authenticate your logon information to the data source.


Type the user ID for SQL Server Login


Type the password to use for authentication when you log on to the data source.


Type the name of the SQL Server database you want to access or select it from the drop-down box.

Save connection details in UI settings database (with encrypted password)

Check this tickbox to store database connection details for future use. The password will be stored in encrypted form for security.

Saved connection name

Enter a meaningful name to save this connection. Previously used names cannot be used.

If the Microsoft SQL Server Connection has been made previously and the connection details saved, they are now displayed.

In this case click on one of the Saved connections or Currently used connections (if any are in use) to complete the connection details. Click Next.

The Database connection type dialog will be displayed: