Changing authentication mode...

From: Brandt Linkowski (blinkowski@hotmail.com)
Date: 10/29/02 

From: "Brandt Linkowski" <blinkowski@hotmail.com>
Date: Tue, 29 Oct 2002 12:11:21 -0800

I need to access SQL Server 2000 from Visual Studio.NET running on my
workstation. I am using the Server Explorer to browse tables and build
datasets. The machine running SQL Server and the other running VS.NET belong
to the same workgroup, however I don't have a domain set up. (Two computers,
why bother?)

When I try to set mixed security on SQL Server 2000, it gives me an error
that my SQL login is not a trusted connection. Now, here is what I did:
Set up a user in windows
Added that user to SQL Server
Gave that user sysadmin rights and rights to certain databases
Tried to change authentication to mixed using that login...

No dice. Not associated with a trusted SQL Server connection. EVERY windows
login I try fails, including the administrator for the machine which I gave
every permission I could. (I won't leave it that way.)

Am I missing something?

Vexed in Victoria

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: Windows NT user or group not found.
    ... out what SQL Server thinks the login name is vs. what Windows thinks the ... When the SQL Server collation and the Windows collation are different, ... The following example uses the Param2 parameter to get the SID from Windows ...
    (microsoft.public.sqlserver.connect)
  • 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)