Usecase:
Sometimes it is necessary to run the Micrsosoft SQL server on a port other than the standard port 1433.
To enable the i4SCADA server to use the new port, 2 simple steps are required.
The following steps assume that the SQL server port has already been configured accordingly.
Solution:
- Step1
- Open i4Studio
- Add a comma at the end of the database server host name followed by the port number.
for example <servername>\<instance name>,1434 - Login to i4Studio with the corresponding port.
- Step 2
- Accept or reset the new database settings in i4Studio
- If the i4studio is opened with a different database configuration, a query appears asking whether the new configuration should be adopted. Confirm this query with “yes”
- If you have answered “No” to the query, you can make the settings again via the settings area. Then select the “DSN settings” option. Again, enter the database server name followed by a comma and port number. Click on the “Check” button to verify the settings and then on the “OK” button to save the settings.