Hello, I have a problem creating a ADOMD connection from BSM 2005 to SSAS 2005. (Choosing standard connection) It seems like it's connecting but I cant choose "database name", or it does'nt list any database names. No error messages. When I click Cube name I get the error stating: The business scorecard manager server could not connect to the database. Verify that all data has been entered in the boxes and the connection info is correct.
Any suggestions?
// Richard
I suspect this is security-related problem.
Try and see how BSM connecting to Analysis Server. Run SQL Profiler against Analysis Server and see what is the name of the user establishing connection and if this user has any rights to access databases. I suspect BSM establishing conection under Anonymous user.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Edward,
I used the SQL Profiler and I can see that it is not me as the user who is trying to connect, so far so good but how can I change that. The NTUserName == Network Service.
Can you tell me how to change this?
Thank you,
Christian Lorenz
|||I added NT AUTHORITY/Authenticated Users to cube reader-role and then it worked.
No comments:
Post a Comment