Hi, We have an issue where kerberos authentication was enabled on a server which is on Domain A. Now, since then, users have complained that from their App servers on Domain B, they haven't been able to connect to SQL Server if they set Integrated Security to True. They get the error message: ( System.Data.SqlClient.SqlException : Cannot generate SSPI context.) They are able to connect using a SQL UID and Pwd in the connection string. Can anyone suggest what seems to be the issue and how to correct it ?
Can I clarify a few things. Are you saying that SQL Server authentication works but Windows Authentication does not? Do you have an active directory with at least two domains, are the domains trusted?. How are uses in one domain granted rights in the second? Also when you say have enabled kerberos do you mean you have created Windows authentication logins in SQL Server in domain A or have you specifically switched on kerberos in the domain?