August 16, 2006 at 4:55 am
Hi all,
I got one db server, after applying a number of security policies, It doesn't allow some windows users to connect.
Whenever these users tried to connect, the above message occured with descriptions: "Login failed for user '(null)'. Reason: not associated with a trusted SQL Server connection."
Whether this is due to user-rights or else?
Thanks in advance!
August 16, 2006 at 8:41 am
If everythign was workign fine before you applied the Policies I'd imagine that you changed from Mixed-mode to Windows Authentication only, or perhaps the other way around, or you are not allowing connections either to or from your Server. HAve a look at The SQL Network Utility and see if you can't see what changes have been made.
Most of the times this is because on the Connection string is somewhat incorrect for the configuration. Or perhaps you SQL Server isn't able to talk to your Domain controller to authenticate if you are using integrated security.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply