Error 50007: xp_execresultset: unable to get a bound connection back to server

Hi,
I have just resinstalled my server and restored the backup of my database. I am now trying to re-setup replication and I get the above error. The server configuiration:
Win2k3
SQL Server 2000 SP4
Replication: Distributor & Publisher (intended Push Publisher)
Snapshot
Subscriber: Remote server
I have looked around the web for similar problems and resolutions but mine still does not want to work. I have completely removed the replication as per the information on this article: http://support.microsoft.com/kb/324401 but still cannot get it working.
I did not backup the distribution db, master or msdb - only the main database I want to replicate.
Any advice?
Thanx
Dave
From http://www.developmentnow.com/g/114_0_0_0_0_0/sql-server-replication.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
You get this error when you have not set up your administrative link
password correctly. Either uncheck this option or ensure that when you
configure your publisher you enter the correct one.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dave" <nospam@.developmentnow.com> wrote in message
news:2ae92f81-6f29-41d1-ba10-e7841b355fbb@.developmentnow.com...
> Hi,
> I have just resinstalled my server and restored the backup of my database.
> I am now trying to re-setup replication and I get the above error. The
> server configuiration:
> Win2k3
> SQL Server 2000 SP4
> Replication: Distributor & Publisher (intended Push Publisher)
> Snapshot
> Subscriber: Remote server
> I have looked around the web for similar problems and resolutions but mine
> still does not want to work. I have completely removed the replication as
> per the information on this article:
> http://support.microsoft.com/kb/324401 but still cannot get it working.
> I did not backup the distribution db, master or msdb - only the main
> database I want to replicate.
> Any advice?
> Thanx
> Dave
> From
> http://www.developmentnow.com/g/114_0_0_0_0_0/sql-server-replication.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
|||Hi,
Thanx for the information. I have managed to get it to work again by creating a new username and password for the distribution agents to use. Initially it was set to impersonate the service account (which is a domain account that the SQL Services use). I would have thought that this would be sufficient. I even gave this account sysadmin privledges.
Also, when I first setup the replication it worked without having to change any usernames and/or passwords. Was the problem because I recovered from a backup?
Thanx
Dave
From http://www.developmentnow.com/g/114_2007_7_0_0_995269/Error-50007-xp-execresultset-unable-to-get-a-bound-connection-back-to-server.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
|||Its hard to say what caused the problem, but I am glad you have solved it.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dave" <nospam@.developmentnow.com> wrote in message
news:2258406d-86c6-4c5e-87e2-1283b7f9b4e6@.developmentnow.com...
> Hi,
> Thanx for the information. I have managed to get it to work again by
> creating a new username and password for the distribution agents to use.
> Initially it was set to impersonate the service account (which is a domain
> account that the SQL Services use). I would have thought that this would
> be sufficient. I even gave this account sysadmin privledges.
> Also, when I first setup the replication it worked without having to
> change any usernames and/or passwords. Was the problem because I recovered
> from a backup?
> Thanx
> Dave
> From
> http://www.developmentnow.com/g/114_2007_7_0_0_995269/Error-50007-xp-execresultset-unable-to-get-a-bound-connection-back-to-server.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com