MS SQL database connection

Ignition
1

Hi
Our IT dept are in the process of moving our local MSSQL db from localhost to a clustered server but we’re having difficulty connecting to the new db.

They’ve issued the location as “sql.CompanyName.com,1435” and my question is how do we translate this into the normal connection path?
Thanks. :frowning:

2

I would think it would look something like this

jdbc:sqlserver://sql.CompanyName.com\MSSQLSERVER:1435

assuming that the database instance is set to mssqlserver and that the sql.companyname.com is a legit host name on you rnetwork.

I would try and ping sql.companyname.com and see if you see good pings or if it even give you a ip address

3

Thanks for the reply diat150.
I tried your suggestions and I could ping sql.companyname.com OK but still couldn’t connect. It turns out our IT dept hadn’t configured the db correctly.

Once they’d corrected the issues, it finally connected OK.