In Database Properties | Permissions when I highlight a "user or roles" and click "Effective Permissions" I get an error dialog as indicated below. Given that this is beta software, is it a known bug, or is it something I'm doing
John
===================================
Cannot show requested dialog.
===================================
Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlmgmt.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()
SSMSE Cannot show requested dialog
zadcoe
John
James Divine
kReynolds
Just to make sure I didn't break anything I just copied the Microsoft.SqlServer.Express.SqlManagerUI.dll and renamed it to SqManagerUI.dll. This seemed to have fixed the issue. This, I'm sure, will be a temporary fix until the next release.
Nehal Jain
i think that when i change the Drive Letter thats contain the DB this problem apper,
attach DB agin......
Fabita
Mark Kaplan
It appears the bug has been fixed, but a new build of SSMS-EE has not been released. Though I would expect the RTM version of SSMS-EE will have the fix.
Cheers,
Dan
Jacques van t Ende
I'm encountering a variation on this error message when trying to "View Schema Permissions" from the table properties dialog in SSMS-EE. Same message as originally reported at the top of this thread, except it is SqlManagerUi.dll that it can't load.
Is this also a known issue
Cheers
John