Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
t.summerfield
Starting Member
7 Posts |
 Posted - 2007-03-26 : 12:16:00
|
| HiI 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! RegardsToby |
|
|
t.summerfield
Starting Member
7 Posts |
Posted - 2007-03-27 : 04:18:12
|
| I would include a couple of pics, but aint sure how the pic upload works.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 advanceToby |
 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-03-27 : 11:33:01
|
| I have seen this happen if your SQL Server is in a different domain from your client machine.RegardsParesh MotiwalaBoston, USA |
|
|
|
t.summerfield
Starting Member
7 Posts |
Posted - 2007-03-27 : 11:40:47
|
| I was speaking to someone about the problem and they also mentioned that it could be a domain name problem.Silly question. But how can I check which domain the server is on?RegardsToby |
|
|
|
|
|
|
Remote Connection question