Can't connect to server using server management studio

Hi,
For some reason I can't connect to a (remote) SQL server using SQL server
management studio (2005) from my local SQL 2005 Server. I can connect from
numerous other PCs/Servers in my site except this one. The local SQL Server
is running Windows 2003 R2.
It will accept the username (sa) and password and just hang there. It then
pops up the error:
"is Busy
Microsoft SQL Server Management Studio is waiting for an internal operation
to complete."
Then after a while it will fail with the error:
"An exception occurred while executing a transact-sql statement or batch.
Additional information:-
A transport level error has occured when receiving results from the server"
I have checked the network setup and there are definately no firewall or
routing issues (after all you can log on - if you get the password wrong it
tells you), plus several other PCs/Servers at this site can access the
server with no problems at all. There is no firewall on the local server.
Can anyone shed any light on this? Any help much appreciated.
Thanks in advance,
-HCan you connect to the SQL instance from that client machine at all, I mean,
if you try a different tool such as osql.exe? That should help narrow the
scope of the problem.
Linchi
"Hooopla" wrote:

> Hi,
> For some reason I can't connect to a (remote) SQL server using SQL server
> management studio (2005) from my local SQL 2005 Server. I can connect from
> numerous other PCs/Servers in my site except this one. The local SQL Serve
r
> is running Windows 2003 R2.
> It will accept the username (sa) and password and just hang there. It then
> pops up the error:
> "is Busy
> Microsoft SQL Server Management Studio is waiting for an internal operatio
n
> to complete."
> Then after a while it will fail with the error:
> "An exception occurred while executing a transact-sql statement or batch.
> Additional information:-
> A transport level error has occured when receiving results from the server
"
> I have checked the network setup and there are definately no firewall or
> routing issues (after all you can log on - if you get the password wrong i
t
> tells you), plus several other PCs/Servers at this site can access the
> server with no problems at all. There is no firewall on the local server.
> Can anyone shed any light on this? Any help much appreciated.
> Thanks in advance,
> -H
>
>|||I'm afraid osql times out aswell. I'm also trying to use a third party
package and that has the same problem
-H
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
>|||FYI I can remote desktop successfully to the remote server.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
>