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 9.1 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 and click Next.

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

Authentication

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.

Login

Type the user ID for SQL Server Login

Password

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

Database

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.

The Database connection type dialog will be displayed: