Error Deployiong Analysis Services Cube

Hi:

I am getting the following error when deploying the cube on my laptop.

"The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server."

I confirmed that all the services are running. Can you someone guide me here? This is the first time I am trying to deploy the cube in analysis services 2005. Please let me know.

Thanks

Try using machine name instead of the "localhost". Try connecting to your Analysis Server using SQL Management studio.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

sql

Error deploying Analysis Service Project

Hi,

We are following the Analysis Service Tutorial and when we tried to deploy we got these errors:

Error 1 OLE DB error: OLE DB or ODBC error: Login failed for user 'PASCAL\CEZAR$'.; 42000. 0 0
Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW', Name of 'Adventure Works DW'. 0 0
Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 4 Errors in the OLAP storage engine: An error occurred while the 'CalendarYear' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0
Error 5 OLE DB error: OLE DB or ODBC error: Login failed for user 'PASCAL\CEZAR$'.; 42000. 0 0
Error 6 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW', Name of 'Adventure Works DW'. 0 0
Error 7 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 8 Errors in the OLAP storage engine: An error occurred while the 'CalendarSemester' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0

We hope someone can help us.

Thanks a lot.

Hi Cezar. Your problem looks like the user PASCAL\CEZAR$ doesn't have access rights to the SQL Server source data, 'Adventure Works DW'. Check the access rights for 'Adventure Works DW' in SQL Server Manager, and verify that the user PASCAL\CEZAR$ has rights to the database.

Hope this helps - Paul Goldy

|||

Hi,

Thanks for your answer. The user error has been solved, but we got other error messages:

Error 1 OLE DB error: OLE DB or ODBC error: SELECT permission denied on object 'DimTime', database 'AdventureWorksDW', schema 'dbo'.; 42000. 0 0
Error 2 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 3 Errors in the OLAP storage engine: An error occurred while the 'EnglishMonthName' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0
Error 4 OLE DB error: OLE DB or ODBC error: SELECT permission denied on object 'DimTime', database 'AdventureWorksDW', schema 'dbo'.; 42000. 0 0
Error 5 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 6 Errors in the OLAP storage engine: An error occurred while the 'CalendarSemester' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0
Error 7 Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure. 0 0
Error 8 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 9 Errors in the OLAP storage engine: An error occurred while the 'CalendarYear' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0
Error 10 OLE DB error: OLE DB or ODBC error: Opera??o cancelada; HY008. 0 0
Error 11 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 12 Errors in the OLAP storage engine: An error occurred while the 'CalendarQuarter' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0

What can we do?

Yours, Cezar

|||

Hi Cezar. The error you received, "SELECT permission denied on object 'DimTime', database 'AdventureWorksDW', schema 'dbo'.; 42000. 0 0", is saying you do NOT have read permission for the AdventureWorksDW database. In SQL manager 2005 you must manage the permission for the AdventureWorksDW database and allow the user (I assume CEZAR\PASCAL$) db_datareader permission for the database. Here is a link which discusses more about setting permissions for SQL Server:

http://msdn2.microsoft.com/en-us/library/ms189121.aspx

Paul Goldy

error deploying analysis server cube

