web stats
Error: Unable to establish loopback connection. - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2015, 01:03 AM
PaulLancaster PaulLancaster is offline
Mirth Newb
 
Join Date: Aug 2014
Posts: 17
PaulLancaster is on a distinguished road
Default Error: Unable to establish loopback connection.

Hi all,

Occasionally I get this error in Javascript when connecting to an SQL 2012 clustered server:

Wrapped com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host <server cluster name>, port 1433 has failed. Error: "Unable to establish loopback connection. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

The line that it errors on is simply:

var dbConn = DatabaseConnectionFactory.createDatabaseConnection (driver, address);

driver is com.microsoft.sqlserver.jdbc.SQLServerDriver
address is jdbc:sqlserver://<server cluster name>;databaseName=<database>;MultiSubnetFailover= true;selectMethod=cursor;user=<username>;password= <password>;

I've found all sorts about Firewall rules and SQL Client Connection settings but what perplexes me about those is that if they were at fault, surely the error would be more than intermittent?

The end result of the error is to - most times - crash the server (for want of a better description); Administrator won't close/open and the mcservice won't shut down. The only way to fix the problem is to restart the server itself.

Does anyone have even an inkling of an idea?

Thanks,
Paul
Reply With Quote
  #2  
Old 08-11-2015, 11:07 PM
flyerman flyerman is offline
OBX.2 Kenobi
 
Join Date: May 2015
Posts: 68
flyerman is on a distinguished road
Default

just sharing the code used in my system for MSSQL 2008 are

// MYSQL Database Configuration
//var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('com.mysql.jdbc.Driver','jdbc:mysql://123.4.5.678:9999/Prodb',' userName ' ,'passWord');

// MSSQL Database Configuration
var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('net.sourceforge.jtds.jdbc.Driver','jdbc:jtds:sql server://123.4.5.678:9999/Prodb','userName','passWord');
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 12:14 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation