Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-12-12 : 21:13:00
|
| Dear Experts,We have linked server as a SSAS cube in the production server with SQL server 2005 SP2. Its using the windows authentication to connect by end user and The security tab in linked server properties having "BE MADE HAVING THE LOGINS CURRENT SECURITY CONTEXT" is there.My problem here is some time it will connect without any error and sometimes it thrown with an errorMsg 7302, Level 16, State 1, Line 2 Cannot create an instance of OLE DB provider "MSOLAP" for linked server "SFE_Cube".Post restart of SQL server services it works fine again,not very sure how to trace this error to fix.Your hep in this regard highly appreciated.Thanks,Ganga |
|
|
|
|
|
Frequent linked server drop out