Authentication Mode

From: Mauro (Mauro_at_discussions.microsoft.com)
Date: 04/26/05 

Date: Tue, 26 Apr 2005 08:29:02 -0700

If I have a server with windows only authentication mode, How can I login
in Sql Server 2000 using SA or GUEST account? It is possible?

Relevant Pages

  • Re: OK - Im stupid....How do you create a user?
    ... not a Windows login, you'll need to change the authentication mode SQL ... Server uses from "Windows Authentication" to "SQL Server and Windows ... Windows authentication mode if at all possible. ...
    (microsoft.public.sqlserver.security)
  • Re: losing sysadmin
    ... >login as SA. ... >> 1)My SQL Server is in Mixed Authentication Mode. ... >> 4)Now I changed the Mixed Authentication Mode to Windows ... >> now I don't have a sysadmin role. ...
    (microsoft.public.sqlserver.security)
  • Re: losing sysadmin (Thanks)
    ... >login as SA. ... >> 1)My SQL Server is in Mixed Authentication Mode. ... >> 4)Now I changed the Mixed Authentication Mode to Windows ... >> now I don't have a sysadmin role. ...
    (microsoft.public.sqlserver.security)
  • Re: "Login failed for user (null) reason: not associated...
    ... You'd want to consider using DSN-less connections in your ... Then the DSN or login prompts are not the issue ... authentication mode and somewhat on your application. ... connect to SQL Server, ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)