Intermitent Issue.
Jan 2, 2008
It appears I have an intermitent issue on the sql server. I have a query that insert data from AS400 to SS.
Joining 5 tables, these are processing tables and they are open for every customer rep. Today a dev tried running this query but it never finished then I ran it on my side and it took 1 min, told him it's Ok and he could run it now. He ran it and it worked. Then later he runs it again and it was taking 8 min and he cancelled it. Anyone know what is going on and how to troubleshoot it?
View 2 Replies
Mar 24, 2008
I have a replication Push Subscription configured that works most of the time but I get occasional errors satating that "The process could not connect to the Subscripber 'xxxx'". The details are
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
(Source: PYRRXNDAL341WIN (Data source); Error number: 18452)
This happens randomly and when it does fail, I can either what for the next occurence in the schedule or I can start the agent manually and it completes successfully. I can also ping the other box when it happens. I've looked at the event logs and don't see anything going on around the times the distribution agent is having the problems.
Any suggestions on where to start looking for more detail?
View 4 Replies
View Related
