Home Forums SQL Server 2005 Administering Help ! Can't login, SELECT permission denied ....... RE: Help ! Can't login, SELECT permission denied .......

  • Why not sys.configurations?

    Proper qualifier would be database.schema.objectname.

    Run dbcc checkdb. If ok, check the log file, if someone dropped permissions. "public" must have select permission on this system view.