March 1, 2013 at 1:12 am
we have a new application on to a server, which uses SQL 2008 ENT for its
User is unable to connect from the app server using login credentials
[Fri Mar 01 06:52:08 2013] [error] [client xx.2xx.xx.xxx] PHP Warning: mssql_connect(): Unable to connect to server: testsql in /na/testvol/eocs/int_consumer/database/live/mssql.php on line 8
But we are able to connect the databse through SSMS uing the same login and password.
Please help if any one faced this issue.
Many thanks,
March 1, 2013 at 2:52 am
Is there a firewall between the two servers?
March 1, 2013 at 3:35 am
bala2 (3/1/2013)
But we are able to connect the databse through SSMS uing the same login and password.
have you tried this on same machine(server) or from other machine(sql client) too ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 1, 2013 at 3:45 am
what u can do first check port using telnet ,firewall.
if all ok then i think use hostname in connection string also make entry in host file .this will work.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply