PHP and SQL Server on IIS

[DougMcDonald]

Hi There,

I have recently installed PHP on an IIS server and this worked fine, I can get my php info etc to work with no problems but can't seem to connect to SQL server.

I am confident that the user I am using has appropriate permissions, and I seem to be able to to physically connect to the server but I'm getting chucked out based on username/password.

It is a domain based system and I am using "domain\username" for the username field. I wonder if this is the right syntax or not.

Has anyone else had any experience with this kind of thing? And pointers? I'm fairly sure it's either something totally fundamental or something really small that I'm missing.

Any help greatly appreciated

[aidanjt]

Which SQL server, and have you tried authenticating the user/passwd with a standalone client?

Also try using some sample code to dig out errors that's happening along the way.

[Splash]

Which SQL server are you using? When you installed SQL Server did you have to specify a sa password, and if so can you connect using this?

EDIT - dammit, beaten to the punch by aidanjt...

[DougMcDonald]

I'm using SQL server 2005. And don't have any issues with the user outside of PHP.

I have tried changing the username/password combo to my own windows uname/password as this would have sa rights and we tend to use windows authentication on our sql servers here so this should work...in theory!

[aidanjt]

According to the dev manual, you need to copy a library to use the MS SQL functions (or install the client on the php box). Have you done so?

[DougMcDonald]

I have yeah, got the ntwd..whateveritscalled.dll in place and calling the functions does not seem to be the issue.

The functions are recognised, but the errors appears with authentication.

I cannot connect to the database because: PHP Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'nmr1\phptest'. (severity 14) in D:\Web Sites\HAMSTA\dbtest.php on line 2

[DougMcDonald]

Ah ok, scratch that.

Have just managed to fix it.

Seems the problem was with 'mssql.secure_connection = Off' in the php ini.

Some people had suggested turn off to sort things out. Turns out it needs to be one.

That will teach me to read the ini description properly :S

"; Use NT authentication when connecting to the server"

[Splash]

I'm using SQL server 2005. And don't have any issues with the user outside of PHP.

I have tried changing the username/password combo to my own windows uname/password as this would have sa rights and we tend to use windows authentication on our sql servers here so this should work...in theory!

Does it work with the SQL server sa account though? You do know theory and practice are two widely different (and occasionally diamtrically opposite) poles, right?

EDIT - d'oh!

[DougMcDonald]

Looks like I had just disabled NT based authentication mode for the sql server access.

If it was trying to use sql server level access, this would explain why the login was failing. As I say, we use NT authentication on our sql servers