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
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
KBAhttp://support.microsoft.com/kb/319723 fyi on authentication, general recommendation is to use Windows authentication for security purpose. Refer to kBAhttp://support.microsoft.com/kb/889615 &http://support.microsoft.com/kb/265808 for named instance about that error in resolving. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
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.
]]>