Select Database Source

SQL Server Database login is required to analyze a database.

For information about the available buttons in the Wizard step above click here.

Entering Connection Information

1. Server: From the Server list, select an entry from the listed Servers. If the Server is not listed, you can directly type in its name in the form: HOST-NAME\SERVER_INSTANCE.

See Also:

For a detailed description of the "Server Selection Procedure" process, click here.

2. Select a security (authentication) mode.

a. Windows Authentication: Windows Authentication mode allows to connect to SQL Server using a Windows user account. In this mode Windows is completely responsible for authenticating the client. It offers the highest security and is the preferred method to connect to SQL Server. When you use this mode to connect from ApexSQL Clean to SQL Server, the Credentials text-boxes are disabled and ignored.

b. SQL Server Authentication: In contrast to Windows Authentication Mode is SQL Server completely responsible for the user authentication. SQL Server performs the authentication by checking if the user name and the password supplied by the client are matched in the list of valid user names and passwords. When you select this mode to connect from ApexSQL Clean to SQL Server, the Credentials textboxes are enabled and you need to enter here the information ApexSQL Clean will use to connect to SQL Server.

Credentials

If you have chosen to connect to SQL Server by SQL Authentication mode, you mandatory need to enter here the user name and its associated password that ApexSQL Clean will use to establish the connection. The user must exist in SQL Server or otherwise the connection attempt will fail.

If you check Store Encrypted Password option, ApexSQL Clean will store the supplied password in encrypted form on disk along with the project information. ApexSQL Clean uses a strong machine-dependant encryption algorithm for password encryption; however you need to be aware of the implications. Therefore we recommend you use Windows Authentication to connect from ApexSQL Clean to SQL Server.

3. Select a database.

Show System Databases: If you wish to include SQL Servers' system databases in the Database selection list, check this box.

4. Click . If you have provided valid user credentials, then you can continue with the next step.