sql-server-2012ssascubebidssql-server-2012-datatools
SQL SSAS Cube Deploy Error:
I am trying to deploy a cube I created in SQL Server Data Tool using AdventureWorksDW2008R2, I used windows authentication login the database engine with all permissions granted to it. and yet I still get these arrors in the picture below when deploying the cube. Anyone Can point out which part is wrong here?
Solution
May I know which option in the Data Source designer did you choose before deployment?
Note that based on the page below, even if your account has access to the database, you cannot use ImpersonateCurrentUser option.
https://msdn.microsoft.com/en-us/library/ms189027.aspx
Have you tried using the "Use a specific username and password" and entering the login details?
- No authorized routine named "GETVARIABLE" of type "FUNCTION" having compatible arguments was found
- Isolation Level for stored procedure SQL Server?
- Using joins and if statements
- How to retrieve an image from database and show it in asp image box with a click of a button?
- Use of MERGE reserved keyword in different versions of SQL Server
- Create Table Throws a TextImage Error On Creation
- Email alert when field meets certain condition
- Select between two months
- ANSI_NULLS and QUOTED_IDENTIFIER killed things. What are they for?
- JTDS driver not working for Sql Server 2008R2 and Denali Native SSPI library not loaded. Check the java.library.path system property
- Stumped on a complex GROUP BY
- How can I determine if a Sequence exist in SQL Server 2012?
- Set SQLCmd variables based on configuration
- SQL Prime number function
- Refer to original value within CASE statement
- Best way to generate ticket number that resets daily
- Query all table data and index compression
- Stop SQL Server from running until needed
- Unable to compare a string with a UNIQUEIDENTIFIER
- Reliable way to retrieve all UNIQUEIDENTIFIER values from all columns
- How can I optimize a SQL query to efficiently count non-blank column values without using a cursor?
- Multiple repetitive tables
- Take data from Lead Record when condition or filter criteria matches and ignore the records between current row and selected record (lead row)
- Calculate end date of partition rows using start date of following partition
- Delimit using PARSENAME returning null - SQL Server
- Auto increment primary key in SQL Server Management Studio 2012
- How do I convert a float to varchar without loss of decimal places? SQL Server 2012
- Cant see the sysssislog table on SQL Server after enabling logging on the package
- How to export database with data in MSSQL?
- Turns rows into columns