I have seen many articles on this subject, but have yet to resolve the issue. I have IIS on one server and SQL Server 2005 on a second server. Both are stand alone servers and not part of a domain. The SQL Server is sitting behind a firewall with the proper 1433 port being opened. With the firewall set...

Bound by timescales, and wanting to password protected one directory on our website I setup the website to allow Anonymous access and Windows Authentication. I then created a Windows User and gave them file permissions to the folder I wanted to restrict and removed the IIS User. This all worked fine...