dbTalk Databases Forums  

Connection String Problem

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Connection String Problem in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kevin Schulhof
 
Posts: n/a

Default Connection String Problem - 05-14-2005 , 03:39 PM






We are running SQL Server 2000 Enterprise edition with Analysis Services. On
top of it we're using OutlookSoft (Everest) to query the data.

A strange issue occured in that Registry's two keys
(RemoteRepositoryConnectionString and Repository Connection String) have
ceased functioning. Therefore, the Analysis Server cannot use that value to
connect.

If I go into the Analysis Server Manager and right click on connection
string I can manually put in the value and connect to the cube.
Unfortunately, that value does not stick and does not update the registry.
I've tried to modify the registry key with the exact same text that works in
Analysis Manager but it will not connect.

This has created a situation where the application (Everest) cannot use the
Registry Key to sucessfully connect and it will therefore not work.

Any ideas on how to correct this? A very frustrating situation. If I
cannot recover I imagine I'll have to reinstall everything.

Thanks for any ideas!!!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.