Select SQL Server Data Dialog
- importing data from an SQL Server database via the Open Data Import Centre
- or exporting data to an SQL Server database via the Open Data Export Centre
and is displayed when browsing for a file in either of the centres with SQL Server selected as the source or export type.
Show me
|
Field |
Description |
|---|---|
|
Server |
The name of the server. |
|
Instance (optional) |
Instance name if required (e.g. myserver/sqlexpress). |
|
Database |
The name of the database. |
|
Security |
Check the Integrated Security option to authenticate connection to SQL Server by current Windows account name and password. If the Integrated Security option is unchecked, a Username and Password must be supplied. Check the Save username and encrypted password option to store the username and password entered in the boxes above. |
|
Use SRID |
Enabled when connection details entered. Select a projected SRID from the Select a Projected SRID dialog dropdown. |
