dbTalk Databases Forums  

Version may not valid Error ...

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


Discuss Version may not valid Error ... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sajith S
 
Posts: n/a

Default Version may not valid Error ... - 02-16-2004 , 09:59 AM






hi

Our SQL server is been installed with Service Pack 2 and
with some hotfixes( The MDAC version was MDAC 2.7 SP1
Refresh. The new patch for MDAC is applied on server in
January which was the last update to server. )

This server is used for OLAP purposes. User is using
Excel
to connect to Analysis Manager and retrieving the records
from the Cube.

After installing the service Pack 3, user was unable to
connect to the server. A error message comes which
includes MultiDimensional Connection Box Screen and
message box

(screen name : open connection failed) ...

"Unable to open connection. Cannot Load databases;version
may not be valid. Connection to the server is lost."

The above happens only if i use a user account. But using
a administrator account I am able to connect.

After trying many methodds, uninstalled SQLServer and
installed back SQL server with service Pack 2. Now i am
able to retrieve the data from Cube as a user.

I need to patch SQL server with service pack 3. Is the
above situation can be solved? Thanks in advance for any
help regarding this...

Regards
sajith s
..



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.