The Import/Export Wizard provides default values. Although other parameters may be available through the ODBC Administrator, UPS recommends that you use the parameters below.
Note: All versions of Microsoft SQL Server use the .sql file extension.
|
Attribute Name |
Basic/ |
Optional/ |
Default |
|
|
Database |
Basic |
Required |
The name of the default database for the connection. |
|
|
Description |
Basic |
Optional |
The descriptive text. |
|
|
Server |
Basic |
Required |
The name of a server running SQL Server on the network. |
|
|
Address |
Basic |
Required |
The network address of the SQL Server. |
|
|
Trusted_Connection |
Advanced |
Required |
No |
Windows Authentication is enabled for the data source. |