Select SQL Server Data dialog

This dialog is used when :

The dialog is displayed when browsing for a file in the above centres with SQL Server selected as the source or export type. It provides connection options for the Microsoft OLE DB Driver for SQL server, which connects to a Microsoft SQL Server database.

ClosedShow image

Select SQL Server Data dialog

Item

Description

SQL Server Connection

Server

The name of the server

Instance (optional)

Instance name if required (for example, myserver/sqlexpress)

Database

The name of the database

Integrated Security If checked, authenticates connection to SQL Server by the current Windows account name and password.
Username Username required for integrated security.
Password Password required for integrated security.
Save username and encrypted password If checked, stores the username and password entered in the boxes above.
Projected Network Coordinate System

Use SRID

Enabled when connection details have been entered.

Opens the Select A Projected SRID dialog.

Using the open data import centre

Open Data Import Centre dialog

Open Data Export Centre dialog

Select A Projected SRID dialog