Link to home
Start Free TrialLog in
Avatar of Lynn Thames
Lynn ThamesFlag for United States of America

asked on

Remote connection to SQL Server with multiple instances installed

Hi, I have a ecommerce sync utility that I installed for a client.  The utility is written in PHP and connects to his MS SQL 2008 R2 remotely using mssql extensions for php and freetds.

A few weeks ago they moved to a new sql server, changed the instance name, username, and password.

Now, I cannot get a connection.  

Tests from SSH confirm that the IP address/port is open.

The error returned is Login Failed for user 'user',  but we have confirmed several times that I am using the right user/password combination.

I have instructions that they used to set up the connection initially (what settings to use in sql server configuration manager).  They've sent me screenshots of these and they look right.

My question is this . . . .   if they have several instances installed on one SQL Server, how does the server know which instance I am trying to connect to?

Thanks for any help you can give!
ASKER CERTIFIED SOLUTION
Avatar of Carl Tawn
Carl Tawn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Lynn Thames

ASKER

I am using php and freetds for the remote connection (this is on linux) and you don't specify a servername or instance name.

You only specify an ip address and port number.
As long as you are using the correct port number for the specific instance it should be connecting to the right instance.  Did they give you a port number other than 1433?  

Are they able to log on with SSMS using the credentials you have?
Actually, he realized port 1433 is pointing to a different instance.  He is going to change it after hours and see if that fixes it.