Users, logins, users and more users

Hi, I am still pretty new to sql server, windows server, asp, etc etc. In summary I am uber noob and here is my current realm of confusion: -

Users:

I am going round in circles trying to decipher the numerous levels of user and logins there are between:

- login for windows webserver as internet user (2003 in my case)
- user account used for IIS
- SQL Server logins
- SQL Server database users

I am getting myself completely confused between all these and was wondering if anyone could explain the process (in simpletons terms) from start to finish or give me some useful resources. Here is my scenario: -

I have a win2003 box which I am running as a web server.

a simple SQL server database.

a simple asp site to connect to the db and retrieve certain data.

The frustrating points are:

I have a similar development setup running locally (winXP pro box instead of 2003) which runs fine and everything works great. So I am confident the asp and db are set up ok.

I have an existing different sql server db/asp site setup on the web server which is also running fine (although I am not confident in the security setup as I think I got this working more through luck/ trial & error than educated judgement). So I am confident the connection string is OK.

As I've hinted my confusion is concerned with the setup of users/logins/permissions across windows/IIS/sql Server.

If anyone can point me in the right direction towards getting my head around this i'd be extrememly grateful

Cheers,
Dan

I'm confused...are you wanting to know the differences between them and how they would affect the application?

Yes,

Basically I am having problems setting up access to my sql database from asp pages.

I am struggling to get my head around the setup of, differences and relationships between the sql database users and logins, the IIS IUSR account and windows authentication.

All I want to be able to do is allow the asp to query the database.

currently am getting the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

/a2z/news_functions.asp, line 49

thanks

Setup up a user in sql server, give that user rights to the database you want them to use.
Then in your database connection string within your asp application use that users username and password to connect to the database.