<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Lined server connection issue
Lined server connection issue
Rate Topic
Display Mode
Topic Options
Author
Message
catchmekiran
catchmekiran
Posted Wednesday, October 10, 2012 9:21 PM
Grasshopper
Group: General Forum Members
Last Login: Sunday, April 21, 2013 6:19 PM
Points: 18,
Visits: 77
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.
Post #1371191
chandan_jha18
chandan_jha18
Posted Thursday, October 11, 2012 2:19 AM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 7:35 AM
Points: 408,
Visits: 1,666
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
Post #1371273
catchmekiran
catchmekiran
Posted Thursday, October 11, 2012 11:24 AM
Grasshopper
Group: General Forum Members
Last Login: Sunday, April 21, 2013 6:19 PM
Points: 18,
Visits: 77
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
Post #1371693
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
