This documentation is archived and is not being maintained.

Specify Target SQL Server (Package Installation Wizard)

Use the Specify Target SQL Server page to specify options for deploying the package to an instance of Microsoft SQL Server 2005.

Server name

Specify the name of the server to deploy the packages to.

Use Windows Authentication

Specify whether to use Windows Authentication to log on to the server. Windows Authentication is recommended for better security.

Use SQL Server Authentication

Specify whether the package should use SQL Server Authentication to log on to the server. If you use SQL Server Authentication, you must provide a user name and password.

User name

Specify a user name.


Specify a password.

Rely on server storage for encryption

Select to use security features of the Database Engine to secure the packages.


Go to the next page in the wizard.


Skip to the Finish the Package Installation Wizard page. Use this option if you have backtracked through the wizard pages to revise your choices and have specified all of the required options.