When I try to register the local OLAP server in Analysis Manager I receive
the following error dialog:

Connection to Server Failed

Errors occurred while connecting to <server name>
Cannot connect to the repository.

Annalysis server : <server name>

Error: Not a valid account name or password.
Do you still want to register this server?

I am a local administrator and am a member of the OLAP Administrators group.
When I use the MDX sample application I am able to connect to the servers
and query the data.
This started happening on a production server so I installed Analysis
Services on my local machine yesterday and I am receiving the same error.

I am also getting this event in the event log sometimes (not every time that
I have the failed connection attempt).

Event Type: Error
Event Source: MSSQLServerOLAPService
Event Category: Server
Event ID: 124
Date: 2005-06-01
Time: 05:30:07 PM
User: N/A
Computer: JGRUNDY1
Description:
Relational data provider reported error: [Not a valid account name or
password.;3029].

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


I am not sure if this is related.

Event Type: Error
Event Source: MSSQLServer
Event Category: (8)
Event ID: 19011
Date: 2005-06-01
Time: 05:18:17 PM
User: N/A
Computer: JGRUNDY1
Description:
SuperSocket info: ConnectionListen(Shared-Memory (LPC)) : Error 5.


--
Jeff

First, make sure you have installed SP3 for Analysis Services (there are two
distributions of SP3 -- one for the RDBMS; one for Analysis Services).

Second, make sure you are using a domain account; particularly if trying to
register a machine remotely. That domain name must be in the OLAP
Administrators group on the Analysis server. Depending on what ACLs have
been put in place, the account might need to be a machine administrator
also.

Third, make sure you have a valid connection string on the server (both
local and remote), by running Analysis Manager, right-click on the server
and select "Edit Repository Connection String". It will show you both
connect strings (one which is used for the local machine; one for remote
users). Make sure ACLs are not in-place stopping access for domain users
which are trying to come in.

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Jeff Grundy" <JeffsGrundy (AT) nospam (DOT) nospam> wrote

Hi Jeff,

Welcome to use MSDN Managed Newsgroup!

From your descriptions, I understood you are not able to register AS Server
in the Analysis Manager with the error message "Error: Not a valid account
name or password". If I have misunderstood your concern, please feel free
to point it out.

Based on my knowledge, it seems you have added local administrator into
OLAP admin group and would you please let me know which account do you use
to log on the machine, local account or domain account?

It seems Jet provider is not properly installed on your machine. Please run
Component Checker below and then send the result.xml file to me. I would
like to check which file is not registered correctly and then let's
correctly register it.

MDAC Utility: Component Checker
http://www.microsoft.com/downloads/d...df6-4a21-4b43-
bf53-14332ef092c9&DisplayLang=en

I understand the information may be sensitive to you, my direct email
address is v-mingqc (AT) online (DOT) microsoft.com (please remember to remove
"online" before you click SEND as it's only for SPAM), you may send the
file to me directly and I will keep secure.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.

1) I installed the sp3 patch found at D:\ENGLISH\SQL2000\SP3A\MSOLAP\INSTALL
on MSDN dvd 2432.8

2) I am working woth the analysis server that is on my local machine. My
domain account is a member of the Administrators group and a member of the
OLAP administrators group.

3 When I open analysis manager there are no servers listed. When I try to
connect to a server I get the errors described in the original post.


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Hi Jeff,

The result.xml attached seems not the correct one. Do you follow the steps
below to get this file?

- In the Dialog Select "Perform analysis against a selected version."
- Select "MDAC 2.8 SP1 on Windows XP SP2" in the combo box
- Click OK

I could like to check specically what file type is MISMATCH.

Thank you for your patience and cooperation.


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Jeff,

Thanks for your attachment file.

It seems your MDAC is fairly healthy. Please re-register following two files

- MSJET40.DLL
- MSJETOLEDB40.DLL


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.

Hi, i have a slightly different problem happen.

my domain login are member of administrators and member of OLAP
administrator.

i have been installed SQL Analysis Service Pack 3.

SQL Server Service Manager running MSSQLServerOLAPService

When i register local server to Analysis Manager. i got this error
message


Errors occurred connecting to <Server Name>
Cannot connect to the repository

Analysis server:<Server Name>

Error:
Cannot open database requested in login 'OLAP_Repository'.Login fails.
Do you still want to register this server?



*** Sent via Developersdex http://www.developersdex.com ***

That fixed the problem.

"Michael Cheng [MSFT]" <v-mingqc (AT) online (DOT) microsoft.com> wrote