error when trying to browse SSRS on a remote machine

Hi,

I deployed SSRS reports to my local report server and set the connection string to access a server on the network with Analysis Server.

Result:
I can access and use the reports from my computer. But when I use any other computer on the network I can't use the reports. I can access them but they don't find the database ant therefor they don't present any data.

Error message as folows: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'dsAnalys'. (rsErrorOpeningConnection) Get Online Help
Database 'Analys' does not exist. "

This works fine on my local machine, the error comes only when i try to browse on a remote machine. I am using SQL Server 2005

Any help would be appriciated!!!

Thanks in advance,

Chanduu

Can you access the database from a different PC using SQL Server Management Studio?

Possibly the server is not accessible from those PCs? Is it on a different domain?

|||yes, i am able to access|||

Chandu I am just trying to see what is causing this error.

1.) Do you have Shared Datasource in SSRS.

2.) While deploying to the remote server, make sure to include the right TargetServerUrl.

3.) On the Remote Server, go the Home folder and check for the DataSources if it has

a.) Enable this Data Source CheckBox checked.

b.) Connection string

c.) In the Connect Using: Check if the Credentials stored securely in the report server is Checked and the UserName and Password is given.

4.) Check for the permissions.

Hope this helps...

|||

Thanks a lot !!! friends .. I got answer for this error

Steps i followed to reslove this error

1. Goto http://<report server>/reports

2. Select the datasource folder

3. Check "Credentials stored in that report" and give valid user id and password

4. Check the check box"Use as windows credentials when connecting to datasource"

error when trying to browse SSRS on a remote machine

Hi,

I deployed SSRS reports to my local report server and set the connection string to access a server on the network with Analysis Server.

Result:
I can access and use the reports from my computer. But when I use any other computer on the network I can't use the reports. I can access them but they don't find the database ant therefor they don't present any data.

Error message as folows: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'dsAnalys'. (rsErrorOpeningConnection) Get Online Help
Database 'Analys' does not exist. "

This works fine on my local machine, the error comes only when i try to browse on a remote machine. I am using SQL Server 2005

Any help would be appriciated!!!

Thanks in advance,

Chanduu

Can you access the database from a different PC using SQL Server Management Studio?

Possibly the server is not accessible from those PCs? Is it on a different domain?

|||yes, i am able to access|||

Chandu I am just trying to see what is causing this error.

1.) Do you have Shared Datasource in SSRS.

2.) While deploying to the remote server, make sure to include the right TargetServerUrl.

3.) On the Remote Server, go the Home folder and check for the DataSources if it has

a.) Enable this Data Source CheckBox checked.

b.) Connection string

c.) In the Connect Using: Check if the Credentials stored securely in the report server is Checked and the UserName and Password is given.

4.) Check for the permissions.

Hope this helps...

|||

Thanks a lot !!! friends .. I got answer for this error

Steps i followed to reslove this error

1. Goto http://<report server>/reports

2. Select the datasource folder

3. Check "Credentials stored in that report" and give valid user id and password

4. Check the check box"Use as windows credentials when connecting to datasource"

sql

error when trying to browse SSRS on a remote machine

Hi,

I deployed SSRS reports to my local report server and set the connection string to access a server on the network with Analysis Server.

Result:
I can access and use the reports from my computer. But when I use any other computer on the network I can't use the reports. I can access them but they don't find the database ant therefor they don't present any data.

Error message as folows: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'dsAnalys'. (rsErrorOpeningConnection) Get Online Help
Database 'Analys' does not exist. "

This works fine on my local machine, the error comes only when i try to browse on a remote machine. I am using SQL Server 2005

Any help would be appriciated!!!

Thanks in advance,

Chanduu

Can you access the database from a different PC using SQL Server Management Studio?

Possibly the server is not accessible from those PCs? Is it on a different domain?

|||yes, i am able to access|||

Chandu I am just trying to see what is causing this error.

1.) Do you have Shared Datasource in SSRS.

2.) While deploying to the remote server, make sure to include the right TargetServerUrl.

3.) On the Remote Server, go the Home folder and check for the DataSources if it has

a.) Enable this Data Source CheckBox checked.

b.) Connection string

c.) In the Connect Using: Check if the Credentials stored securely in the report server is Checked and the UserName and Password is given.

4.) Check for the permissions.

Hope this helps...

|||

Thanks a lot !!! friends .. I got answer for this error

Steps i followed to reslove this error

1. Goto http://<report server>/reports

2. Select the datasource folder

3. Check "Credentials stored in that report" and give valid user id and password

4. Check the check box"Use as windows credentials when connecting to datasource"

error when processing cubes just migrated from 2000 to 2005

im in the process of testing how to upgrade from analysis server 2000 to analysis server 2005. i have migrated my cubes to a test 2005 server and created a project out of them. when i try to deploy this project i get these two errors:

