I want to connect the SQL Server with Windows authentication but
- Database is on a different server
- IIS(Application) is on a different server(Both on the same network/domain)
- Want to connect the database through windows authentication.
What configuration/settings I need to do to enable this? At present, When I log in through the application, I'm getting this error message
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."