Cannot restore database: requested

Showing posts with label requested. Show all posts

Sunday, February 19, 2012

Cannot show requested dialog Error on View Database Permissions

I am having issues with the database permissions on SQL Server Express. I downloaded the SQL Server 2005 Express Edition with Advanced Services SP1 and everytime I try to view database/schema permissions I get an error "Cannot show requested dialog." I have 3 different installs of Sql Express 2005 on different machines and they all throw the same error. The error happens in a couple locations but one way is going databases > select any database > Security > Schemas > Select and right click on a schema > permissions > and click view database permissions, I get the error message below. Does anyone else have this problem?

Thanks

Scott

===================================

Cannot show requested dialog.

===================================

Could not load file or assembly 'file:///c:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlManagerUi.dll' or one of its dependencies. The system cannot find the file specified. (mscorlib)

Program Location:

at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, StackCrawlMark& stackMark)
at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence)
at System.Activator.CreateInstanceFrom(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)
at System.Activator.CreateInstanceFrom(String assemblyFile, String typeName, Object[] activationAttributes)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.SqlMgmt.FormLauncher.OnCreateAndShowForm(IServiceProvider serviceProvider, XmlDocument xml)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

Seems like a managment studio issue. I'm going to move this question to the Tools forum.

Mike

Cannot show requested dialog Error on View Database Permissions

Thanks

Scott

===================================

Cannot show requested dialog.

===================================

Program Location:

Seems like a managment studio issue. I'm going to move this question to the Tools forum.

Mike

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
>

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.

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
>

Sunday, February 19, 2012

Cannot show requested dialog Error on View Database Permissions

Cannot show requested dialog Error on View Database Permissions

Cannot show requested dialog

Cannot show requested dialog

Cannot show requested dialog

Cannot restore database

Blog Archive

About Me