Has anyone ever received this message before?
"The Description element at line 3123, column 29 (namespace
http://schemas.microsoft.com/analys...ces/2003/engine) cannot appear
under
Envelope/Body/Execute/Command/Batch/Alter/ObjectDefinition/Database/Cubes/Cu
be/Dimensions/Dimension."
All I was doing was adding description to the properties of the dimension
tables. I was doing this so that the report user can see pop-up descriptions
in Report Builder.
I haven't been able to resolve this problem. Not only that - Now that I've
received this error, I haven't been able to reset the solution file so that
I
don't get this error. I have even removed all the description changes I
made, but to no avail.
Can anyone help me?
--JPThere are a couple of things you could try.
1) you could run Profiler while you are trying to deploy, this way you
would be able to capture the XMLA that is being sent to the server. You
would then be able to copy and paste the XMLA into a text editor and
search it. Maybe there is one change that you have missed undoing.
2) If all else fails, you could re-create your project from the database
on the server by starting a new project and choosing the "import
Analysis Services 9.0 database option"
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell
In article <16360AA6-10E3-4E75-9124-D939176CC1C2@.microsoft.com>,
Garza_JP@.discussions.microsoft.com says...
> Has anyone ever received this message before?
> "The Description element at line 3123, column 29 (namespace
> http://schemas.microsoft.com/analys...ces/2003/engine) cannot appear
> under
> Envelope/Body/Execute/Command/Batch/Alter/ObjectDefinition/Database/Cubes/
Cube/Dimensions/Dimension."
> All I was doing was adding description to the properties of the dimension
> tables. I was doing this so that the report user can see pop-up descriptio
ns
> in Report Builder.
> I haven't been able to resolve this problem. Not only that - Now that I've
> received this error, I haven't been able to reset the solution file so tha
t I
> don't get this error. I have even removed all the description changes I
> made, but to no avail.
> Can anyone help me?
> --JP
>

error creating offline cubes

Hi,
i want to create offline cubes in excel 2003 and receive
following error message:
Microsoft OLE DB Provider for Analysis Services:
Data source provider error.
The olap-database was created with SSABI 1.2, for example
with one dimension, one measure and one cube.
environment:
Win2000 Server
SQL Server 2000, SP3a, Analysis S. 2000 SP3a
Excel 2003
thanks for help,
markusI get the same error using MS Analysis Server on one of my data cubes.
(Others work). No other explanation. Very frustrating.
Jim
"markus krenn" <markus.krenn@.kis.co.at> wrote in message
news:8074337.0401140004.2a43461d@.posting.google.com...
> Hi,
> i want to create offline cubes in excel 2003 and receive
> following error message:
> Microsoft OLE DB Provider for Analysis Services:
> Data source provider error.
> The olap-database was created with SSABI 1.2, for example
> with one dimension, one measure and one cube.
> environment:
> Win2000 Server
> SQL Server 2000, SP3a, Analysis S. 2000 SP3a
> Excel 2003
> thanks for help,
> markus|||Hi Jim/ Markus,
I have the same error as you guys are having! Have you found a solution
to this error yet?
Thanks,
Natalie
Jim Fox wrote:[vbcol=seagreen]
> *I get the same error using MS Analysis Server on one of my data
> cubes.
> (Others work). No other explanation. Very frustrating.
> Jim
>
> "markus krenn" <markus.krenn@.kis.co.at> wrote in message
> news:8074337.0401140004.2a43461d@.posting.google.com...
Natalie
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message281094.html

Error creating Indexes in ROLAP based OLAP in Analysis Server 2005

Hi,

We are implementing OLAP based system in which the team has decided to use ROLAP as storage structure. But we are getting error while deploying the cube. The error is

OLE DB error: OLE DB or ODBC error: Cannot create index on view "Reporting.dbo.Agg_Fact Table_27_48_48_44_44_4" because it references derived table "dbo_Fact_Table" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

It seems that it has created a view that uses derived table and tries to create a clustered index on that. [Indexed View]. The above view definition contains derived table but as we know that the Indexed view can’t contain derived table. What is the workaround for this problem?

Thanks a lot for any advice.

Rakesh Mishra

Hi Rakesh

I got the same problem and can't find any solution. Did you find any workaround to solve the problem

Leo

|||

Hi,

I have experienced the same problem. Has this issue been resolved?

Thanks,

Bill

|||

I am sorry for *bumping* this one up, but I encounter the same problem on my project, so I wonder if there is a solution for it.

I would like to add that my project works well in MOLAP and does process completly without errors, switching to rolap gives the same message as the original poster has, with some different names and numbers for the tables and index columns of course.

Thanks

Ralf

|||

I have encountered this issue as well. I too wonder if there is a solution for this.

It appears to be only an issue when a particular attribute is used in an aggregation.

Error creating Indexes in ROLAP based OLAP in Analysis Server 2005

Hi,

We are implementing OLAP based system in which the team has decided to use ROLAP as storage structure. But we are getting error while deploying the cube. The error is

