"Phil Dodgson" <harq@nospam.com> wrote in message
news:ee219b3468724f7a83956e943de660bf@ureader.com...
> Hi,
>
> I have just installed SQL Server 2005 and I'm having trouble setting up
> logins, the scenario that I have is I have a number of .php pages on an
> IIS
> Version 6 server and when you click a button, it creates a database
> connection and inserts data into a table. I used Web as a Username and
> Password as Password just for this example. I have then gone to the
> Security Tab in SQL Server 2005 and set up a User called Web with all
> Privs.
> and data base owner of NAI which is the database that I am trying to
> insert
> into, this then creates a login in this database.
>
> When I run the web page I just keep getting the error
>
> Login failed for user 'Web'. The user is not associated with a trusted SQL
> Server connection. (severity 14)
>
> If I try and connect direct to the database using the same connection
> details I get a "No process is on the other end of the pipe." I have
> checked
> and I have TCP/IP and Names pipes enabled which is what most web sites
> seem
> to tell me.
>
> Can someone point me in the direction of what I am doing wrong as I had
> this
> set up and working on SQL Server 2000 with no problems.
>
> Thanks P