?
Solved

I'm trying to create a new linked server but I get the following error message...can anyone tell me if I'm at least filling in the fields correctly?"

Posted on 2010-11-18
3
Medium Priority
?
253 Views
Last Modified: 2014-04-30
Hello,

I'm trying to create a new linked server but I get the following error message... can anyone tell me if I'm at least filling in the fields correctly?"
OLAP-Linked-Server-Screen-Shot.docx
0
Comment
Question by:VietSP
1 Comment
 
LVL 4

Accepted Solution

by:
pbarry1 earned 2000 total points
ID: 34178583
Hi,

you need to put the OLAP Server name in the "Data source" field, not in the "location" field.  The Catalog corresponds to the cube name.  Leave the "location" field blank.

Note: you might need to flag this provider to run in process ("Allow in process")  depending on your installation.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question