Re: can no longer add new logins

From: Jobi (jobi_at_reply2.group)
Date: 05/23/03

  • Next message: Andy Sjostrom: "Login failed for user" 
    Date: Fri, 23 May 2003 11:47:09 +0200

    What happens when you use checkpoint ?

    jobi
    "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
    message news:uyZftTPIDHA.1024@TK2MSFTNGP10.phx.gbl...
    > 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
    >
    >

  • Next message: Andy Sjostrom: "Login failed for user"

    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: Cross database granting
      ... Just create a user in the master database for your login and then grant EXEC ... Tibor Karaszi, SQL Server MVP ... > Chris Buys ...
      (microsoft.public.sqlserver.programming)
    • Re: Mismatch between sysaltfiles and sysaltfiles
      ... It sound a bit scary to me, so I'd open a case with MS support to make sure that ... Tibor Karaszi, SQL Server MVP ... > sysaltfiles table in the master database for a datafile ...
      (microsoft.public.sqlserver.server)
    • Re: Tool for view transaction log
      ... >> Who knows other way or tool to see the transaction log ... >Dbid or dbname - Enter either the dbid or the name of the ... >4 - full information about each operation plus ... >To view the transaction log for the master database, ...
      (microsoft.public.sqlserver.tools)
    • Re: Transfer Server Login
      ... Yes,You can take a backup of master database and restore it in destination. ... > I am under the impression that the Server Login IDs are in the Master ... I could be wrong about all the Server Logins are under Master ...
      (microsoft.public.sqlserver.setup)
    Loading