Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
15 replies
Subscribers
7 subscribers
Views
3994 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
Is anyone out there using microsoft sql express 2005 with an appian installation
james.franklin
over 11 years ago
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
0
james.franklin
over 11 years ago
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!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
james.franklin
over 11 years ago
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!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data