View Single Post
Old 03-22-2010, 12:58 PM  
cyco_cc
Confirmed User
 
cyco_cc's Avatar
 
Join Date: Oct 2008
Posts: 344
Quote:
Originally Posted by SpongeBub View Post
So I hooked up my new PC today running Windows 7. Overall, I like it but a pain in the ass is what all that security crap is. I run IIS, ASP, and SQL Server on there and getting all that shit to work under Windows 7 is next to impossible, at least so far. I could have set all of this stuff up on an XP box in about 15 minutes and after working on it all day, I'm still not done. I keep getting a message when my ASP code tries to make an ADO connection to the database using Windows Authentication that says "Login failed for user 'NT AUTHORITY\IUSR". I have the IUSR login setup and have given it access to the tables in my SQL database but no, it still won't let me in. And I need to have this shit up and running by tomorrow morning to start processing orders again. Goddamn Windows 7.

If anyone can help, please jump in and tell me what I'm doing wrong.
I run Windows 7, SQL Server 2008, etc. and it was pretty quick to setup. Did you run the following against the DB:
sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE' or IUSR if that's what you're using?
cyco_cc is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote