RE: allowing anyone into SQL Server 2000

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 05/27/04 

Date: Wed, 26 May 2004 22:53:56 GMT

Login to the server as 'sa'.

sp_grantlogin 'DEMOPC-25\gbrown'
go

Change databases to your database
use mydatabase
go

sp_grantdbaccess 'DEMOPC-25\gbrown'

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • RE: Connection Timeout
    ... Check with the person responsible for Active Directory. ... Kevin McDonnell ... Microsoft Corporation ... This posting is provided AS IS with no warranties, ...
    (microsoft.public.sqlserver.connect)
  • RE: SQL Agent Proxy Account
    ... SQL Server or Drivers? ... Kevin McDonnell ... Microsoft Corporation ... This posting is provided AS IS with no warranties, ...
    (microsoft.public.sqlserver.security)
  • RE: Deadlocks
    ... 118552 INFO: Handling Deadlock Conditions ... Kevin McDonnell ... Microsoft Corporation ... This posting is provided AS IS with no warranties, ...
    (microsoft.public.sqlserver.security)
  • RE: Problems with SQL Installation when certificate is installed
    ... Use the Client Network Utility and Disable or Uncheck Shared Memory. ... Kevin McDonnell ... Microsoft Corporation ... This posting is provided AS IS with no warranties, ...
    (microsoft.public.sqlserver.security)
  • Re: MBSA 1.2 and slammer
    ... which contains the Slammer patch. ... Kevin McDonnell ... Microsoft Corporation ... This posting is provided AS IS with no warranties, ...
    (microsoft.public.sqlserver.security)