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 |
|
faizankh
Starting Member
8 Posts |
 Posted - 2005-10-13 : 12:11:25
|
| Hi there, I have a question about replication, i'm new to sql server and i was working with replication to see how it works, i'm trying to subscribe a table to another computer (or server), i'm getting this error, please help.Error message for Remote agent:"The process could not connect to Subscriber '<Server_name>'. SQL Server does not exist or access denied." |
|
|
penumatsa
Constraint Violating Yak Guru
289 Posts |
Posted - 2005-10-16 : 02:31:26
|
| Do you have permission to access the other computer. From the error message that you posted, it seems to be with permissions. Check the permissions on the subscriber.Hope this helps.suresh penumatsa |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-08 : 15:21:29
|
| I have never seen that error message to actually mean permissions. It's almost always a connectivity issue between the two boxes. It could also mean that the SQL Server service is stopped. Open up Enterprise Manager on both servers, try registering the other server in it. Once you are able to successfully connect to each other from there, it should work within the replication wizard screens.Creating an alias on both servers to the other server via Client Network Utility will almost certainly fix this issue.Tara Kizer |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-09 : 01:06:14
|
quote:
subscribe a table to another computer (or server)
do you mean:1. you already have an existing publication and will just add a table?2. add a subscriber to an existing publication?3. create a new publication with subscriber(s)?--------------------keeping it simple... |
|
|
|
|
|
|
Replication Question