Setting up connection to Microsoft SQL Database

A linked server is used by GLT to access the M3 BE database. The required settings for a linked server depend on the type of database and the selected data provider.

  1. Open Microsoft SQL server Management Studio and connect to the server where the GLT databases are located.
  2. Expand Server Objects, right click Linked Servers and select New Linked Server.
  3. Select the General Page and enter a name for the linked server.
  4. In the server type, select other data sources.
  5. From the Provider drop down menu select Microsoft OLE DB Provider for SQL Server.
  6. Enter a product name.
  7. Enter database name and instance of the M3 BE database for Data source.
  8. Select the Security page.
  9. Click Be made using this security context and enter Remote login and password with read access to your M3 BE database.
  10. Click OK to complete the linked server setup.

    The connections are verified unless prompted otherwise.