Skip to main content
B
billyb10790207
Participating Frequently
June 6, 2016
Question

CF 11 SQL Server Connctions

  • June 6, 2016
  • 2 replies
  • 1251 views

Hi,

I'm running a CF 11 multi-server setup on a Server 2012 R2 box with multiple websites that have their own IP addresses (multiple IP's).  Even though each site has it's own IP address, I see all CF 11 instances using the same IP address to connect to Microsoft SQL server.  Why is CF 11 behaving this way and is this configurable?

Thank you,

Billy

This topic has been closed for replies.

2 replies

EddieLotter
EddieLotter
Inspiring
June 16, 2016

billyb10790207 wrote:

Hi,

I'm running a CF 11 multi-server setup on a Server 2012 R2 box with multiple websites that have their own IP addresses (multiple IP's). Even though each site has it's own IP address, I see all CF 11 instances using the same IP address to connect to Microsoft SQL server. Why is CF 11 behaving this way and is this configurable?

Thank you,

Billy

It's not clear, to me, where you are looking and seeing the IP address you are talking about. Are you using the SQL Server Management Studio to see which IP addresses are making connections to the SQL Server process?

Cheers

Eddie

B
billyb10790207Author
Participating Frequently
June 16, 2016

I can see the IP address in SQL Management studio.  You can also see the connections by running the "netstat -an" command from a command prompt.  My main question is why does Coldfusion not use the default IP address on the server to make outgoing connections?  It seems like its just picking one of my other IP address that I've got assigned to specific IIS web sites.  It just so happens that it was using a IP address that we didn't need assigned on the server anymore, so I removed that IP address, restarted all the coldfusion services, and it used the next higher IP address.

EddieLotter
EddieLotter
Inspiring
June 16, 2016

I'm guessing it is using whatever IP address that DNS returns.

If you use ping or tracert (on the server that hosts the CF process) with the fully qualified server name (e.g. CfServer.ou.o, in other words, the directory services name, not the Web address) what IP address is displayed?

Cheers

Eddie

Charlie Arehart
Community Expert
Charlie ArehartCommunity Expert
Community Expert
June 6, 2016

Billy, can you clarify if you understand that the connection to SQLServer from CF is defined in the CF Admin and its Datasources page? That’s where it’s configurable.

Or is there some ongoing confusion?

/charlie

/Charlie (troubleshooter, carehart. org)
B
billyb10790207Author
Participating Frequently
June 6, 2016

Yes Sir.  Each CF instance has a data source that points to the same database server, but separate databases.  It's really weird because it's not even using the default IP address of the server when the connections are made to the databases.

C
carl type3
Legend
June 6, 2016

Hi Billy,

I guess it would be CF Java component making the JDBC or ODBC database connection, not the tomcat component that get's bound to your webserver sites. So I guess however Java is network binding is going to determine what TCP address the database connections are coming from.

HTH, Carl.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices