Configuring the Connection to the Microsoft SQL Server Database with the SQL Gateway Console

Preconditions

Before you configure the connection to the SQL database with the SQL Gateway Console, make sure that you already executed the steps for establishing an SQL connection:

Step 1: Set up the PC on which you intend to install the SQL Gateway.
Step 2: Set up your SQL database.
Step 3: Install the SQL Gateway.

To configure a connection to a database, you first have to configure a general Database Server for SQL Server. In a second step, configure one or more Database Connections to specific databases that are accessible via the Database Server.

Configuring Access to Database Servers

This procedure describes how to define the access to a database server:

Step	Action	Remark
1	In the Configuration tab of the SQL Gateway, right-click the Database Servers node in the tree structure on the left-hand side and execute the command New Database Server.	Result: A new subnode with a default name is created.
2	Enter a unique Server Name in order to identify this database server.	–
3	Select SQL Server from the Server Type list.	After you have selected SQL Server as Server Type, the configuration parameters described in this chapter are displayed.
4	Enter the Server Address in order to identify the SQL Server instance.	The Server Address has the format: `host-name\instance-name` `host-name` is the network name of the PC. `instance-name` is the name of the SQL Server instance as defined during the installation of the SQL Server. If the SQL Server is running on the same PC as the SQL Gateway, enter `(local)` as `host-name`. If the SQL Server is the default instance, leave the `instance-name` empty. For a detailed description of the address formats, refer to your SQL Server documentation.
5	Select the Authentication Mode.	If the Authentication Mode is set to SQL Server, the parameters User Name and Password are displayed.
6	As User Name, enter the name of the SQL Server login to be used.	–
7	Enter the Password, enter the password of the SQL Server login to be used.	–
8	Click the Test Server Connection button in order to verify whether the connection to the database server can be established with the parameters configured. Result: A message is displayed indicating the result of the test.	–

Configuring the Database Connections

This procedure describes how to create a connection to a specific database:

Step	Action	Result/Remark
1	In the Configuration tab of the SQL Gateway, right-click the Database Connections node in the tree structure on the left-hand side and execute the command New Database Connection.	Result: A new subnode with a default name is created.
2	Enter a unique Connection Name in order to identify this database connection.	Make sure that exactly the value of the parameter Connection Name is used in the client configuration: The element wsDbConnectionName configured in the EcoStruxure Machine Expert SqlRemoteAccess library must have the identical value as the parameter Connection Name.
3	From the Server Name list, select the database server that hosts the database you want to connect to.	The Server Name list contains entries for those servers that are defined under the Database Servers node. After you have selected a database server as Server Name, the configuration parameters described in this chapter are displayed.
4	Enter the Database Name of the database.	–
5	In order to add further parameters to the configuration of your database connection, click the Select button and activate the parameters of your choice in the Select Advanced Properties dialog box.	Result: After you have confirmed your selection with OK, the selected parameters will be displayed in the editor and can be configured.
6	Click the Test Database Connection button in order to verify whether the connection to the database can be established with the parameters configured.	Result: A message is displayed indicating the result of the test.