SQL Login

From: Sanka (loonysan_at_mailcity.com)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 00:32:14 -0700

Hi,

User X is a machine administartor in the SQL Server box.
By Default, when User X logs in the machine, he is not
able to access any of the DTS packages / access tables
present in the Databases.

Guess the User X ID has to be added in the SQL Server as
well. Is it possible for User X to login in the machine
and add himself as the Administrator of the SQL Server
without knowing the "SA" Password or with no help from the
other SQL Server Administrators.

Regards,
Sanka

Relevant Pages

  • Re: Checkpointing Not Happening in Simple Recovery Model
    ... Regards, ... > She says that she has simple recovery and that one of them is tempdb. ... > Columnist, SQL Server Professional ... > Yes, you are right, I read that Michelle is writing about logs not log, is ...
    (microsoft.public.sqlserver.server)
  • Re: Size of SQL server logs
    ... You can do this in the SQL Server Enterprise Manager - right click the ... select properties & you'll find it under the Log File tab. ... Regards, ... Where or how can I set the max size on the server logs? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Login
    ... To add a login, a user must be a member of the sysadmin or securityadmin ... Dejan Sarka, SQL Server MVP ... > User X is a machine administartor in the SQL Server box. ...
    (microsoft.public.sqlserver.security)
  • Re: Error re-installing SQL Server 2005
    ... i actually was able to export the reg entries from my ... SQL Server Setup could not connect to the database service for server ... Refer to server error logs and setup logs for ... For details on how to view setup logs, ...
    (microsoft.public.sqlserver.setup)
  • Re: Cluster will not fail over.
    ... Could not recover the master database! ... If you intend to stay on SP3 (for SQL Server), you should at least apply the ... >> From SQL server logs ...
    (microsoft.public.sqlserver.clustering)