Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  ASP.NET  Using remote DB via windows auth from ASP.Net

Author  Topic  nzmike Starting Member 21 Posts Posted - 2009-02-08 : 23:19:06 Hi all, I'm a bit lost and I hope someone can help me... I have an ASP.Net 2 app running on one server on my network (non-domain based) and I want to connect to and use a SQL Server 2005 DB on another machine from the app. Problem is I want to use Windows Authentication not SQL Authentication and at the same time I want to use anonymous access from the web server (IIS6)... but I'm not sure what I need to do or even what to search for. (The googling I've done has given me articles that just confuse the cr*p out me!) The reason for this specific setup is that I am trying to replicate a problem in the product I work on where we have a client with an extremely locked down network where we can't use SQL authentication. So we want to do something like (I think) pass the machine account from the web server to the DB server via anonymous access (our app uses forms authentication) but this where I'm a bit lost... I'm no security expert so am sure what I need to do to get this working. I think I might need to use impersonation in the .Net app but so far I've not been able to get it working. If any of this makes sense I'd appreciate any ideas or suggestions anyone might have - as you can see I'm out of my depth on this one but I have to solve it ASAP!