I have a web site someone setup using asp. it is trying to connect to my SQL 2005 server. i know next to nothing about SQL 2005 and asp, but so far i got the web page up, ( it's on a windows 2003 server running IIS6 with aspnet 2 ). the person that made this stie is no longer with the company and i can't contact him. he made a login link on the site , and i found the login name and password by going to the SQL 2005 server and opening the user's table. however, when i open the website through IIS manager, and click the login link, then put in my user name and password i get this error
"login failed for user 'USER\DOMAINNAME$' ( i changed the user name and domain name to the generic names you see here)
I found on google something about messing with the web.config file, and i tried that, but due to my lack of knowledge, i only managed a new error
"login failed for user ". The user is not associated with a trusted SQL server connection.
that was when i changed integrated security=false from true in the web.config. i want to use windows security, not sql. any ideas?