Re: Authentication Mode

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 04/26/05 

Date: Tue, 26 Apr 2005 17:33:34 +0200

no way, only if you switch oveer the authentication mode via the registry.

HTH, Jens Suessmeyer. 

---
http://www.sqlserver2005.de
---
"Mauro" <Mauro@discussions.microsoft.com> schrieb im Newsbeitrag 
news:F09557A1-921C-4887-8643-CDC7FC0DDEBB@microsoft.com...
> 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: security
    ... using Windows Authentication. ... SQL Server has two authentication mode: ... Server however he need to be assigned more sql server permissions to ...
    (microsoft.public.sqlserver.setup)
  • RE: How to access SQL Server from a non-privileged domain account
    ... account to be able to access the SQL Server. ... Since your SQL Server 2005 has been running with Windows Authentication ... Contact your network administrator to add your domain account to the ... Change your SQL Server 2005 authentication mode to Mix mode so that you ...
    (microsoft.public.sqlserver.setup)
  • RE: security
    ... SQL Server has two authentication mode: ... Mixed Authentication mode. ... administrator permission. ... Server however he need to be assigned more sql server permissions to ...
    (microsoft.public.sqlserver.setup)
  • Re: losing sysadmin
    ... You can edit the registry key (This key will vary slightly for a default ... > 1)My SQL Server is in Mixed Authentication Mode. ... > 4)Now I changed the Mixed Authentication Mode to Windows ...
    (microsoft.public.sqlserver.security)
  • Re: Questions about SQL on SBS Premium
    ... Changing the authentication from Windows to Mixed mode will not ... Just make sure you secure this SQL Server ... The authentication mode needs to be set to mixed mode (it is currently ...
    (microsoft.public.windows.server.sbs)