Cannot open database Properties window

I'm trying to open the master database Properties window when running SSMS as
a local user (Run as) which I have only created a sql server login for it. I
get the error below. If I add the sql server login as a user to the master
database and assign any database role membership except db_owner to that
user, I still encounter the same error or other permission error.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

------------------------------

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

User 'guest' does not have permission to run DBCC showfilestats for database
'master'. (Microsoft SQL Server, Error: 7983)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=7983&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

.

Relevant Pages

  • Re: unable to start SQL Service ... error code 3417
    ... How about just create a new instance and restore databases to the new instance? ... I wouldn't go with restoring master from another instance. ... The supported route is to rebuild your master database, start SQL Server in single user mode, ...
    (microsoft.public.sqlserver.server)
  • Re: FK Relation
    ... >Yes the detail table has cascading delete too(at database level). ... >I use to connect ADO and OLEDB provider for sql server. ... Do you have any triggers on the Master table that update the master based on ... Borland's ADO components use all the fields in the record's selected fields to ...
    (borland.public.delphi.database.ado)
  • New Login Question
    ... I have been programming with Sql Server 2000 for 2-3 years ... I noticed that at the bottom of the New login dialog there ... One selects a database to log in to ... dropdown always has master listed. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Disaster Recovery
    ... You can start sql server without the master database as follows. ... start SQL Server in single user mode to restore the master database. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 not using locally cached credentials in a certain situati
    ... permissions to the database objects. ... may be a user mapper to an SQL Server login. ...
    (microsoft.public.sqlserver.security)