Hi,
i am working with a XP-Client and try to connect to a WinServer2003, (SP2, AS2005) to access an AS2005-cube by Excel 2007. Creating a new connection, i can choose either connect via windows authentification or by entering a user/PW.
The first way (windows authentification) always works fine, but when i try to connect through an sql user, i run on an error at last. The connection works fine, i can select the desired cube but after the last "OK"-Button i get an error message like "Initialization of Data source failed".
the sql user should have admin right on the server.
Do i make sth. wrong?
SQL Server 2005 Analyisis Services Supports only Windows Authentication. (SQL Authentication is only possible if you connect to the SQL Server 2005 Database Engine)
So the username and password you want to enter must be a valid windows nt user with permission on the analysis services database. (check save password otherwise you get errors in excel)
HANNES
No comments:
Post a Comment