This is my first time working with mssql. I need to connect to a remote db. I'm able to do so using Toad for SQL Server with the ODBC driver on windows. Now I need to have a couple of mssql queries on my php code. I've been trying to connect to the db using some sample scripts that I found online, but although I don't get an error I don't get a successful connection. I had forgotten to edit my php.ini and enable the mssql extension, now I get an error because I can't connect to the server, I guess it's because I don't have the right ServerName/ServerInstance.
I understand that I need the ServerName or the ServerInstance, but how do I get it? (I'm using the same ServerName I use on Toad, but it isn't working)
Any suggestions? Anything that I'm doing wrong?