OLE DB error: OLE DB or ODBC error: Cannot create index on view "Reporting.dbo.Agg_Fact Table_27_48_48_44_44_4" because it references derived table "dbo_Fact_Table" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

It seems that it has created a view that uses derived table and tries to create a clustered index on that. [Indexed View]. The above view definition contains derived table but as we know that the Indexed view can’t contain derived table. What is the workaround for this problem?

Thanks a lot for any advice.

Rakesh Mishra

Hi Rakesh

I got the same problem and can't find any solution. Did you find any workaround to solve the problem

Leo

|||

Hi,

I have experienced the same problem. Has this issue been resolved?

Thanks,

Bill

|||

I am sorry for *bumping* this one up, but I encounter the same problem on my project, so I wonder if there is a solution for it.

I would like to add that my project works well in MOLAP and does process completly without errors, switching to rolap gives the same message as the original poster has, with some different names and numbers for the tables and index columns of course.

Thanks

Ralf

|||

I have encountered this issue as well. I too wonder if there is a solution for this.

It appears to be only an issue when a particular attribute is used in an aggregation.

Error creating Indexes in ROLAP based OLAP in Analysis Server 2005

Hi,

We are implementing OLAP based system in which the team has decided to use ROLAP as storage structure. But we are getting error while deploying the cube. The error is

OLE DB error: OLE DB or ODBC error: Cannot create index on view "Reporting.dbo.Agg_Fact Table_27_48_48_44_44_4" because it references derived table "dbo_Fact_Table" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

It seems that it has created a view that uses derived table and tries to create a clustered index on that. [Indexed View]. The above view definition contains derived table but as we know that the Indexed view can’t contain derived table. What is the workaround for this problem?

Thanks a lot for any advice.

Rakesh Mishra

Hi Rakesh

I got the same problem and can't find any solution. Did you find any workaround to solve the problem

Leo

|||

Hi,

I have experienced the same problem. Has this issue been resolved?

Thanks,

Bill

|||

I am sorry for *bumping* this one up, but I encounter the same problem on my project, so I wonder if there is a solution for it.

I would like to add that my project works well in MOLAP and does process completly without errors, switching to rolap gives the same message as the original poster has, with some different names and numbers for the tables and index columns of course.

Thanks

Ralf

|||

I have encountered this issue as well. I too wonder if there is a solution for this.

It appears to be only an issue when a particular attribute is used in an aggregation.

Error creating Indexes in ROLAP based OLAP in Analysis Server 2005

Hi,

We are implementing OLAP based system in which the team has decided to use ROLAP as storage structure. But we are getting error while deploying the cube. The error is

OLE DB error: OLE DB or ODBC error: Cannot create index on view "Reporting.dbo.Agg_Fact Table_27_48_48_44_44_4" because it references derived table "dbo_Fact_Table" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

It seems that it has created a view that uses derived table and tries to create a clustered index on that. [Indexed View]. The above view definition contains derived table but as we know that the Indexed view can’t contain derived table. What is the workaround for this problem?

Thanks a lot for any advice.

Rakesh Mishra

Hi Rakesh

I got the same problem and can't find any solution. Did you find any workaround to solve the problem

Leo

|||

Hi,

I have experienced the same problem. Has this issue been resolved?

Thanks,

Bill

|||

I am sorry for *bumping* this one up, but I encounter the same problem on my project, so I wonder if there is a solution for it.

I would like to add that my project works well in MOLAP and does process completly without errors, switching to rolap gives the same message as the original poster has, with some different names and numbers for the tables and index columns of course.

Thanks

Ralf

|||

I have encountered this issue as well. I too wonder if there is a solution for this.

It appears to be only an issue when a particular attribute is used in an aggregation.

Error connecting to remote SQL Server Analysis Services

Hi All,

I am trying to connect to the SQL Server Analysis Services on a remote server from my local machine, using SQL Server Management Studio.

I am able to connect to the SQL Server Database engine, but while connecting to the SQL Server Analysis services I get the following error :-

"Cannot connect to <IP Address>

A Connection cannot be made. Ensure that the server is running.

