Sunday, February 19, 2012

Cannot show requested dialog

Hi,
when i try to see the properties of database "sales" (sql server express
2005) in Management Studio Express, i get this error message: (besides,
when i try to expand the database, i get the error that it's emty)
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
--
The server principal "SRV754\admin" is not able to access the database
"sales" under the current security context. (Microsoft SQL Server, Error:
916)
But the webapplication still runs: i can insert records, update, delete ...
from asp.net.
Any way to recover it?
Thanks
DavidTake a look at the following KB David,
http://support.microsoft.com/kb/913422
Ekrem nsoy
"David" <no@.spam.rt> wrote in message
news:%23vPLrBDQIHA.2208@.TK2MSFTNGP06.phx.gbl...
> Hi,
> when i try to see the properties of database "sales" (sql server express
> 2005) in Management Studio Express, i get this error message: (besides,
> when i try to expand the database, i get the error that it's emty)
> Cannot show requested dialog.
> ADDITIONAL INFORMATION:
> Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.Express.ConnectionInfo)
> --
> The server principal "SRV754\admin" is not able to access the database
> "sales" under the current security context. (Microsoft SQL Server, Error:
> 916)
> But the webapplication still runs: i can insert records, update, delete
> ... from asp.net.
> Any way to recover it?
> Thanks
> David
>

No comments:

Post a Comment