Connect to MSSQL with PHP (Linux)

Question

Debian 7 x64, MSSQL 2008

Installed:

PHP 5.4.36-0
FreeTSD 0.91
unixodbc

If I connect with:

tsql -S server_name -U user_name -P password -D db_name

all is ok, but if I try to connect via php:

mssql_connect('server_name', 'user_name', 'password')

it always says

Login failed for user 'user_name'. (severity 14)

Can anyone help me with this? Thanks.

update: Found a solution: make the password shorter and everything was fine. Old password contains 32 characters.

Mark · Accepted Answer · 2015-01-11 12:48:52Z

1

Did you check this?

"To increase security, the error message that is returned to the client deliberately hides the nature of the authentication error. However, in the SQL Server error log, a corresponding error contains an error state that maps to an authentication failure condition. Compare the error state to the following list to determine the reason for the login failure."

answered Jan 11, 2015 at 12:48

Mark

7043 gold badges9 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Wend Over a year ago

Login failed for user 'user_name'. Reason: Password did not match that for the login provided.

Wend Over a year ago

Found a solution: make the password shorter and everything was fine. Old password contains 32 characters.

Mark Over a year ago

well, glad to help (:

Collectives™ on Stack Overflow

Connect to MSSQL with PHP (Linux)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related