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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-05-25 : 13:01:58
|
| I have a sql server 2005 database that I have set as the publisher and an sql express database that I have set as the subscriber.I set it that the 2005 db should push to the sql express db.when i look at the replication monitor I get an error The process could not connect to subscriber name/sqlexpresswhat can I do to get this working?I really am trying to just replicate 1 table every minute from the sql 2005 db to the sql expressPlease advise? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-25 : 14:18:55
|
| Are they in same domain? What's sql service startup account? How did you set replication permission? Need details for people to help you. |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-05-25 : 14:29:45
|
| no not the same domaindifferent servers that are networked..for the main one I used windows log in for the subscription i used a sql login with full permissions.what's the right way to do this? |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-05-25 : 14:30:11
|
| no not the same domaindifferent servers that are networked..for the main one I used windows log in for the subscription i used a sql login with full permissions.what's the right way to do this? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-25 : 14:38:48
|
| Looks like sql service account on sql2k5 doesn't have permission to access sql express. Possible to trust domains? |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-05-26 : 02:02:42
|
| is this a setting in sql or on the server? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-26 : 20:27:22
|
| No, in wondows ADS. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-05-27 : 04:04:09
|
| the sysadmin says they are the same domain but when i log in to sql i put in a different domain in the usrname field (or is that username?)if they are the same domain then what could be the problem? |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-05-27 : 06:11:18
|
| I got it working -- but I have another database that I would like to synchronize that's on a different domain and they can't be trusted domains - is this possible to do using the sql login credentials? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 22:13:54
|
| How do you want to sync them? |
|
|
|
|
|
|
The process could not connect to subscriber