Tuesday, 29 May 2012

The OLE DB provider "SQLNCLI10" for linked server reported an error. The provider ran out of memory.

Hi,
I opened SSRS after a long time and I got this error..hm..got exited to solve this error message.
Found out the root cause of this issue..it was with the linked server group...
I followed few steps, not sure which one actually resolved my issue. You may try any of these...

1. Clear Temp files
2. Delete some unwanted database from your SQL database on which linked servers are created
3. Backup database which are old (optional)
4. Restart all the SQL services in the SQL server configuration manager window

Viola..I was able to add linked servers again


Enjoy!

No comments:

Post a Comment