Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Agent wont start
Message
From
26/08/2014 14:50:45
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Replication
Title:
Agent wont start
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01606468
Message ID:
01606468
Views:
59
I have two SQL servers (2012) on opposite sides of the country, each on a working group (not a domain). I have set up one to be a publisher and distributor. When I set up the subscription there are no errors, but the distribution agent wont start. I look in the SQL Agent log and get errors about not being able to determine if my user has permissions. I try to start the distribution manually, but it spins and then does not start, but gives no error.

I believe there is a user or permission problem somewhere, but because the documentation on replication over a non-trusted connection is almost non-existent, I have no idea where to look for a solution.

Any and all help is greatly appreciated. ... if knowledge on this is not at hand, I would like to submit a MS ticket, but am not sure how to do so.
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Next
Reply
Map
View

Click here to load this message in the networking platform