(Microsoft.AnalysisServices.AdomdClient)

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connection host has failed to respond(System)"

Things I have tried:-

- Ensured that the remote connection is enabled.

- Have SQL Server 2005 SP1 installed on the remote server.

- Tried installined SQL Server 2005 SP2 on my local machine, but same error.

I think some issue with the ports might exists, Dont have an exact idea of how to check on with the port settings.

Any kind of help will be appreciated on this.

Regards,

Sumeet:-)

We had similar problems when deploying cubes (although running Vanilla - not SP1)

We could replicate this problem by doing the following

1) Ensure all of the SQL Server Services (inc Analysis Services) are running

2) Browse a cube on your local machine

3) Rebuild this cube on your local machine

4) Check back on the remote server to see if AS is still running

If your issue is the same as ours, AS will no longer be running and there will be errors in the Application event log which read the following

"

The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\CubeTest.0.db\Data Warehouse.8.cub.xml is not a disk file or file is not accessible..

"

We found upgrading to SP2 stopped this issue

|||

Hi,

Nice to see your reply.

The issue that I am actually facing is not related to the cube, since I am not able connect to the Analysis services from my local machine, so their's no chance for me to browse a cube.

Are you able to connect to the remote Analysis services using SQL Server management studio on your lcoal machine? I am not able to achieve this and getting the error here itself...

Regards,

Sumeet

|||

hi

did you check the security settings of the analysis server? (right click -> properties-> security)

add 'everyone' to it and try again for testing. i believe you should put your active directory user in it

for http connectivity, the default port number of analysis services is 2383

hope this helps

|||

Hi Christina,

I have checked with the security settings, and I have the active directory user added into it, also I tried adding 'everyone' to the list, but still I am getting the same error.

Regarding the port no, Can you please let me know where exactly we need to check with the port nos., since I havent made any changes to the port no of Analysis services.

Regards,

Sumeet

|||hi, i had the same problem on my local machine, where i was running sql server 2000 and sql2k service pack 3 installed. noone could browse my cubes. I read somewhere that when installing sp 3, it changes some user roles. i can give you a clue, i am not sure that it will work for you, but it worked for me:

i have reinstalled Analysis services once again on another computer which was running win xp sp2. After that i installed sql2k sp 4, before, and not sql2k sp 3. This made it work

good luck
|||

Hi Vali,

I am using SQL Server 2005 on both my remote and local server, Also I have SP1 installed on both of my machines and it doesnt works.

Later on I installed SP2 on my local machine and still I am getting the same error.

Regards,

Sumeet.

|||

In the SQL Server Surface Area Configuration tool the instance of Analysis Services might be set to Local Connections Only.

Can you even ping the remote machine from your local machine? Are you specifying a named instance when connecting?

|||

Hi John,

I have Local and Remote Connections selected in the SQL Server Surface Area Configuration,

Also I am able to connect to the Database engine from my local machine to the Remote server using a SQL Server Authentication, but in Analysis services, theirs no option to login using SQL Server Authentication, and using Windows Authentication I am getting the above mentioned error.

Regards,

Sumeet

|||

Have you resolved this issue? We are experiencing the same problem. We can connect to the Database Engine but are no longer able to connect remotely to the Analysis Services.

Thanks in advance.

Sarah Cameron - Incycle Software

|||

The port setting for Analysis Service is configured in the 'msmdredir.ini' file that should be located in your '\Program Files\Microsoft SQL Server\90\Shared\ASConfig' directory. You should see a section at the bottom of the configuration settings for your specific instance with the name and the port number:

<Instances>
<Instance>
<Name>SQL2005</Name>
<Port>2194</Port>
</Instance>
</Instances>

|||

Hi Sarah,

We actually are not yet able to find a fool proof solution for this, but found that it makes connection using the full doamin name. again this behavior is not consistent for each and every machine.

So still waiting for help..

Regards,

Sumeet

|||

Thanks for the response. We were able to get our connection back yesterday evening. I think it had to do with some domain name resolution and active directory account authentication issues. The weird thing was that it was only affecting the Analysis Services and we were still able to connect to the Database Services. Sorry I can't be of more help in detailing why it is working again.

