Ok I can do ADO with vbscript and SQL Server piece of cake
I'm still kinda new to the whole ASP thing though.
My desire if its possible
Note: This is on a domain, so I can use Windows Integrated security with IIS.
Now my desire
I want to carry the integrated security from the webserver to the database server (also in the domain)
So user domainname\username can get access to xyz.asp because he's in group domainname\ASPAccess
I want to be able to give group domainname\ASPAccess access to the specific sql server tables.
I've tried it with a integrated security connection string, but that only gets me the user credentials for the anonymous user
I can write it with passing the DB server a userid/pass and that does work... but that isn't as tight of security as I would like (not a big fan of having username/pass in filesystem)
Ideas?
hardware
prices 
