March 21, 2003 at 11:40 am
I have a server that does Pull subscriptions from about 20 servers, one of them keeps failing with
--------------
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. The process could not connect to Distributor 'Server'. The step failed.
-----------------
If I delete the pull, recreate it, it will work tomorrow, then fail again. Note this server is a little different then our usuals due to vendor requirements, but not terribly.
I'm at a loss.
KlK, MCSE
KlK
March 21, 2003 at 11:46 am
Check the job of the distribution agent in the subscriber, and see the parameters for the distrib.exe command. Check the values -DistributorSecurityMode and -SubscriberSecurityMode. If you autentication mode is SQL, check that you have the parameters of the SQL Login and pass. If it is Windows autentication mode, then think that it will run with the windows account that uses SQL server Agent.
What I do, is create a .cmd file calling distrib.exe with those parameters, so i can see all the info and errors messages.
March 24, 2003 at 6:56 am
To run the distrib.exe set the path or run from :
c:\"program files"\"microsoft sql server"\80\com\distrib.exe
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply