Dear All,
I Have two SQL Server ABC and XYZ and i have changed the SA password of both the servers.
I have added link server on the both the servers.
When i execute a link server query in a SQL Query Analyser on either server it works, but when i use the same query in a job, then it fails.
So anyone can help in the above problem.
Regards,
VinayakThe sql server service accout needs to be granted authority|||Hello,
Can u help me in the same.......
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment