Thursday, January 03, 2013 1:38 PMI've configured a push subscription on an SQL Server 2000, to replicate a database to an SQL Server 2008. I've added a user (rdem) on both servers using SQL Authentication, and gave the user sufficient permissions on the (empty) database on the SQL Server 2008. I had to restart the SQL Server 2008 because I switched to mixed authentication instead of only Windows Authentication. Everything seemed to work fine.
That was only meant as an excersise though. I removed the database on the SQL Server 2008, removed the user on both servers, and removed the push subscription on the SQL Server 2000. I redid all steps as mentioned before, created a new user on both servers named PIDRepl, etc... Unfortunately, it no longer works.
The SQL Server 2000 cannot connect to the 2008, because apparently it's still using the old user, "rdem". A bit strange, since I removed that user, and it's nowhere listed in any configuration dialog for my replication.
Thursday, January 03, 2013 1:40 PMModeratorYou are likely connecting as an ODBC subscriber. Check for an ODBC connection on your publisher that is using this account.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
Thursday, January 03, 2013 1:44 PMThat doesn't appear to be the case. And if it were, wouldn't this problem have presented itself during my first "excercise"?
Thursday, January 03, 2013 2:05 PM
I found the problem. I set the owner of the agent as "PIDRepl", but forgot to change the credentials for the Agent connection to the Subscriber.
- Marked As Answer by ruben.demey Thursday, January 03, 2013 2:05 PM