October 10, 2012 at 9:21 pm
We have a SQL job that run against all servers and find the 'server total and free drive space'. There are 7 steps in this job and steps 1, 2, 3 & 4 fails.The 1st step of this job is to verify connectivity to all servers. This steps run for 6 mins and fails..... All the other step errors are failing due to similar connection issues, so, if I can figure out step 1 then I will be able to solve other steps.I did test connection for the linked servers and and it fails......so, I think the issues are related to these linked server connections. I also checked, server properties/connections/remote connections.....is checked and the timeout is set to 600 seconds. So, I think that is fine.
October 11, 2012 at 2:19 am
First you need to make sure if the linked servers are working fine and you are able to test them before you use them in your T-SQL queries.
Right click on a linked server and click on 'Test connection' then see what error it throws you. We will take it from there.
Chandan
October 11, 2012 at 11:24 am
When I test the connection, giving me these errors
Login timeout expired
An error has occurred while establishing connection to the server
The error may be caused due to the fault that under the default settings SQL server does not allow remote connstep failedections.
For linked server x "communication link failure"
An error has occurred while connecting to SQL server2005
Step failed.
Thanks in advance
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply