Hai friends,

    I am Gowtham. I developped a project (web application) using asp.net and c#. My application is running successfully at my system. But remore users are unable to run my application. They are getting an error message "SqlServer Exception--Login failed for user domain\userid". I am using windows integrated authentication. In IIS I set the property windows integrated authentication.

    The problem is with sql server authentication. How can I make all remote users to access my application. Could you please help me.

Thanks and Regards
Gowtham sen.


Gowtham Sen

__________________
Gowtham Sen

Is IIS running on a different box than SQL (but part of the same Active Directory Forest)? If so, then in order to use Windows Authentication you need to allow the IIS box to impersonate users (it is a right that is granted to the computer account through Active Directory Users and Computers tool).

Setup a share on the SQL box (just for testing that users can access it). Allow Everybody read. Can the users access the share? If not then you may have other issues with AD and users

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com