Documentation Center

Creating and testing the connection for Microsoft SQL Server

An SQL Server oriented environment makes use of the Microsoft OLE DB Provider for SQL Server.

Procedure

  1. Create a new text document in your installation directory (C:\InfoShare) and name it connection.udl.
    Note:
    • Be sure that the file extension is .udl. If required, change your Windows Explorer settings to recognize the file extension. You have created a Universal Data Link file, which has a wizard-like program associated to create connection strings.
    • Ensure that the filename was not appended with a .txt file extension. If file extensions are not visible, modify the Windows Tools > Folder Options > View, and check that Hide extensions for known file types is not selected.
  2. Start the associated program from Windows Explorer by double-clicking C:\InfoShare\connection.udl.
  3. Click the Provider tab, and select Microsoft OLE DB Provider for SQL Server.
  4. Click Next.
  5. Under the Connection tab, in the first field select or enter the SQL database server name.
  6. In the second field, select the Use a specific username and password checkbox.
    1. In the User name field, enter isource.
    2. In the Password field, enter the password for the isource user.
      The default password is isource. If you did not use the default password, be sure to enter the password used when you created the new user. The password was specified for the isource user when configuring the Microsoft SQL server.
    3. Select the Allow saving password checkbox.
  7. In the third field, select the Select the database on the server checkbox, and specify the database name.
    This is the name specified when you created the database. The database name was specified when configuring Microsoft SQL server.
  8. Test the connection by clicking Test Connection.
    If the connection is valid, a message is displayed to notify that the connection is working correctly.
  9. Click OK to confirm.
    This saves the password as plain text in the UDL file. If the connect string does not contain the password variable, no valid connections can be made with this connection string.