__

Sarah Cameron - Incycle Software

Error connecting to remote SQL Server Analysis Services

Hi All,

I am trying to connect to the SQL Server Analysis Services on a remote server from my local machine, using SQL Server Management Studio.

I am able to connect to the SQL Server Database engine, but while connecting to the SQL Server Analysis services I get the following error :-

"Cannot connect to <IP Address>

A Connection cannot be made. Ensure that the server is running.

(Microsoft.AnalysisServices.AdomdClient)

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connection host has failed to respond(System)"

Things I have tried:-

- Ensured that the remote connection is enabled.

- Have SQL Server 2005 SP1 installed on the remote server.

- Tried installined SQL Server 2005 SP2 on my local machine, but same error.

I think some issue with the ports might exists, Dont have an exact idea of how to check on with the port settings.

Any kind of help will be appreciated on this.

Regards,

Sumeet:-)

We had similar problems when deploying cubes (although running Vanilla - not SP1)

We could replicate this problem by doing the following

1) Ensure all of the SQL Server Services (inc Analysis Services) are running

2) Browse a cube on your local machine

3) Rebuild this cube on your local machine

4) Check back on the remote server to see if AS is still running

If your issue is the same as ours, AS will no longer be running and there will be errors in the Application event log which read the following

"

The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\CubeTest.0.db\Data Warehouse.8.cub.xml is not a disk file or file is not accessible..

"

We found upgrading to SP2 stopped this issue

|||

Hi,

Nice to see your reply.

The issue that I am actually facing is not related to the cube, since I am not able connect to the Analysis services from my local machine, so their's no chance for me to browse a cube.

Are you able to connect to the remote Analysis services using SQL Server management studio on your lcoal machine? I am not able to achieve this and getting the error here itself...

Regards,

Sumeet

|||

hi

did you check the security settings of the analysis server? (right click -> properties-> security)

add 'everyone' to it and try again for testing. i believe you should put your active directory user in it

for http connectivity, the default port number of analysis services is 2383

hope this helps

|||

Hi Christina,

I have checked with the security settings, and I have the active directory user added into it, also I tried adding 'everyone' to the list, but still I am getting the same error.

Regarding the port no, Can you please let me know where exactly we need to check with the port nos., since I havent made any changes to the port no of Analysis services.

Regards,

Sumeet

|||hi, i had the same problem on my local machine, where i was running sql server 2000 and sql2k service pack 3 installed. noone could browse my cubes. I read somewhere that when installing sp 3, it changes some user roles. i can give you a clue, i am not sure that it will work for you, but it worked for me:

i have reinstalled Analysis services once again on another computer which was running win xp sp2. After that i installed sql2k sp 4, before, and not sql2k sp 3. This made it work

good luck
|||

Hi Vali,

I am using SQL Server 2005 on both my remote and local server, Also I have SP1 installed on both of my machines and it doesnt works.

Later on I installed SP2 on my local machine and still I am getting the same error.

Regards,

Sumeet.

|||

In the SQL Server Surface Area Configuration tool the instance of Analysis Services might be set to Local Connections Only.

Can you even ping the remote machine from your local machine? Are you specifying a named instance when connecting?

|||

Hi John,

I have Local and Remote Connections selected in the SQL Server Surface Area Configuration,

Also I am able to connect to the Database engine from my local machine to the Remote server using a SQL Server Authentication, but in Analysis services, theirs no option to login using SQL Server Authentication, and using Windows Authentication I am getting the above mentioned error.

Regards,

Sumeet

|||

Have you resolved this issue? We are experiencing the same problem. We can connect to the Database Engine but are no longer able to connect remotely to the Analysis Services.

Thanks in advance.

Sarah Cameron - Incycle Software

|||

The port setting for Analysis Service is configured in the 'msmdredir.ini' file that should be located in your '\Program Files\Microsoft SQL Server\90\Shared\ASConfig' directory. You should see a section at the bottom of the configuration settings for your specific instance with the name and the port number:

