Re: can no longer add new logins

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 05/23/03 

Date: Fri, 23 May 2003 08:31:13 +0200

Seems like the transaction log of the Master database is not available -
check if there is anything wrong with the mastlog.ldf file. Check the disk
as well. Then restore the master database from the last valid backup. 

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Billie" <bedson@siumed.edu> wrote in message
news:065901c320b2$86dcca30$a101280a@phx.gbl...
> I have Security Administrator privileges on our SQL 7.0
> Server, and all of a sudden I can't add new logins. First
> I get the message "9001 Fatal Error". When I try it again,
> I get the basic "You must be logged in as 'sa' or a member
> of sysadmin or a member of securityadmin to perform this
> operation.
>
> When our System Administrator tries to add a new login,
> she first gets "9001 The log for database <name of db> is
> not available. When she tries again, she gets the "You
> must be logged in as 'sa', etc.
>
> Any thoughts on why we can't add new logins even though we
> have adequate privileges?
>
> Thanks,
> Billie

Relevant Pages

  • Re: can no longer add new logins
    ... > Seems like the transaction log of the Master database is not available - ... Then restore the master database from the last valid backup. ... > Dejan Sarka, SQL Server MVP ... and all of a sudden I can't add new logins. ...
    (microsoft.public.sqlserver.security)
  • Re: question about syslogins and sysusers...
    ... In SQL Server, logins are different from users. ... database that the login must access. ... there is a view in master database, and a sysusers table in each database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Scripting in Windows 2000 Advanced Server
    ... "mssqlserver service which is clustered". ... used them in a script to determine if a service is running. ... to attempt to connect to the master database in the default instance of SQL ... ' Cannot start SQL Server - ignore error. ...
    (microsoft.public.windows.server.scripting)
  • Re: Scripting in Windows 2000 Advanced Server
    ... "mssqlserver service which is clustered". ... to attempt to connect to the master database in the default instance of SQL ... ' Cannot start SQL Server - ignore error. ... ' Connection string for SQL Server Master database ...
    (microsoft.public.windows.server.scripting)
  • Re: unable to start SQL Service ... error code 3417
    ... If the Master database is corrupt, how would you advise I maybe replace with ... "SQL Server cannot start the master database. ... MVP - Windows Live Platform ...
    (microsoft.public.sqlserver.server)