Dear all, Is it possible to create a process that connect in a MS sql server for

The link Sathya shared with you also include an example for SQL Server. If you are using Appian 6.6.1 the relevant information is at forum.appian.com/.../Configuring_Relational_Databases

Given your SQL Server is in a separate server you need to make sure the firewall rules have been properly set to allow the application server box connect to the SQL Server instance (check this with the IT Team/Server Administrator).

Additional steps that you may need to perform on the SQL Server side:

1.          In SQL Server Configuration Manager navigate to SQL Server Network Configuration --> Protocols for SQLSERVER.
2.          Enable the VIA options by double clicking on it.
3.          Then open TCP/IP and set TCP Dynamic Ports: 1433 (or something else) under Protocol-->IP Address-->IP All

* The port of #3 will be what you will use when configuring your appian-ds.xml

The link Sathya shared with you also include an example for SQL Server. If you are using Appian 6.6.1 the relevant information is at forum.appian.com/.../Configuring_Relational_Databases

Given your SQL Server is in a separate server you need to make sure the firewall rules have been properly set to allow the application server box connect to the SQL Server instance (check this with the IT Team/Server Administrator).

Additional steps that you may need to perform on the SQL Server side:

1.          In SQL Server Configuration Manager navigate to SQL Server Network Configuration --> Protocols for SQLSERVER.
2.          Enable the VIA options by double clicking on it.
3.          Then open TCP/IP and set TCP Dynamic Ports: 1433 (or something else) under Protocol-->IP Address-->IP All

* The port of #3 will be what you will use when configuring your appian-ds.xml