Error 1 OLE DB error: OLE DB or ODBC error: The multi-part identifier "PrintDimensionTransactionDate.TransactionDate" could not be bound.; 42000. 0 0

Error 2 Errors in the OLAP storage engine: An error occurred while processing the 'Print' partition of the 'Print' measure group for the 'Print' cube from the testSRDBProj database. 0 0

these cubes worked fine before i migrated them. does anyone know what could be going wrong?

Hi Winston,

It looks like it has deployed the cube, but is failing in processing it. Is there a table called PrintDimensionTransactionDate with a column of TransactionDate? This doesn't sound right. Also when processing the cube you can get the SQL query that Analysis Services is using, that may lend a clue to what is wrong with this Dimension or measure group.

David

|||yea, there is a table called printdimensionTransactionDate and there is a column called transactiondate. the table contains the full date, and also a break down of the date ( i.e fiscal month num of the date, fiscal week num of the date, etc). how do you get the query? is that by right clicking the error in the processing window? if that is the case, then it shows no SQL , just the error messages i specified previously.|||

the sql that is causing the error is shown below. is it possible to edit this sql in business intelligence development studio?if not, then where is it stored?

SELECT [dbo_PrintFactData].[Total] AS [dbo_PrintFactDataTotal0_0],[dbo_PrintFactData].[InvoiceVolume] AS [dbo_PrintFactDataInvoiceVolume0_1],[dbo_PrintFactData].[CountryDimensionID] AS [dbo_PrintFactDataCountryDimensionID0_2],[dbo_PrintFactData].[CurrencyDimensionID] AS [dbo_PrintFactDataCurrencyDimensionID0_3],[dbo_PrintFactData].[CustomerDimensionID] AS [dbo_PrintFactDataCustomerDimensionID0_4],[dbo_PrintFactData].[EngagementNameDimensionID] AS [dbo_PrintFactDataEngagementNameDimensionID0_5],[dbo_PrintFactData].[InvoiceNumberDimensionID] AS [dbo_PrintFactDataInvoiceNumberDimensionID0_6],[dbo_PrintFactData].[PONumberDimensionID] AS [dbo_PrintFactDataPONumberDimensionID0_7],[dbo_PrintFactData].[ReportDimensionID] AS [dbo_PrintFactDataReportDimensionID0_8],[dbo_PrintFactData].[SAPMessageDimensionID] AS [dbo_PrintFactDataSAPMessageDimensionID0_9],[dbo_PrintFactData].[SystemTypeDimensionID] AS [dbo_PrintFactDataSystemTypeDimensionID0_10],[dbo_PrintFactData].[TransactionDateDimensionID] AS [dbo_PrintFactDataTransactionDateDimensionID0_11],[dbo_PrintFactData].[CaseDimensionID] AS [dbo_PrintFactDataCaseDimensionID0_12],[dbo_PrintFactData].[ContractDimensionID] AS [dbo_PrintFactDataContractDimensionID0_13],[dbo_PrintFactData].[ResolutionTypeDimensionID] AS [dbo_PrintFactDataResolutionTypeDimensionID0_14]
FROM
(

SELECT "Total", "InvoiceVolume", "CountryDimensionID", "ResolutionTypeDimensionID", "ContractDimensionID", "CaseDimensionID", "TransactionDateDimensionID", "SystemTypeDimensionID", "SAPMessageDimensionID", "ReportDimensionID", "PONumberDimensionID", "InvoiceNumberDimensionID", "EngagementNameDimensionID", "CustomerDimensionID", "CurrencyDimensionID" FROM "dbo"."PrintFactData" WHERE "PrintDimensionTransactionDate"."TransactionDate" >= '1/1/2004' --problem here, table printdimensiontransactiondate not mentioned in query before this
)
AS [dbo_PrintFactData]

Error When Open Analysis Services From Management Studio

Dear All,

When I want to open Analysis

Services from Management Studio, an

error message appear:

Exception of type

'System.OutOfMemoryException' was thrown.

(Microsoft.SqlServer.SmoEnum)

Can anybody tell me what happen and how to solve that ?

Thanks in advance.

What version of Analysis Services you are running?

Try installing SP1. If that wouldnt help, try installing CTP of SP2.

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

|||Dear Edward,

Thanks for your reply. I have installed SP1 + Hotfix so the version of SSAS is 2153. Is it recommended to installed SP2 on Production server yet ? Thanks.|||

I wouldnt recommend installing CTP of SP2 without trying it first on the production machine.

But the problem looks like to be related to the SQL Management studio. Try installing CTP of SP2 on a client machine and then connecting to the server. See if the same error is happening.

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

|||Dear Edward,

