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
add comment

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.