Mangament studio hangs on db connection

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I'm having a very wierd problem with Management studio.

Until today everything was working fine - I could connect to SQL
Servers from my WinXP box running management studio without any
trouble.

Today, when I try to log in the "connect to server" box just hangs.
The little orange and white progress indicator is moving across the
screen like always, but nothing happens. I've left it this way for 3
hours and had neither a successful connection or error message.
Clicking cancel doesn't seem to do anything.

What is bizarre is that everything is fine with the server I am trying
to connect to. I can use SQLCMD from my winXP box to connect without
trouble. The web apps that use the server are working fine, and other
machines are able to connect to it using management studio. It's just
this machine that is hanging.

I'm hoping to avoid the dreaded $250 phone call to Microsoft on this
one. Anybody seen this problem before?

Thanks,
John

.



Relevant Pages

  • Re: CryptAcquireContext _sometimes_ fails with NTE_PROVIDER_DLL_FAIL
    ... I solved the problem on the WinXP machines, now I am not using the ... default container but a named one. ... This works on WinXP, but on Win2003 Server SE I have the following effects: ...
    (microsoft.public.platformsdk.security)
  • Re: SQL Server Management Studio Express
    ... Microsoft SQL Server Management Studio Express - Community Technical Preview ... (CTP) ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • RE: SQL Server 2005 Management Studio very slow in starting
    ... So your database server can not make any outgoing web ... since we can use SQL management studio to connect any kind of ... the SQL 2005 instances, ... |> that I am allowing local and remote connections using both named pipes ...
    (microsoft.public.sqlserver.xml)
  • Re: Fehlermeldung SSIS - MSDB - mscorlib
    ... Hallo Raffaello, ... Obwohl ich nur eine Defaultinstanz installierte hatte und KEINE benannte Instanz, trug ich in der Datei "MsDtsSrvr.ini.xml" den Server gleichwohl ein. ... Microsoft SQL Server Management Studio ...
    (microsoft.public.de.sqlserver)
  • Re: Mobile Only? Why?
    ... Are you using the RTM version of SQL Server Management Studio? ... - On the File menu, point to New, and then click Database Engine Query ...
    (microsoft.public.sqlserver.tools)