SQL Query Analyzer

Last Post 24 Mar 2009 01:39 PM by sql-tips. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sql-tips
New Member
New Member

--
23 Mar 2009 09:29 AM
I am trying to access Query Analyzer from Enterprise Manger Tool --> SQL Query Analyzer in SQL 2000 and Query Analyzer is disabled, even though I logged in as 'sa' account. Is anything to do with service pack?
sql-tips
New Member
New Member

--
23 Mar 2009 11:44 AM
Yes, If I execute directly it works fine.
sql-tips
New Member
New Member

--
24 Mar 2009 07:14 AM
Yes, I registered with sa account and also tried with windows account which has builtin administrator account. Infact I registered multiple instances on EM and none of them I can see query analyzer. I applied SP4 too, but no luck.
sql-tips
New Member
New Member

--
24 Mar 2009 09:15 AM
EM for SQL 2000.
sql-tips
New Member
New Member

--
24 Mar 2009 01:39 PM
SQL 2000 instance. You can't register SQL2005 instance on SQL2000 EM it throws SQL-DMO error.

I tried reboot machine several times and also install all client tools selected but no luck.

SQL Query Analyzer, Full-Text Indexing and SQL Profiler these three are grayed out.
sql-tips
New Member
New Member

--
25 Mar 2009 07:29 AM
Yes. I applied SP4
sql-tips
New Member
New Member

--
27 Mar 2009 07:59 AM
Actually, I am using SQL 2000 on windows vista business OS. Is this causing an issue?
You are not authorized to post a reply.

Acceptable Use Policy