Errors while Deploying Analysis services projects in server

Hi,

I am using Sql server Business Intelligence Development Studio 2005 and SQL server Management studio.

I created a Analysis services project in the BI Dev Studio, and set the correct server attributes in the project properties -> deployment tab.

I have created a data source , then a datasource view and then cube and dimensions.

1) When I tried deploying with the database name as 'xyz'. (again set in the project properties -> database ,target attribute),

and the database 'xyz' is previously created and thus present in the Analysis server 2005. I get the following error:

"The database , 'xyz', contains an ImpersonationMode that is reserved for server administrators."

---

2.) When i tried deploying with the database name as 'abc'. (again set in the project properties -> database ,target attribute),

but NOTE now there is no analysis server database with the name 'abc' already existing in the analysis server. now I get the following error:

"Either the 'myUserName' user does not have permission to create a new object in 'myServerName', or the object does not exist."

I checked the Sql server management studio and under the 'xyz' analysis database in the 'Roles' Folder my username is a member of the Administrators who have full priliviges.

Please do tell me as to where I am going wrong.

Thanks and regards

Vijay R

Hi Vijay,

I had the same problem as you and found the following on http://www.eggheadcafe.com/forumarchives/SQLServerdatamining/Jun2005/post23396286.asp. Changing the impersonation mode to the service account sorted things out straight away for me, hopefully it'll do the same for you.

"The impersonation mode tells Anaylsis Server what credentials to use when connecting to the database specified in the datasource object. When you create the datasource using the Data Source Wizard, there's an "Impersonation Information" page where you can set this information. If the data source is used for processing (i.e. you are training mining structures/models from that data source), you are not allowed to set the ImpersonationMode to "Use the credentials of the current user" due to security considerations - you must either use the service account or use a specific username/password. You can change the impersonation mode by opening the data source in BI Dev Studio and selecting one of the allowed options above on the "Impersonation Information" tab."

Errors in the OLAP storage engine

Error 4

When I am deploying the project I got the following error. Please help me sir

Errors in the OLAP storage engine: An error occurred while processing the 'Product Tran Header' partition of the 'Product Tran Header' measure group for the 'Test' cube from the productreport database. 0 0

I did the following steps

1. added new measure selecting new source table

2. selected one column dateoforder

3. Add new dimension as without using data source

4. selected server time dimension

5. Selected Year/Month/Quarter/date

6 Selected fiscal year

7.Selected dimension usage in cube desgn

8. selected time dimension and selected regular relation, Granulary attribute as Date

9. Measure group table 'Product tran header' new measure group

10 selected measure group column as dateoforder.

after that while deploying the above mentioned error will come

Please help

Polachan,

How many partitions do you have in that measure group? Is it possible that you changed measure group structure, but some partitions have specific query that does not match new structure? If this is the case, review each partition query.

Vidas Matelis

|||

Hi All,

I am also facing the same problem when i process some dimensions with in a Cube Database.

Can Anyone please help me in resolving it .

Thanks,

Prashant

|||run a profiler and check the query that is fired to the DB. That will give you some clues.

Errors deploying and running reports

I am developing reports on my PC and deploying them to our server. My
PC only has reporting services client components while our server has
the client and server components installed.
Problem 1 :
when I deploy the solution to the server I get this error message:
"The underlying connection was closed: Could not establish trust
relationship with remote server."
Problem 2:
I have created a ASP.NET application on my PC that runs reports on the
server using the reporting service's web service. When I try and
render a report, I get this error message:
The request failed with HTTP status 404: Not Found.
Any help would really be appreciated
CraigIs your report server configured to use SSL? If so, you will need to use
FQDN (full domain name) of
the server in the report project's TargetServerURL property.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Craig HB" <craighb@.bigfoot.com> wrote in message
news:3ba2292b.0407130651.71bf5d0c@.posting.google.com...
> I am developing reports on my PC and deploying them to our server. My
> PC only has reporting services client components while our server has
> the client and server components installed.
> Problem 1 :
> when I deploy the solution to the server I get this error message:
> "The underlying connection was closed: Could not establish trust
> relationship with remote server."
> Problem 2:
> I have created a ASP.NET application on my PC that runs reports on the
> server using the reporting service's web service. When I try and
> render a report, I get this error message:
> The request failed with HTTP status 404: Not Found.
> Any help would really be appreciated
> Craig

Errors Deploying an SSIS package

Hi All,

I hope someone can help becuase this problem is issue us several headaches.

We are currently trying to deploy an SSIS package to a production server. The deployment goes fine, the package runs ok when executed manually. The issues start when we try and execute it under the SQL agent.

Having gone back to the drawing board and spent much of the day reading various articles and applying the various options (especially those within the MS KB article 918760), we are still no closer to a resolution.

The SSIS package was created under an Administrator, and the SQL agent runs under a different Domain Admin account.

When we set up the Schedule to read from SQL Server or the SSIS Store the standard "Executed as user: DOMAIN\USERNAME. The package execution failed. The step failed" in the history.

We tried to create the package as a file access and now get "Package could not be found" even though you can browse to i in the schedule list. The Domain account as full access to the folder where the package resides.

Has anyone else come across this issue, or have a workable solution?

Many TIA.

But does the SQL Server service account have access to everything? Not the Agent user, but the SQL Server service account?|||

Phil,

Thanks for the assist, adding access rights the SQL Server Account ot the database helped, and it seems to have fixed one issue in that it now adds the /Decrypt item to the when saved as EncryptWithPassword, and stores the information.

We have decided to run the package from the SQL server rather than a file, However we still get the same permission error when running the job in SQL agent.

Any more ideas?

|||

This KB article maqy help

http://support.microsoft.com/kb/918760

|||

Thanks for the Pointer Rafael, but we have already tried to apply the workrounds mentioned in the articles with no joy.

I'm coming to the conclusion that MS have really over done the security model for SSIS, I still pondering what the point of of the EncryptWithUserKey setting is as most jobs will generally need to be scheduled and run under the SQLAgent account.