knowram Posted October 15, 2007 Share Posted October 15, 2007 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. Quote Link to comment Share on other sites More sharing options...
knowram Posted October 19, 2007 Author Share Posted October 19, 2007 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.