WampServer

I am running Wampserver on Windows XP. When I connect to the MS SQL server using Windows Authenticaion, I keep getting login failed errors as described in the subject.

I've tried so many things, using different extensions, modifying php.ini settings, banging my head on my desk... when I stumbled onto this article:

[social.msdn.microsoft.com]

Robert Johnson stated that you want to login with Windows credentials... this set on a light bulb in my head! I needed to run wampserver as myself. Because it was a system process, it was running it as my computer-name, and not my username.

If this is the same problem you are encountering, to fix this, follow these steps:

start->run-> services.msc
find "wampapache"
right click -> properties
[tab] logon
select "this account"
enter username, something like domain\username
and enter password
click apply

there was a prompt that i got, but i was unable to reproduce it.

to see if it worked, run your script and see if it works!!

it worked for me.

If this helps you, please leave a response!!