<Instances>
<Instance>
<Name>SQL2005</Name>
<Port>2194</Port>
</Instance>
</Instances>

|||

Hi Sarah,

We actually are not yet able to find a fool proof solution for this, but found that it makes connection using the full doamin name. again this behavior is not consistent for each and every machine.

So still waiting for help..

Regards,

Sumeet

|||

Thanks for the response. We were able to get our connection back yesterday evening. I think it had to do with some domain name resolution and active directory account authentication issues. The weird thing was that it was only affecting the Analysis Services and we were still able to connect to the Database Services. Sorry I can't be of more help in detailing why it is working again.

__

Sarah Cameron - Incycle Software

Error connecting to remote SQL Server Analysis Services

Hi All,

I am trying to connect to the SQL Server Analysis Services on a remote server from my local machine, using SQL Server Management Studio.

I am able to connect to the SQL Server Database engine, but while connecting to the SQL Server Analysis services I get the following error :-

"Cannot connect to <IP Address>

A Connection cannot be made. Ensure that the server is running.

(Microsoft.AnalysisServices.AdomdClient)

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connection host has failed to respond(System)"

Things I have tried:-

- Ensured that the remote connection is enabled.

- Have SQL Server 2005 SP1 installed on the remote server.

- Tried installined SQL Server 2005 SP2 on my local machine, but same error.

I think some issue with the ports might exists, Dont have an exact idea of how to check on with the port settings.

Any kind of help will be appreciated on this.

Regards,

Sumeet:-)

We had similar problems when deploying cubes (although running Vanilla - not SP1)

We could replicate this problem by doing the following

1) Ensure all of the SQL Server Services (inc Analysis Services) are running

2) Browse a cube on your local machine

3) Rebuild this cube on your local machine

4) Check back on the remote server to see if AS is still running

If your issue is the same as ours, AS will no longer be running and there will be errors in the Application event log which read the following

"

The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\CubeTest.0.db\Data Warehouse.8.cub.xml is not a disk file or file is not accessible..

"

We found upgrading to SP2 stopped this issue

|||

Hi,

Nice to see your reply.

The issue that I am actually facing is not related to the cube, since I am not able connect to the Analysis services from my local machine, so their's no chance for me to browse a cube.

Are you able to connect to the remote Analysis services using SQL Server management studio on your lcoal machine? I am not able to achieve this and getting the error here itself...

Regards,

Sumeet

|||

hi

did you check the security settings of the analysis server? (right click -> properties-> security)

add 'everyone' to it and try again for testing. i believe you should put your active directory user in it

for http connectivity, the default port number of analysis services is 2383

hope this helps

|||

Hi Christina,

I have checked with the security settings, and I have the active directory user added into it, also I tried adding 'everyone' to the list, but still I am getting the same error.

Regarding the port no, Can you please let me know where exactly we need to check with the port nos., since I havent made any changes to the port no of Analysis services.

Regards,

Sumeet

|||hi, i had the same problem on my local machine, where i was running sql server 2000 and sql2k service pack 3 installed. noone could browse my cubes. I read somewhere that when installing sp 3, it changes some user roles. i can give you a clue, i am not sure that it will work for you, but it worked for me:

i have reinstalled Analysis services once again on another computer which was running win xp sp2. After that i installed sql2k sp 4, before, and not sql2k sp 3. This made it work

good luck
|||

Hi Vali,

I am using SQL Server 2005 on both my remote and local server, Also I have SP1 installed on both of my machines and it doesnt works.

Later on I installed SP2 on my local machine and still I am getting the same error.

Regards,

Sumeet.

|||

In the SQL Server Surface Area Configuration tool the instance of Analysis Services might be set to Local Connections Only.

Can you even ping the remote machine from your local machine? Are you specifying a named instance when connecting?

|||

Hi John,

I have Local and Remote Connections selected in the SQL Server Surface Area Configuration,

Also I am able to connect to the Database engine from my local machine to the Remote server using a SQL Server Authentication, but in Analysis services, theirs no option to login using SQL Server Authentication, and using Windows Authentication I am getting the above mentioned error.

Regards,

Sumeet

|||

