It is possible that IIS and SQL Server can reside on
Seperate Machines and you can use Integrated Windows
Authentication to connect.
Ravikanth
-----Original Message-----
Is it possible for IIS and SQL server on Separate Machineswith integrated windows Authentication in ASP.NET?
The IIS and SQL server are on sepatated machines. I want
to use the Integrated Windows Authentication. In IIS I
enable NTLM. In web.config, I have <authentication
mode="Windows" /> <identity impersonate="true"/>. But
still failed. The IIS pass through account
domainname/IIScomputername$ to SQL Server. But in the IISor in the domain, it doesn't have the such account.
Then I search in Microsoft, found such article
http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/vbcon/html/vbtskAccessingSQLServerUsingMappedWindowsDo mainUser.asp . It said the SQL server should be running on
the same computer as IIS. But I also found another articlehttp://support.microsoft.com/default.aspx?scid=kb;EN-
US;176379. That's for asp. It said asp can do that. So I'mjust wondering is it possible also for ASP.NET?
robert
.