I am trying to add a MS Sql Server database as a business data store. Our prefe

bryant.st39 over 8 years ago

I am trying to add a MS Sql Server database as a business data store. Our preferred method of configuring the appian-ds file would be to use IP address to reference the server. Does the following datasource property appear to be configured properly?

<xa-datasource-property name="URL">jdbc:sqlserver:thin:@"this is where I put my IP address":1433;databaseName="this is where i put my database name"</xa-datasource-property>

Discussion posts and replies are publicly visible

0 abhi.jana
Appian Employee
over 8 years ago

msdn.microsoft.com/.../ms378428(v=sql.110).aspx
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ajinkyab277
Certified Lead Developer
over 8 years ago

We have below code snippet in our appian-ds.xml file

<xa-datasource-property name="serverName">YourIP</xa-datasource-property>
<xa-datasource-property name="portNumber">YourPort</xa-datasource-property>
<xa-datasource-property name="databaseName">YourSchema</xa-datasource-property>
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bryant.st39 over 8 years ago

Thanks...I will try this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel