October 22, 2010 at 2:59 am
When trying to execute the procedure getting the below error
OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "(null)" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [53].
can you please tell me what should be the problem. till 2 days back it was running fine. since yesterday it was giving this error and i hope there should be some connectivity issues somewhere.
Regards,
Naveen
October 22, 2010 at 3:33 am
the problem is with linked server which you are using in your query. Check either linked server working properly or not.
----------
Ashish
October 22, 2010 at 3:37 am
checked the linked servers andall running fine
October 22, 2010 at 3:42 am
what is your query?
Also go in ssms--serverobjects--linked server--expand your linked server cataloges.
Are you able to see the database and tables in expansion, if so then right click on table and script for select statement.
you will see the proper name of your linked server in query. Use the same name in your query.
----------
Ashish
October 22, 2010 at 3:45 am
Enable TCP/IP protocol on SQL Configuration.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 22, 2010 at 3:58 am
Try pinging to the other server and make sure network is fine. The next step would be to check if any of your linked server settings has changed. Also make sure the user permission has not been changed on the linked server. This should resolve the issue.
If nothing works you might want to create a separate linked server and test.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply