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

See:forum.appian.com/.../Configuring_Relational_Databases
You can configure any number of data sources connecting to any number of supported databases. In your Querying node, you will need to specify the JDBC that you're connecting.

Thanks.. but what I want is to connect with another DB.
I founded Query Database node BUT I've any problem to connect with MS SQL Server 2008 using appian 6.6.1.

With Mysql no problem :)

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