Documentation Center

Microsoft OLE DB Provider for SQL Server:

  1. Server name: Enter the name of the server, on which the database you want to access is located. Use the alias name as in the settings for tnsnames.ora or in SQL*Plus.
  2. Enter the login information for the selected database: Enter the user name and the password to be used for authentication when you log in to the data source. The No password option allows the specified provider to return an empty string for the password within the connection string. The Allow saving password option enables storage of the password along with the connection string. Whether the password is integrated into the connection string depends on the functions of the calling application. When it is stored, the password is returned and saved in unhidden and unencrypted format.
  3. Click the Test Connection button to attempt establishing a connection to the specified data source. If the connection fails, you should check whether the settings are correct. The failed connection may, for example, be due to spelling errors or incorrect capitalization in the connection string.