By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,285 Members | 2,232 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,285 IT Pros & Developers. It's quick & easy.

Enterprise Manager Cannot Display Table Records or Run Query

P: n/a
I have a new installation of SQL Server 2000 Dev Edition on a Win2K3 Standard Edition Server that I used for development. I just set this machine up in th last week and installed all Win2K3 patches and then installed SQL2K and SP3a. I have a single named instance. I just noticed today that I cannot view table data or use the Query part of EM. When I right click a table and select Open Table->Return All Rows it gives me an error dialog "An unexpected error happened during this operation". While the EM is diplaying this dialog the EM screen looks like Internet Explorer and says "Action Canceled - You might not have permission to view this directory or page using the credentials you supplied." I believe that this is a EM issue as I cannot view table content on other remote server. ANy ideas? Might this be an IE security patch disallowing some connectivity ?

--Frank

--
Message posted via http://www.sqlmonster.com
Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Frank Rizzo via SQLMonster.com" <fo***@SQLMonster.com> wrote in message
news:08******************************@SQLMonster.c om...
I have a new installation of SQL Server 2000 Dev Edition on a Win2K3
Standard Edition Server that I used for development. I just set this
machine up in th last week and installed all Win2K3 patches and then
installed SQL2K and SP3a. I have a single named instance. I just noticed
today that I cannot view table data or use the Query part of EM. When I
right click a table and select Open Table->Return All Rows it gives me an
error dialog "An unexpected error happened during this operation". While
the EM is diplaying this dialog the EM screen looks like Internet Explorer
and says "Action Canceled - You might not have permission to view this
directory or page using the credentials you supplied." I believe that this
is a EM issue as I cannot view table content on other remote server. ANy
ideas? Might this be an IE security patch disallowing some connectivity ?

--Frank

--
Message posted via http://www.sqlmonster.com


A number of people seem to have had similar issues - if you Google the
newsgroups, you'll see that the usual response is to reinstall either the
MSSQL client tools (including SP3a) and/or the latest MDAC version.
Unfortunately, it doesn't always seem to solve the problem.

Simon
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.