Is anyone out there using microsoft sql express 2005 with an appian installation

Is anyone out there using microsoft sql express 2005 with an appian installation of v7.2?
I could use some help or pointers with the ds config. It will not honor the example on the installation docs or the version I had working for 6.7.
Thanks, James...

OriginalPostID-79072

OriginalPostID-79072

  Discussion posts and replies are publicly visible

Parents
  • its all about the connection, that's for sure.
    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host //LNNOIS009., port 1433 ha
    s failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host an
    d accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
    I am certain it is how you instruct the host I just can't find the correct setting. Currently defined as:
    <xa-datasource-property name="ServerName">//LNNOIS.\\\\SQLEXPRESS</xa-datasource-property>
    Since I have been though this pain before I am certain the server is accepting connections and there are no firewall issues. the tcp/ip port for the sql server is set to 1433. I will persevere!
Reply
  • its all about the connection, that's for sure.
    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host //LNNOIS009., port 1433 ha
    s failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host an
    d accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
    I am certain it is how you instruct the host I just can't find the correct setting. Currently defined as:
    <xa-datasource-property name="ServerName">//LNNOIS.\\\\SQLEXPRESS</xa-datasource-property>
    Since I have been though this pain before I am certain the server is accepting connections and there are no firewall issues. the tcp/ip port for the sql server is set to 1433. I will persevere!
Children
No Data