Jump to content

Recommended Posts

I have having trouble connecting to a MSSQL server. I am trying to connect from a test box. I can ping the MSSQL server from my test box but can't connect. How do I figure out why its not connecting? I copied the exact code from my production box so I know the username and password is correct. Is there someway to get some more details?

 

Thanks for the help.

 

 

 

Link to comment
https://forums.phpfreaks.com/topic/73381-mssql_connect-not-connecting/
Share on other sites

More info on the problem.

 

 

There are 5 different servers involved

Production web server / SQL server (virtual box)

Old production web server (to be decommissioned)

Test web server / Mysql server

1 SQL server

 

 

From the production box I can connect to the MySQL database and both MSSQL databases. From the old production box I can also connect to the MySQL and both MsSQL databases. But from the test box I can only connect to the MySQL server on its self.

 

If I look at the log from my router/firewall that is between the test server and everything else I don't even see an attempt to connect. However when I use SQL Server Management Studio Express I do see the connection being established. Which leads me to believe that I am missing something in the configuration of my test server but I don't know what.

 

Thanks again for the help

 

 

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.