It's my first time posting here so I hope I'm doing it right.

jacquesc over 11 years ago

It's my first time posting here so I hope I'm doing it right.

Part 1) I am using Configuration Manager to install Appian and need information on setting up the local.properties file. The section I am working on is configuring the primary and secondary databases (lines 223 to 243 in the local.properties file). The example file only contains MySQL properties and our databases are SQL Server 2012. Can I get a sample file similar to our setup?

Part 2) I will also need Appian to connect to an existing SQL 2008 database on a server separate from the Primary and Secondary databases using Configuration Manager.

Thank you.
Jacques
...

Discussion posts and replies are publicly visible

0 hemalathat
A Score Level 1
over 11 years ago

forum.appian.com/.../Configuring_Relational_Databases
Please refer to this link for configuring relational databases with Appian and this includes SQL server. Appian can connect to an existing SQL database other than Primary and secondary. Steps will be name, only server and connection details will change in the configuration file.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jacquesc over 11 years ago

Thanks hemalathat. I followed the instructions but I discovered that, because the server name has a \\ in the name, it gets loaded incorrectly in the appian-ds.xml file.

in the local.properties file:
conf.data.primary.host=devstjwin369\ est2012

After running the ant command, in the appian-ds.xml file:
devstjwin369 est2012
The \ gets changed to a tab.

I tried / and I tried " " without success.

help?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jacquesc over 11 years ago

I found the answer... need \\\\ in server name
conf.data.primary.host=devstjwin369\\\ est2012
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel