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 "Myserver\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
Tartuffe

Hi,

Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)

From your description, it seems that you failed to connect to your database from the SQLServer Management Studio Express and the error message displays, right?

I suggest that you should use command line utility to connect to express and change the setting.

i.e.

sqlcmd -S".\Express" -Q"exec sp_configure 'user connections','32767';
reconfigure with override"

Thanks.

|||

Thanks for replying.

I couldn't try your solution because when i type sqlcmd, i get an error:

"could not open a connection" ... "login time-out has expired".

I checked the services which are:

remote connections: both tcp/ip and names pipes

sql service browsing: running

??

|||

sorry, when i do sqlcmd -S servername\sqlexpress i get in.

Now i typed your solution but i presume i have to change 'user connections' with 'servername\myaccount'?

Do i have to type '32767' with the quotes or without them?

i typed this:

sqlcmd -S servername\sqlexpress -Q exec sp_configure 'servername\myaccount','32767';

reconfigure with override

but this gives: unexpected argument

|||

Hi,

For more information on sqlcmd tool, see:http://technet.microsoft.com/zh-cn/library/ms162773.aspx

sp_configure is a stored procedure name to be executed.

"user connections" is the option name, not 'servername\myaccount', and '32767' is the value we set for that option.

For more information on the usage of the sp_configure procs, see:http://technet.microsoft.com/en-us/library/ms188787.aspx

Thanks.