Showing posts with label distributor. Show all posts
Showing posts with label distributor. Show all posts

Wednesday, March 7, 2012

Cannot Subscribe Using Windows Synchronization Manager

Hi,
I'm using two instances of SQL Server 2005 Developer Edition (SP2) on the
same machine. One instance is Publisher and Distributor and the other is
Subscriber. When I try to use Windows Synchronization Manager to subscribe
to the publication, I get this error:
The SQL Server publication uses features that the current version of the
Subscriber does not support. The subscriber should be upgraded to 'Unknown
version of Microsoft SQL Server'.
Any help would be greatly appreciated,
Leila
Can you check the compatibility level of the subscription database?
Also see if you can do a simple pull subscription to see if that works.
Hilary Cotter
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
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23ESWMUCTHHA.1200@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I'm using two instances of SQL Server 2005 Developer Edition (SP2) on the
> same machine. One instance is Publisher and Distributor and the other is
> Subscriber. When I try to use Windows Synchronization Manager to subscribe
> to the publication, I get this error:
> The SQL Server publication uses features that the current version of the
> Subscriber does not support. The subscriber should be upgraded to 'Unknown
> version of Microsoft SQL Server'.
> Any help would be greatly appreciated,
> Leila
>
|||compatibility level is 9, pull subscription without Synchronization Manager
works!
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%234mNP4DTHHA.4404@.TK2MSFTNGP03.phx.gbl...
> Can you check the compatibility level of the subscription database?
> Also see if you can do a simple pull subscription to see if that works.
> --
> Hilary Cotter
> 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
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23ESWMUCTHHA.1200@.TK2MSFTNGP02.phx.gbl...
>
|||Sounds like something is wrong with Windows Synchronization Manager. Can you
try from another machine?
Hilary Cotter
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
"Leila" <Leilas@.hotpop.com> wrote in message
news:OJC3wRFTHHA.4956@.TK2MSFTNGP04.phx.gbl...
> compatibility level is 9, pull subscription without Synchronization
> Manager works!
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%234mNP4DTHHA.4404@.TK2MSFTNGP03.phx.gbl...
>
|||I'll try that!
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23OP$xzFTHHA.5108@.TK2MSFTNGP06.phx.gbl...
> Sounds like something is wrong with Windows Synchronization Manager. Can
> you try from another machine?
> --
> Hilary Cotter
> 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
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:OJC3wRFTHHA.4956@.TK2MSFTNGP04.phx.gbl...
>
|||I'll try that!
One more thing: BOL says that interactive conflict resolution is not
available when you synchronize via SSMS. Then why is there such an option
when you create the subscription in SSMS?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23OP$xzFTHHA.5108@.TK2MSFTNGP06.phx.gbl...
> Sounds like something is wrong with Windows Synchronization Manager. Can
> you try from another machine?
> --
> Hilary Cotter
> 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
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:OJC3wRFTHHA.4956@.TK2MSFTNGP04.phx.gbl...
>
|||It is for subscriptions that you will pull through WSM. Note you have to
also enable interactive conflict resolution in WSM as well
Hilary Cotter
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
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23w5nP4HTHHA.2124@.TK2MSFTNGP06.phx.gbl...
> I'll try that!
> One more thing: BOL says that interactive conflict resolution is not
> available when you synchronize via SSMS. Then why is there such an option
> when you create the subscription in SSMS?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23OP$xzFTHHA.5108@.TK2MSFTNGP06.phx.gbl...
>
>

Saturday, February 25, 2012

Cannot start Log Reader Agent and Snapshot Agent

I am testing peer to peer replication in our environment. I simulated a three node peer to peer topology and a local distributor.

For some wierd reason I cannot get the Log Reader Agent and snapshot agent to start. The domain account under which SQL Server Agent runs has administrator previlage on the box. I also use a domain account for SQL Server Service. (none of the passwords changed).

This is the error I am getting - "Executed as user: abc. A required privilege is not held by the client. The step failed"

Any ideas?

Also this domain account is a member of

SQLServer2005MSSQLUsers$ServerName$MSSQLSERVER

SQLServer2005MSAgentUser$ServerName$MSSQLSERVER


open the properties of each job and change the owner to sa and it should work fine.|||I tried it. No luck...it gives the same error message