Remote connection question

Hi

I have a server with windows 2003 and SQL Server 2005 installed.

When I use the client on the server to connect to the database (using windows authentication) it does this no problem. And when remotely connecting (using SQL authentication) it 'seems' to do it no problem as well.

However in "SQL Sevrer Management Studio" on the server when I connect it displays the server name with a nice green circle with a little arrow inside. On the remote computer it 'seems' to connect but I don't get the green circle with the arrow next to the server (just get a white circle) - Hope this all makes sense.

I get the feeling I can 'see' the server but can't connect properly. Is this common behaviour (white circle) or have I made a 'school boy error' somewhere along the way!?

Any help/suggestions would be much appreciated. Thanks in advance!

Regards

Toby

Would you go to Surface Area Configuration to enable Remote Connection?|||

Surface Area Configuration is setup correctly (on the server):

Database Engine/Remote Connections => Local and Remote Connections - using both TCP/IP and named pipes.

|||

Just to clarify where I am and what I have tried

Basically on the remote computer I log in with "sa" and it says it connects, but it doesn't look/behave like its connected. And on the server I log in with windows authentication and it connects no problem with full functionality.

The server is setup to accept remote connections. It uses both windows and sql authentication. I have tried playing around with the TCP/IP port numbers. I've stopped the windows firewall in administrative tools/services on both the server and remote machine. Also added sql drivers under the ODBC Data Source Administrator for both the client & server.

I am pretty much out of ideas and the problem is really starting to bug me. I can't be the only person getting this bug/problem!?

Thanks in advance
Toby