Re: Trusted SQL Server connection (SQL 2005)

To be able to login to SQL Server using a Windows account, then a login must be created in SQL Server Security\Login for that account or for a Windows group which consists that Windows account.

I think you better create Windows groups for your users. Create login for the Windows group who you want them to be able to login to your SQL Server and assign them necessary permissions for your database objects or whatever. It's usually a better way to create logins for groups rather than individual users. It's easier to manage groups.

You may want to have a look at the following site to learn more about creating logins in SQL Server 2005:
http://msdn2.microsoft.com/en-us/library/ms189751.aspx


--
Ekrem Önsoy



"idoek" <idoek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EC723436-1815-4041-812A-769D280F6507@xxxxxxxxxxxxxxxx
Thank you for your answer!

At first I thought your answer is correct, but then I logged into a Windows
machine where I know the administrator cannot access the local SQL Server
2005 using Windows Authentication.

(When I try to login to the SQL Server 2005 I get the following error:
"Login failed for user ''. The user is not associated with a trusted SQL
Server connection. (.Net SqlClient Data Provider)")

When I login using 'sa' I see that the group BUILTIN\Administrators is
defined in the SQL Server and assign to a sysadmin role, but still I cannot
login to the SQL Server using the machine administrator and Windows
Authentication.

How come? And how can I replicate this situation on another machine?

Thanks.


.

Relevant Pages

  • Re: login 101..
    ... On Windows 2003, SQL Server 2005 can enforce the Windows password complexity ... Windows authentication - SQL Server uses a special protocol to ask ... user is in the list of allowed logins, ...
    (microsoft.public.sqlserver.security)
  • RE: How to create a trusted connection
    ... You need to grant access for the Windows login by referring to the books ... is set to use Windows authentication to be able to do trusted connection. ... There are two modes of authentication in SQL Server: ...
    (microsoft.public.sqlserver.security)
  • RE: How to create a trusted connection
    ... What do you mean by "creating a Windows login"? ... To login SQL Server 2000 using trusted connection, grant the Windows ... Group" in SQL Server Books Online to get the concept, ...
    (microsoft.public.sqlserver.security)
  • Re: Connecting to SQL from a Windows Service
    ... There is probably some way to debug this, but that's deeper Windows knowledge than I can dredge up right now. ... I looked into the Event Log and found that when my service ... 1st Login succeeds. ... You can try turning on login auditing in SQL Server and then check the ...
    (microsoft.public.sqlserver.connect)
  • Re: domain groups not visible
    ... be sure your SQL Server server is a part of the Domain. ... And when you click New Login and then Search to find the group that you create on AD check out the Object Types from the "Select User or Group" window to be sure that Groups are included in your search. ... Then create a login in SQL Server for that Windows Group. ...
    (microsoft.public.sqlserver.security)