Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Within the last week, I've gotten the following error when trying to use a linked server in SSMS (tried 2008 and 2012) to connect to a SSAS 2008 R2 instance on our cluster:

Cannot set initialization properties for OLE DB provider 'MSOLAP' for linked server .... returned message "The following system error occurred: ." (Microsoft SQL Server, Error: 7373)

It's not related to my login, because I can use it fine from other servers as well as SQL agent jobs. Found some googling suggesting a DNS issue, but using linked servers with the fully-qualified name as well as IP address doesn't make a difference. Ports are open and listening on the server, and "Allow Inprocess" is enabled for MSOLAP on both SSMS 2008 & 2012.

My machine is Win7. I've been testing from Win2008 servers; other machines with Win7 do not have this issue.

I see a few hits on the web about this issue but ZERO about resolutions. Anyone have any ideas what else I can try?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.