Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Agent wont start
Message
From
27/08/2014 09:08:20
 
 
General information
Forum:
Microsoft SQL Server
Category:
Replication
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01606468
Message ID:
01606519
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.
>
>
>Quick question - can you check the windows event log on the server to see if any errors were captured?

Thank you for your response. I did get errors. They were all:

[298] SQL Server Error: 15404, could not obtain information about Windows NT group/user 'Server1\myuser', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
Log type: SQL Server Agent
Thank You

Rollin Burr

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

Click here to load this message in the networking platform