Have you resolved this issue? We are experiencing the same problem. We can connect to the Database Engine but are no longer able to connect remotely to the Analysis Services.

Thanks in advance.

Sarah Cameron - Incycle Software

|||

The port setting for Analysis Service is configured in the 'msmdredir.ini' file that should be located in your '\Program Files\Microsoft SQL Server\90\Shared\ASConfig' directory. You should see a section at the bottom of the configuration settings for your specific instance with the name and the port number:

<Instances>
<Instance>
<Name>SQL2005</Name>
<Port>2194</Port>
</Instance>
</Instances>

|||

Hi Sarah,

We actually are not yet able to find a fool proof solution for this, but found that it makes connection using the full doamin name. again this behavior is not consistent for each and every machine.

So still waiting for help..

Regards,

Sumeet

|||

Thanks for the response. We were able to get our connection back yesterday evening. I think it had to do with some domain name resolution and active directory account authentication issues. The weird thing was that it was only affecting the Analysis Services and we were still able to connect to the Database Services. Sorry I can't be of more help in detailing why it is working again.

__

Sarah Cameron - Incycle Software

Error connecting Excel to Analysis Service for browsing cube

I have created a cube. Now when I open excel so that to browse the cube in the excel pivot table i am getting connection refused error? I am using olap 9.0 to connect to my cube which is deployed on the sqlserver 2005 analysis server. server is up and running.ok i found the solution. we need to reregister the olap 9.0 provider before we can use it to connect SQL Server 2005 Analysis Service Cube with Excel Pivot Table :
regsvr32 "c:\program files\common files\system\ole db\msolap90.dll"|||

Hi,

I having the similar problem with you. But no sure whether your error message is same with me. Here i get the error message as below:

Connection Failed

SQL State: '28000'

SQL Server Error: 18456

[Microsoft][ODBC SQL Server][SQL Server] Login failed for user 'domain\userida'

I am using olap services 8.0 & sqlserver 2000.

I checked this userida is properly created in the cube under a cube role said 'Accounts'. This role contain of abt 6 user id. Others user id is work fine except for this userida.

Any ideas to solve this issue.

Thanks in advance.

Error Code = 0xC1000012 in SQL 2005 Analysis Services

i get the above mentioned "Error Code = 0xC1000012" when processing OLAP database,pls do let me know what i can do to process OLAP databases without any errorregards,Duwara

What stage of the database processing did you get this error?

Is there textual description?

Can you try and run SQL Profiler against Analysis Server and capture trace while processing?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Error Code = 0x8007000E, External Code = 0x00000000: Exception when deploying the SSAS

Hi
I am getting this error when deploying the Analysis Services Project.

Error Code = 0x8007000E, External Code = 0x00000000:

Can anyone Point me the reason for the same?

Thankyou
Vidya
Test your connection, if it's OK, delete your AS database and deploy it again.

Error Code = 0x8007000E, External Code = 0x00000000: Exception when deploying the SSAS

Hi
I am getting this error when deploying the Analysis Services Project.

Error Code = 0x8007000E, External Code = 0x00000000:

Can anyone Point me the reason for the same?

Thankyou
Vidya
Test your connection, if it's OK, delete your AS database and deploy it again.

Error browsing Analysis Services Tutorial cube

Hi. I have two instances of SQL Server installed. One is unnamed and refers to a SQL Server 2000 installation. The other one is named PEDRO\SQLDEV2005 and refers to a SQL Server 2005 installation. I was going through the MSAS tutorial and when I was trying to browse the cube the following error occurred:

The query could not be processed: o Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'PEDRO' server. o Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'PEDRO' server.

The problem is that my server name isn't PEDRO, but PEDRO\SQLDEV2005. Where do I change the server name?

Pedro Martins

Portugal

The error message is correct. You might be running several instances of Analysis Sever on your machine. But you have a single SQL Browserver service that serves them all.

Try and see if SQL Browser service is started. Do you have connectivity to the Domain controller? There is known issue with accessing named instace is case if domain controller is unavailable.

See if you can connect to Analysis Server using SQL Management studio.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.