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

(jhoge***@yahoo.com) writes:
It seems like it made contact - but was not able to complete it for
some reason. Could be some network problem.

Did you try the simple trick: reboot?

Erland,

I did try to reboot and it had no effect. SQLCMD works fine from this
machine, so I'm not sure what is messing up management studio.

John

jhoge***@yahoo.com (jhoge***@yahoo.com) writes:
Does it happen when you connect to any server, or only one particular
server? Can you connect to a local instance (if you have any)?

Does it happen both with Windows authentication and SQL Server
authentication?

Sorry, I don't really have any ideas, I just keep asking questions with
the vain hope that something will be revealed.

on my local network with Windows Authentication or a remote machine
with Sql Server Authentication.

SQLCMD works fine for both servers, and another WinXP Box on my local
network can sucessfully connect to both servers with Management Studio.
I guess this one just needs a new install of windows.

Thanks,

John

Bug in Enterprise Manager (SQL 2000)
copy database error 12291 and 208
SQL Server 2005 Activity Monitor doesn't show connections from Windows 98 clients
differnt execution plans for same query
Import Data succeeds but doesn't copy data?