Tuesday, March 27, 2012
Can't close IDE, modal dialog, anyone know what's causing this?
when working with Dundas chart properties. I don't have a modal dialog
open, or at least not that I can find. I use alt-esc to loop through the
dialogs on the OS, nothing. Microsoft has an entry in support, it says it
usually happens when I try to shut down and have left a modal dialog
open...only there is no dialog to close. I end up ending the IDE process
tree. Anyone else getting this and/or know the cause?
Microsoft Visual Studio cannot shut down because a modal dialog is active.
Close the active dialog and try again.
Yes it's Friday the 13th :)
Steve MunLeeuwhttp://geekswithblogs.net/geekusconlivus/archive/2006/02/28/70918.aspx
This is a lot better description, sorry for posting.
Steve MunLeeuw
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:u6iO0Qy7GHA.940@.TK2MSFTNGP03.phx.gbl...
> I've only seen this happen when using the report designer, and I think
> only when working with Dundas chart properties. I don't have a modal
> dialog open, or at least not that I can find. I use alt-esc to loop
> through the dialogs on the OS, nothing. Microsoft has an entry in
> support, it says it usually happens when I try to shut down and have left
> a modal dialog open...only there is no dialog to close. I end up ending
> the IDE process tree. Anyone else getting this and/or know the cause?
> Microsoft Visual Studio cannot shut down because a modal dialog is active.
> Close the active dialog and try again.
> Yes it's Friday the 13th :)
> Steve MunLeeuw
>|||If I've been working with the code view of reports, my VS 2005 doesn't close
like normal. I usually have to close it by killing the DevEnv.exe service in
Task Manager...
Not a very elegant solution, but it will close. ;)
Kaisa M. Lindahl Lervik
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:ekQn5Ty7GHA.3740@.TK2MSFTNGP05.phx.gbl...
> http://geekswithblogs.net/geekusconlivus/archive/2006/02/28/70918.aspx
> This is a lot better description, sorry for posting.
> Steve MunLeeuw
> "Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
> news:u6iO0Qy7GHA.940@.TK2MSFTNGP03.phx.gbl...
>> I've only seen this happen when using the report designer, and I think
>> only when working with Dundas chart properties. I don't have a modal
>> dialog open, or at least not that I can find. I use alt-esc to loop
>> through the dialogs on the OS, nothing. Microsoft has an entry in
>> support, it says it usually happens when I try to shut down and have left
>> a modal dialog open...only there is no dialog to close. I end up ending
>> the IDE process tree. Anyone else getting this and/or know the cause?
>> Microsoft Visual Studio cannot shut down because a modal dialog is
>> active. Close the active dialog and try again.
>> Yes it's Friday the 13th :)
>> Steve MunLeeuw
>|||Kaisa M. Lindahl Lervik wrote:
> If I've been working with the code view of reports, my VS 2005 doesn't close
> like normal. I usually have to close it by killing the DevEnv.exe service in
> Task Manager...
> Not a very elegant solution, but it will close. ;)
> Kaisa M. Lindahl Lervik
>
> "Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
> news:ekQn5Ty7GHA.3740@.TK2MSFTNGP05.phx.gbl...
> > http://geekswithblogs.net/geekusconlivus/archive/2006/02/28/70918.aspx
> >
> > This is a lot better description, sorry for posting.
> >
> > Steve MunLeeuw
> >
> > "Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
> > news:u6iO0Qy7GHA.940@.TK2MSFTNGP03.phx.gbl...
> >> I've only seen this happen when using the report designer, and I think
> >> only when working with Dundas chart properties. I don't have a modal
> >> dialog open, or at least not that I can find. I use alt-esc to loop
> >> through the dialogs on the OS, nothing. Microsoft has an entry in
> >> support, it says it usually happens when I try to shut down and have left
> >> a modal dialog open...only there is no dialog to close. I end up ending
> >> the IDE process tree. Anyone else getting this and/or know the cause?
> >>
> >> Microsoft Visual Studio cannot shut down because a modal dialog is
> >> active. Close the active dialog and try again.
> >>
> >> Yes it's Friday the 13th :)
> >> Steve MunLeeuw
> >>
> >
> >
yes..this is happening to me quie a bit when writing a lot of reports
and changing a lot of charts...save soon save often....it looks like
the dundas dialogs and the vs dialogs get a bit confused...that is
all...
Peter
www.peternolan.com
can't block delete permissions
d the table’s ‘manage permissions’ dialog and explicitly denied delete
permission to one of our programmers. She was still able to delete records.
We looked at her database
role membership and saw that she was a member of the db_owner role, so I rev
oked that. I then ran a DENY statement: "deny delete on Histories to edenr".
I removed her memberships in the db_accessadmin and db_securityadmin roles,
and had her close and reop
en Enterprise Manager. After all that, she was still able to delete records.
The manage permissions dialog for this table shows that she is denied delete
permissions. She is still a member of the public, db_datareader, and db_dat
awriter groups, but that shouldn’t override explicitly denied permissions.
I’m the dbo of the datab
ase, so I certainly should have sufficient rights to issue a denial.
What does it TAKE to block a programmer from having permission to delete rec
ords?Yes but what Login is Enterprise Manager using? It is probably not hers.
Andrew J. Kelly SQL MVP
"eachus" <eachus@.discussions.microsoft.com> wrote in message
news:A4C20AFD-E526-4EFD-BAE0-42125FE1641F@.microsoft.com...
> I'm trying to lock down an audit table in our database. As a test, I
opened the table's 'manage permissions' dialog and explicitly denied delete
permission to one of our programmers. She was still able to delete records.
We looked at her database role membership and saw that she was a member of
the db_owner role, so I revoked that. I then ran a DENY statement: "deny
delete on Histories to edenr". I removed her memberships in the
db_accessadmin and db_securityadmin roles, and had her close and reopen
Enterprise Manager. After all that, she was still able to delete records.
> The manage permissions dialog for this table shows that she is denied
delete permissions. She is still a member of the public, db_datareader, and
db_datawriter groups, but that shouldn't override explicitly denied
permissions. I'm the dbo of the database, so I certainly should have
sufficient rights to issue a denial.
> What does it TAKE to block a programmer from having permission to delete
records?
>|||Hi,
Check the role associated for the user first by executing below command:-
sp_helplogins <Login_name_for that _user'
If you have any roles apart from db_datareader and db_datawriter revoke
that.
After this Execute the below command
use <dbname>
go
deny delete on <table_name> to <user_name>
After that login to query analyzer using that user and run the command:-
select suser_sname()
Now execute the delete statatement on that table.
Thanks
Hari
MCDBA
"eachus" <eachus@.discussions.microsoft.com> wrote in message
news:A4C20AFD-E526-4EFD-BAE0-42125FE1641F@.microsoft.com...
> I'm trying to lock down an audit table in our database. As a test, I
opened the table's 'manage permissions' dialog and explicitly denied delete
permission to one of our programmers. She was still able to delete records.
We looked at her database role membership and saw that she was a member of
the db_owner role, so I revoked that. I then ran a DENY statement: "deny
delete on Histories to edenr". I removed her memberships in the
db_accessadmin and db_securityadmin roles, and had her close and reopen
Enterprise Manager. After all that, she was still able to delete records.
> The manage permissions dialog for this table shows that she is denied
delete permissions. She is still a member of the public, db_datareader, and
db_datawriter groups, but that shouldn't override explicitly denied
permissions. I'm the dbo of the database, so I certainly should have
sufficient rights to issue a denial.
> What does it TAKE to block a programmer from having permission to delete
records?
>|||Thanks for the suggestions. I tried this, and got the same result. It did ha
ve the effect of re-confirming that the deletions were being run under the p
ermissions of the user in question, which was useful.
The goal here is to be able to block anybody, including programming team mem
bers, from being able to delete records in the production database's audit t
able.
Got any other suggestions where she might be getting delete permissions that
override the explicit denial?
"Hari" wrote:
> Hi,
> Check the role associated for the user first by executing below command:-
> sp_helplogins <Login_name_for that _user'
> If you have any roles apart from db_datareader and db_datawriter revoke
> that.
> After this Execute the below command
> use <dbname>
> go
> deny delete on <table_name> to <user_name>
> After that login to query analyzer using that user and run the command:-
> select suser_sname()
> Now execute the delete statatement on that table.
>|||Check server roles as well. Maybe she is a member of
sysadmins either directly or through windows group
membership
-Sue
On Fri, 2 Jul 2004 09:07:02 -0700, Eachus
<Eachus@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks for the suggestions. I tried this, and got the same result. It did h
ave the effect of re-confirming that the deletions were being run under the
permissions of the user in question, which was useful.
>The goal here is to be able to block anybody, including programming team me
mbers, from being able to delete records in the production database's audit
table.
>Got any other suggestions where she might be getting delete permissions tha
t override the explicit denial?
>"Hari" wrote:
>|||Thanks--it looks like that was it. Most of our programmers, including the on
e I'm using as a test case, are members of the System Adminstrators role, an
d the System Adminstrators role has delete permissions on any object in any
database.
All domain admins are automatically members of the sysadmins role, so anyone
who is a domain admin can't be removed from the group even if I decided tha
t was the best solution.
It looks like permissions granted due to membership in the sysadmins role ca
n't be overridden by a denial? Is there any way to override these permission
s in a particular database?
"Sue Hoegemeier" wrote:
> Check server roles as well. Maybe she is a member of
> sysadmins either directly or through windows group
> membership|||X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: microsoft.public.sqlserver.security
NNTP-Posting-Host: 0-1pool76-99.nas29.thornton1.co.us.da.qwest.net 67.4.76.9
9
Path: TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
Lines: 1
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.security:21673
Good - glad to hear that helped you track it down.
On the sysadmins, someone who is a member of the role can do
everything. Members of this role bypass any denies you set
up for them. You can't override this on any level, not by
database or anything else. They can do whatever.
Regarding domain admins, they get their access through the
BUILTIN\Administrators group in SQL Server that is by
default a member of sysadmins. You can remove the
BUILTIN\Administrators but doing this can cause some
problems. Whether you get problems or not depends. The
following article has an more information section with links
to some issues that could come up:
INF: How to impede Windows NT administrators from
administering a clustered instance of SQL Server
http://support.microsoft.com/?id=263712
-Sue
On Tue, 6 Jul 2004 11:38:02 -0700, Eachus
<Eachus@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks--it looks like that was it. Most of our programmers, including the o
ne I'm using as a test case, are members of the System Adminstrators role, a
nd the System Adminstrators role has delete permissions on any object in any
database.
>All domain admins are automatically members of the sysadmins role, so anyon
e who is a domain admin can't be removed from the group even if I decided th
at was the best solution.
>It looks like permissions granted due to membership in the sysadmins role c
an't be overridden by a denial? Is there any way to override these permissio
ns in a particular database?
>"Sue Hoegemeier" wrote:
>
Sunday, March 11, 2012
cannot view job properties. i keep getting "new job" dialog box.
In my installation of sql server 2005, i cannot view any job properties. when i doubble click on a job, i just get the "new job" dialog box. when i right click on a job and select properties, i also get the "new job" dialog box. i have reinstalled sql server workstation components and restarted but it did not fix the issue. anyone ever have this issue
post back the Service Pack in this box
Madhu
|||i reinstalled sql server completely and it works now. pitty i had to waste so much time doing that. have no idea why it would do what it done. no updates or serivce packs added in weeks and it has worked fine for the last ages.|||
I've seen this error a few times. It has to do with one of the Visual Studio installs or service packs on the PC you are using to view the job properties. Applying SQL Server service pack 2 fixes the problem.
-Sue
|||Also it may be issue with client tools on this machine, see whether you can reproduce from another machine with similar tools.
|||Exact same scenario here. I was hoping for a nice clean fix but I guess this one is going to be painful.
|||What service pack of the tools do you have? Did it just start happening or is it an ongoing problem? Did anything change on the server or client?|||It just started happening. I did install sp2 for sql but that was many weeks ago and it had been working fine. it was just a sudden thing. i was using it one morning and it was fine, and that afternoon it all went pear shaped.
|||Hmmm, nothing in the error log for the machine? And re-applying sp2 to the tools didn't fix it? (i.e. it wasn't a broken DLL somewhere)?
|||
I have the same problem:
SQL Server 2005 sp2 X64 clustered. There are no messages in any of the error logs. I did find this when I traced the server when I tired to view the properties of a job.
Cannot drop the table '#tmp_sp_db_vardecimal_storage_format', because it does not exist or you do not have permission.
I am a sysadmin. I just set this server up.
Thanks,
|||I reinstalled SQL Server SP 2 twice and it seemed to fix the problem|||
You need to reapply SP2. Just having SP2 installed doesn't mean it's protected from this issue. I've dealt with this one a few times - One of the dlls gets overwritten. I've seen it when SP2 was already installed and reapplying the service pack fixes the issue.
-Sue
|||
I had this same problem and I had to install SQL Server 2005 SP 2 twice and that seem to fix the problem.
Thursday, March 8, 2012
cannot update
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSL
Hi
"info@.sites4agents.com" wrote:
> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John
|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>
|||Hi
"info@.sites4agents.com" wrote:
> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html for more.
> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example data
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John
cannot update
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSLHi
"info@.sites4agents.com" wrote:
> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>|||Hi
"info@.sites4agents.com" wrote:
> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspf...-m-running.html for more.
> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example dat
a
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John
cannot update
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSLHi
"info@.sites4agents.com" wrote:
> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>> Hi
>> we moved from 2000 to 2003 (version 9)
>> I do Open Table to see all rows
>> when I try to change a value say 2 to 3 in int field it pops up dialog
>> and
>> say
>> like driver error string or binary data will be truncated
>> but it is an integer field and the values are like 2 and 3!
>> is it isolation level related perhaps
>> what setting is it
>> we just installed it so it must be default
>> Sincerely
>> GSL
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>|||Hi
"info@.sites4agents.com" wrote:
> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html for more.
> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example data
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John
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
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
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
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
>
Thursday, February 16, 2012
cannot see SQL Jobs on remote server
I'm having troubles brining up details of existing SQL Jobs from remote
server. When I double-click existing job, it brings up "New Job" dialog box
instead of job details.
I needed to see and modify steps of a job on my collegue's machine. I can
connect to her SQL Server 2005 all right. But when I find the job I need,
right click it and select "Properties", I get "New Job" dialog box with all
tabs empty. What's interesting is I can still use "Script job as" menu item.
Another thing is that I see error messages like this in my error log:
DCOM was unable to communicate with the computer AAA using any of the
configured protocols.
I looked up this message and verified that I don't have UDP or IPX enabled,
only Connection-oriented TCP/IP and Connection-oriented SPX.
My other collegue can see the jobs fine, so I suppose the configuration
issue is with my machine. We all have WinXP Proferssional SP2 and both SQL
Server 2000 and 2005 on our machines. 2005's version is
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
I'd really appreciate if anyone has ideas on that.
thanks,
Lucy
I think the two errors are separate issues. I've seen the
issue with viewing jobs come up a few times. I suspect that
it's caused by problems with the smo dll - did you install
visual studio service packs to your PC? Try applying SQL
Server 2005 SP2 on your PC. That worked for me a couple of
times that I've run into this.
-Sue
On Fri, 30 Mar 2007 15:06:01 -0700, Lucy
<Lucy@.discussions.microsoft.com> wrote:
>Hi,
>I'm having troubles brining up details of existing SQL Jobs from remote
>server. When I double-click existing job, it brings up "New Job" dialog box
>instead of job details.
>I needed to see and modify steps of a job on my collegue's machine. I can
>connect to her SQL Server 2005 all right. But when I find the job I need,
>right click it and select "Properties", I get "New Job" dialog box with all
>tabs empty. What's interesting is I can still use "Script job as" menu item.
>Another thing is that I see error messages like this in my error log:
>DCOM was unable to communicate with the computer AAA using any of the
>configured protocols.
>I looked up this message and verified that I don't have UDP or IPX enabled,
>only Connection-oriented TCP/IP and Connection-oriented SPX.
>My other collegue can see the jobs fine, so I suppose the configuration
>issue is with my machine. We all have WinXP Proferssional SP2 and both SQL
>Server 2000 and 2005 on our machines. 2005's version is
>Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
> Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
>NT 5.1 (Build 2600: Service Pack 2)
>I'd really appreciate if anyone has ideas on that.
>thanks,
>Lucy
|||Hi Sue, thanks for answering.
I already have SP2, and SMO appears to be ok too.
The errors in the log appear at the time when I try to access the remote
jobs, so there has to be some connection between them...
"Sue Hoegemeier" wrote:
> I think the two errors are separate issues. I've seen the
> issue with viewing jobs come up a few times. I suspect that
> it's caused by problems with the smo dll - did you install
> visual studio service packs to your PC? Try applying SQL
> Server 2005 SP2 on your PC. That worked for me a couple of
> times that I've run into this.
> -Sue
> On Fri, 30 Mar 2007 15:06:01 -0700, Lucy
> <Lucy@.discussions.microsoft.com> wrote:
>
>
|||Sorry, Sue, you were right. I looked at it once more and noticed that it was
my Windows that had SP2. Now I installed SP2 for SQL Server and the problem
went away.
Thanks a lot,
Lucy
"Lucy" wrote:
[vbcol=seagreen]
> Hi Sue, thanks for answering.
> I already have SP2, and SMO appears to be ok too.
> The errors in the log appear at the time when I try to access the remote
> jobs, so there has to be some connection between them...
> "Sue Hoegemeier" wrote:
|||No problem...thanks for posting back.
-Sue
On Mon, 2 Apr 2007 12:32:06 -0700, Lucy
<Lucy@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sorry, Sue, you were right. I looked at it once more and noticed that it was
>my Windows that had SP2. Now I installed SP2 for SQL Server and the problem
>went away.
>Thanks a lot,
>Lucy
>"Lucy" wrote: