[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Query analyzer hangs on startup

Posted on 2011-10-11
6
Medium Priority
?
167 Views
Last Modified: 2012-05-12
when opening query analyzer when
it should pop up the list of servers to select
the application hangs and Beeps like a modal dialog is open
no message is displayed and whenever  you click on anything in the
analyzer it just beeps.

you have to kill it with task manager.
anybody have any ideas on how to fix this?
Thanks!
0
Comment
Question by:Jay Toops
  • 3
  • 2
6 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 36950879
Can you keep the screen shot.. That will be more helpful...
0
 
LVL 40

Expert Comment

by:lcohan
ID: 36951078
What SSMS version(s) do you have installed on the Client computer?
Did you installed any SQL service pack for the tool itself? Remember they need updates as well.
Do you have a local host file?

You can at any time clear you SSMS server list by using acceped solution from link below:

http://stackoverflow.com/questions/1059105/how-to-remove-server-name-items-from-history-of-sql-server-management-studio
0
 
LVL 10

Author Comment

by:Jay Toops
ID: 36952281
its Query Analyzer 2005
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 40

Expert Comment

by:lcohan
ID: 36957686
Technicaly there is no "Query Analyzer 2005" but "SQL Management Studio 2005"

http://blog.sqlauthority.com/2007/04/23/sql-server-2005-query-analyzer-microsoft-sql-server-management-studio/

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/1d3616db-a007-4388-a934-81daf2573807

And still 2 answers are needed..did you applied any SQL Service pack on your client SSMS 2005?
Is there any VPN/Firewall between client computer and SQL server
0
 
LVL 10

Accepted Solution

by:
Jay Toops earned 0 total points
ID: 36958000
This problem was solved by clicking on the top bar ,then maximizing and minimizing.
Very ANNOYING problem because it virtually locked the ability to use it up for hours.

I never found out what the message was.. but it persisted over system restart.
Wierd.
Thanks for the suggestions..

0
 
LVL 10

Author Closing Comment

by:Jay Toops
ID: 36978250
One of my co-workers found this solution...
Thanks though!
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Loops Section Overview
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question