FYI, I have 4 machine in my environment, one server (A) and the other three is client (B,C,D). I installed SP1 + hotfix on machine A, B, and C. I installed CTP of SP2 on D. A cannot open Analysis Services from management studio on its local, but can open Analysis Services on B and C. B and C can open Analysis Services on their local but cannot open the Analysis Services on A. D can open Analysis Services on its local and other machines (A, B, C). Is there any other solution besides installing CTP of SP2 on client ? Thanks.|||

In SP2 SQL Management studio is more efficient in opening big databases. Looks like that is the way to go.

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

|||Dear Edward,

Thanks for your information. Then I guess I have to wait for the release of SP2 to installed it on Production Server.

error when migrating cubes

i have analysis server 2000 on my server and have just installed a new instance of analysis server 2005. i tried the migration wizard but get this error:

Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

what does that mean? i have no idea how to debug that and google has yeilded no results.

Try installing "Microsoft SQL Server 2005 Backward Compatibility Components " package from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

If that wouldnt help, try re-installing AS2005.

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

Error when I try to register a server in Analysis Services

Hi,
When I try to register a server in Analysis Services I get a error saying 'Automation error' and I also get a message saying Unable to open Registry Key 'SOFTWARE\MICROSOFT\OLAP Server\OLAP Manager'
Can someone please help.Install service pack 3 for SQL and Analysis Services.|||Thanks for the reply.

SP3 is already installed on the machine. I am not getting this message when I am logged on the machine as a user who belong to the Administrator group but if I log in the same machine as some other user (who is not a member of the Admin group), only then I get this message :confused:

Error when browsing the cube

I installed Analysis Services and then I installed
SP3 for SqlServer2k and
SP3 for Analysis Services
But I am still getting an error when browsing the cube
Errors like
"Provider not found. not properly installed
and then
"Unspecified error"
and some times
"Unable to connect to the registry on the server you are not a member of olap administartors group on this server"
Any help/suggestions?
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
We create a single user/group, add the user/group to the olap admin
group via Control Pannel-->Admin Tools-->Comp Mgmt-->Local Users and
Groups-->Olap Administrators
SqlJunkies User wrote:
> *I installed Analysis Services and then I installed
> SP3 for SqlServer2k and
> SP3 for Analysis Services
> But I am still getting an error when browsing the cube
> Errors like
> "Provider not found. not properly installed
> and then
> "Unspecified error"
> and some times
> "Unable to connect to the registry on the server you are not a member
> of olap administartors group on this server"
> Any help/suggestions?
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup
> engine supports Post Alerts, Ratings, and Searching. *
RaiderD
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message479867.html

Error when browsing the cube

I installed Analysis Services and then I installed
SP3 for SqlServer2k and
SP3 for Analysis Services
But I am still getting an error when browsing the cube
Errors like
"Provider not found. not properly installed
and then
"Unspecified error"
and some times
"Unable to connect to the registry on the server you are not a member of ola
p administartors group on this server"
Any help/suggestions?
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.We create a single user/group, add the user/group to the olap admin group vi
a Control Pannel-->Admin Tools-->Comp Mgmt-->Local Users and Groups-->Olap A
dministrators

quote:

---

Originally posted by SqlJunkies User
I installed Analysis Services and then I installed
SP3 for SqlServer2k and
SP3 for Analysis Services
But I am still getting an error when browsing the cube
Errors like
"Provider not found. not properly installed
and then
"Unspecified error"
and some times
"Unable to connect to the registry on the server you are not a member of ola
p administartors group on this server"
Any help/suggestions?
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post A
lerts, Ratings, and Searching.

---

Error when browsing data

Hi Guys,
I am novice to AS. I install the Analysis Services to my Windows 2000 Professional. But in the places where to display or browsing data, it always encounters an Unspecific Error. For example:
a) In a cube - HR, if i select Browsing Data menu, the error 'Unspecific Error' displayed.
b) In a Dimensions, select Brows Dimensions Data, the error message in the windows said: Unable to brows the Dimension '*******', Unspecific Error.

Please help me to fix this problem
Thanks
PatrickMore info.:
The error happens at first time on clicking the data tab, the error message said:
'Provider cannot be found. It may not be properly installed'
I am not sure which Provider should i install?
Thanks|||Bug Fixed by installing the SQL Service SP

error using Analysis Sevices in Web

Hi, i have question when i'm publishig a web page with a cube inside, the component displays the next error:

the html element at line 1, column6 (namespache) cannot appear under

then i log on into my server to the analysys Services and i can browse my cube without any problems, but the page just cannot show it, any suggestions?

thnks!!!

right... i should've been more especific. the problem was the conexion..i'm usign a web service to achieve this.. somehow.. this component caused some errors in the server...so i added a new one and changed the mappings in the web page...this solved the problem correctly

thanks anyway.. hope this helps to some of you!!