(Error 1231) OLE DB provider “SQLNCLI” for linked server “(null)”

Error: “ole db provider sqlncli for linked server null returned”
The following were the troublesome errors which I got two days back.

INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.

  1. SQL Server DBA “Interview Questions And Answers”
  2. SQL Azure Interview Questions and Answers Part – 1
  3. SQL Azure Interview Questions and Answers Part – 2
  4. Powershell Interview Questions and Answers

(Error 1231) OLE DB provider “SQLNCLI” for linked server “(null)” returned message “Login timeout expired”. [SQLSTATE 01000] (Error 7412) 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.”. [SQLSTATE 01000] (Error 7412)

Of-course this error says that the connection is failed but sometimes it says more than that. Contact your storage team if you get this kind of problem intermittently. We got our switch went offline intermittently and caused the whole issue.

Very Important Technical Wires:

  1. SQL Server DBA “Interview Questions And Answers”
  2. MS SQL Corruption: “Msg 2627 – Violation of PRIMARY KEY constraint”
  3. SQL Server 2008 R2 – Foreign Key – DELETE CASCADE and DELETE UDPATE
  4. MSSQL Server – DBCC LOGINFO – Status 2. Log File FULL. Verify log_reuse_wait_desc
  5. SSRS Report – Adding Header and Footer

Regards,
http://tuitionaffordable.webstarts.com

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s