Select SQL Server Data dialog

This dialog is used when :

• importing data from an SQL Server database via the Open Data Import Centre.
• exporting data to an SQL Server database via the Open Data Export Centre.
• updating the network and control from an SQL Server database using model builder. The data needs to be in a pre-defined schema in SQL Server.

The dialog is displayed when:

• Browsing for a file in the above centres with SQL Server selected as the source or export type.
• Selecting Connect to SQL Server in the Model Builder dialog.

It provides connection options for the Microsoft OLE DB Driver for SQL server, which connects to a Microsoft SQL Server database.

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.