Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked server provider is not accessable Expand / Collapse
Author
Message
Posted Friday, April 05, 2013 4:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 12:35 AM
Points: 4, Visits: 52
Hi,
I am using SQL SERVER 2005 Standard Edition 64 BIT with Service pack 3. From past few days I am facing a strange issue, whenever I am trying to expand the linked server provider details, one new active process is getting started which actually executing the system stored procedure xp_enum_oledb_providers(found through INPUTBUFFER) & is never getting completed.
Every time we restart the SQL services, for 5 - 10 mins the the providers can be accessed & then the same problem getting started. because of this all the queries is getting hanged which is using linked server.

Please help me with the solution. Thanks in advance.
Post #1439145
Posted Sunday, April 07, 2013 11:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 12:35 AM
Points: 4, Visits: 52
Hello all,

The issue got resolved . Actually the Dll xpstar.dll which is being called from the extended stored procedure xp_enum_oledb_providers got corrupted.
Post #1439685
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse