One of our user from another domain
WATSON received the following error message:
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'WATSON\User1'.
when he is trying to access one of our web application that retrieve information from a database.
The web application and the database that the web application use is located in a Windows Server 2008 R2. The machine name is
Jack11 and has join the domain
WATSON. The web application is hosted in the IIS wile the database is hosted in the SQL Server 2008 Enterprise.
Do I need to setup my SQL Server 2008 Enterprise in order to allow domain user such as in this case
WATSON\User1 (not local user) to access web application that uses any of the database inside the SQL Server 2008?
(Kindly note that there might be more than 50 domain users that may required to access the web application and therefore it would be inefficient to add each domain user to the database's user rights)