active directory / single sign on / windows authen | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

active directory / single sign on / windows authen

Requirements say that we have to use active directory with single sign on.
Now, I don’t know much about this, but they installed an sql server 2005 for us, and i have problems connecting to it. I always get the error
– the users is not associated with a trusted SQL server connection. Now, if found on the internet to change authentication mode of the database to "SQL Server and Windows". If I do that, will that affect the above requirement?
If you don’t have your WINDWOS login in SQL server or a group which you are a member you can’t logon to sql server.
SQL Server manages its own security… MohammedU.
Moderator All postings are provided “AS IS” with no warranties for accuracy.

KBA fyi on authentication, general recommendation is to use Windows authentication for security purpose. Refer to kBA & for named instance about that error in resolving. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.