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 - 2011-01-06 : 22:39:50
|
| Hi,We are running SQL server 2005 with SP2 with linked server to SSAS cube which is deployed in SSAS server of the same ( Windows) server. For SSAS we have following security "Be made using the logins current security context" with local login which is having windows authentication to target server. Sometimes we are getting with these error but not always Msg 7302, Level 16, State 1, Line 2 Cannot create an instance of OLE DB provider "MSOLAP" for linked server "SFE_Cube". After restarting with SQL server services the issue will get resolved. Can please suggest me how to trace with this error.Thanks, GangaThanks,Gangadhara MSSQL Developer and DBA |
|
|
|
|
|
Frequent linked server drop out