Skip to main content
bmehringer1-Visitor
1-Visitor
Aug 13, 2018 7:52 PM UTC
Question

MS SQL Server Connection Issue

I have created some applications that are connecting to MS SQL Server databases using the Extension from the TW Marketplace.  I am using these applications in two different environments that actually connect to the same database server.  For whatever reason, there are times when I have to specify the MS SQL Server TCP port number, and times I don't.  All TW servers are on the same network, so I'm not sure why one would work differently than another.

 

Has anyone seen this before?  Any idea why the port number is needed and sometimes it's not?

2 replies

CRArko5-Regular Member
5-Regular Member
Aug 15, 2018 8:24 PM UTC

Hello,

 

Is there a load balancer or some similar piece of network hardware between the application server(s) and the database server?

 

Thanks,

 

-- Craig A.

Translate
bmehringer1-VisitorAuthor
1-Visitor
Aug 17, 2018 12:12 PM UTC

I'm not sure about a load balancer, but I know there are several managed switches between the application server and the database server.  I guess this question is really related to using JDBC connections to MS SQL Server.  I just find it odd that sometimes a port number is needed and sometimes it is not.  I'm wondering if it has to do something with name resolution coming from the application server...

 

I may take this question to other forums as it doesn't really seem related to TW.  I appreciate the help.

Translate
Terms & ConditionsAccessibility statement