Microsoft KB Archive/928314

= Error message when you use Decision Support Objects (DSO) in SQL Server 2005 Analysis Services: &quot;Cannot connect to the repository Login failed for user ''&quot; =

Article ID: 928314

Article Last Modified on 11/22/2006

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-



SYMPTOMS
Consider the following scenario. You configure Microsoft SQL Server 2005 Analysis Services to use Decision Support Objects (DSO) together with a repository database. The repository database is in an instance of SQL Server 2005. To connect to the instance of SQL Server 2005, you use SQL Server Authentication, and you specify a password. In this scenario, you receive the following error message when you use DSO in Analysis Services:

Cannot connect to the repository

Login failed for user ' '



CAUSE
To connect to the instance of SQL Server 2005, DSO obtains a connection string. This problem occurs because this connection string does not contain the password.



WORKAROUND
To work around this problem, follow these steps:
 * 1) Configure the RepositoryConnectionString connection string or the RemoteRepositoryConnectionString connection string to use Windows Authentication.

Note If the instance of SQL Server 2005 runs locally, configure the RepositoryConnectionString connection string. If the instance of SQL Server 2005 runs remotely, configure the RemoteRepositoryConnectionString connection string.
 * 1) Add the users who use DSO to connect to the instance of SQL Server 2005 to the db_owner database role.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
For security reasons, the value of the DSO\RepositoryConnectionString property and the value of the DSO\RemoteRepositoryConnectionString property are encrypted in Analysis Services. When you use DSO in Analysis Services to connect to the instance of SQL Server 2005, the Analysis Services engine returns a connection string that does not contain the password. DSO cannot use a connection string that does not contain the password to connect to the instance of SQL Server 2005.

Keywords: kberrmsg kbtshoot kbprb kbexpertiseadvanced kbsql2005as kbsql2005bi KB928314

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.