Connect to MS SQL Server with user/password [Resolved]

[ober0330]

Ok, this might just drive me over the edge.

I have SQL Server 2000 and I'm trying to connect to it. I have several databases setup and I've been using PHP/HTML as my front end to the server. So far, I've only been able to use the server default "sa" as the user, with a blank password. No matter how I create logins or roles, I cannot create a user with a password that will give me access to the databases on that server.

SO I figured I must be doing something wrong so I fired up VB, created an ADO connection string and VOILA! It connects with the user/password combo and off we go.

So I go back to my php pages and try to get a connection. NOTHING.

How do I create a user that php will use to interact with the SQL Server? I can get the default to work, but not any other created user?!

[ober0330]

I always get the answer right after I post all over the net.

Anyways, it involved setting up a new role and then applying that role to a user.