unable to connect with mssql_connect()

[aryan2cool]

hii all

i am using php 5 and a warning has occured in my application

"
Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'PAYDATA'. (severity 14) in C:\WINNT\Temp\t mpqjqokj.php on line 7

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 10.23.80.6 in C:\WINNT\Temp\t mpqjqokj.php on line 7"


any suggestions??

regards

Aryan

[ak1dnar]

Check the user name and password again.

Thread title [login failed...need help] changed. Do not use "need help" with your thread titles.

[webandwe]

I found that usally the DB or the server host is incorrect.

Find out from your hosting company what the details must be?

Example of DB

1.yourdomain_co m_-_yourdb
2.yourdb

And your serverhost

1.localhost
2 292.282.29
3. nk1.222.ns.host

Hope you come right.

Regards

[aryan2cool]

thank you guys.. that problem is solved. but now i am getting a new warning in different link...


Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'CRB'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in C:\WINNT\Temp\t mpuaobbb.php on line 155


Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: HARDWARE in C:\WINNT\Temp\t mpuaobbb.php on line 155
Unable to make connection with server HARDWARE

mssql.secure_co nnection is off in ini file....


any ideas???


regards
aryan

[ak1dnar]

The default way to connect to MSSQL Server with user names and passwords, but the mssql extension can be configured to use secure/trusted
connections. So you have to set mssql.secure_co nnection = On in
php.ini. and restart the machine before execute the script. Thanks!