When you use the DataServer to create a schema image in a schema holder, it accesses the associated MS SQL Server Database. To connect a schema holder for an MS SQL database, you must provide a valid user ID and password combination for MS SQL at connection time. Use the User ID (-U) parameter to provide the user ID and the Password (-P) parameter to provide the password. The allowed length for User ID and Password is 32 and 128 characters respectively.

Once you have set up the schema holder, the MS SQL Server privileges required for your foreign data source connection vary among users depending on their applications. For example, the user running an OpenEdge application that queries, but does not update, a table in the MS SQL Server database must connect to the MS SQL Server database with a user and password that provides at least SELECT privileges on the table.

In summary, the user ID and password combination required to run an application depends on:

  • The MS SQL Server database tables the application accesses
  • The type of access required on those tables
Note: A database administrator (DBA) must establish all user ID and password combinations within MS SQL Server.