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 |
|
kirknew2SQL
Posting Yak Master
194 Posts |
 Posted - 2008-01-29 : 12:06:23
|
| I have SQL Server 2005 running on my local computer (OS Windows 2000). I also have SLQ Server 2005 running on a server (64 bit OS Windows 2003)I need to copy a table from a DB on my local server to a DB on the server. On my local computer I can see and connect to the DB on the server. No problem.But when I remote desktop to the server and try to connect to the server on my local computer I get the error:Error has occurred trying to establish connection to the server… under default settings server does not allow remote connections…Both servers are set to the default settings. What settings do I need to change so that I can connect to my local server from the other server? |
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-01-29 : 18:18:16
|
| Did you allow a remote desktop on the server? Cause by default, this option is tick. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-29 : 22:49:19
|
| You need enable remote access in sql server surface configuration manager, and ensure tcp/ip and/or named pipes protocols are enabled. |
|
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2008-01-30 : 10:09:57
|
| valdyv - I can remote desktop into the remote server. rmiao - I will look in BOL for remote access .It is interesting that the server on my local computer connected to the remote server no problem with default settings. But the remote server could not see my local sxerver. |
|
|
|
|
|
|
Servers can't see each other