MS SQL Data Warehousing - Cant connect to Analysis Services remotely.

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Cant connect to Analysis Services remotely.

ChrisR

2006-03-16, 8:23 pm

Howdy all. Im trying to connect to AS2000 remotely from my local Analysis
Manager on my desktop but keep getting a "path not found". I can connect
locally though. It started off as an Access DB and in efforts to fix my issue
I converted to a SQL DB. An important note would be that I can register the
regular SQL Server on this same box from my desktop using Enterprise Manager.
Here is a copy of my connection string, which all looks good to me:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Initia
l
Catalog=AnalysisServ
icesRepository;Data Source=MySQLServer\I
nstanceName;Use
Procedure for Prepare=1;Auto Translate=True;Packe
t Size=4096;Workstatio
n
ID=Node2OfMyCluster;
Use Encryption for Data=False;Tag with column collation
when possible=False

TIA, ChrisR

Sponsored Links