Configuring the SARest Service to connect to a SQL server on a different computer

Integrating : Open Services for Lifecycle Collaboration (OSLC) : Configuring System Architect as a provider : Configuring the SARest Service to connect to a SQL server on a different computer

If your SARest Service is running on a separate computer from your SQL server, you must enable Basic Authentication, and setup an SQL user that has access to the encyclopedia, including the catalog if it is an Enterprise encyclopedia.

To do this you have two options to choose from, using the SARest Configuration tool or edit the configuration file manually.

1 Open the System Architect installation folder. By default, the folder is:

C:\Program Files\UNICOM Systems\System Architect Suite\System Architect

2 Locate and run SAOSLCProviderConfig.exe.

3 On the Rest Server Config tab, use the Authentication Type drop-down to select Basic.

4 Enter your SQL user and password in the appropriate fields.

5 Go to File > Save Configuration. If prompted, restart the REST Service.

Editing the configuration file manually

1 Locate and edit the SARESTWebService.exe.config file that is located in the System Architect installation directory.

2 Set the key BasicAuthentication to true.

3 Enter your SQL user and password in the connection Strings next to the DBUser and DBPassword keys.

4 Save the file. If REST Service is running, restart it for changes to take effect.