|
|
You're in the
sql server reporting services
group:RS OLAP Connection Problem
sql server reporting services:
box). RS SP1 is installed. I have a SQLRS report developed in visual studio (on the same box) that runs MDX against an analysis services cube. I am using the OLE DB provider for OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting services server to get the pivot table service and 8.0 provider to be available) I can successfully connect to Analysis Services and preview the report in visual studio. When I run the report in Report Manger, the report bombs with... An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'ServerNameBlahBlah'. (rsErrorOpeningConnection) Get Online Help Database 'CubeNameBlahBlah' does not exist. I have a AS database role setup that should allow the stored credentials to successfully authenticate. HELP !!!!
That is what you get when you don't have rights to the AS datasource. Open
Visual Studio Report Designer by right-clicking and choosing "Run as" and choose the same credentials you are using as stored credentials for the AS datasource. See if you can then preview the report, you will probably get a similar error. -- Douglas McDowell douglas@nospam.solidqualitylearning.com [quoted text, click to view] "James" <carbonc@carbonc.com> wrote in message news:e8X%231pbJFHA.3928@TK2MSFTNGP09.phx.gbl... >I have a stand alone win2k3 reporting services server(i.e. SQL is not on >the > box). RS SP1 is installed. > > I have a SQLRS report developed in visual studio (on the same box) that > runs > MDX against an analysis services cube. I am using the OLE DB provider for > OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting > services server to get the pivot table service and 8.0 provider to be > available) > > I can successfully connect to Analysis Services and preview the report in > visual studio. > > When I run the report in Report Manger, the report bombs with... > > An error has occurred during report processing. (rsProcessingAborted) > Get Online Help > Cannot create a connection to data source 'ServerNameBlahBlah'. > (rsErrorOpeningConnection) Get Online Help > Database 'CubeNameBlahBlah' does not exist. > > I have a AS database role setup that should allow the stored > credentials to successfully authenticate. > > > HELP !!!! > >
On the contrary, when I view the report in "Preview" mode inside VS.Net the
report generates and works fine. Also when I view the report by going to the ReportServer site instead of the Reports site, the report connects and works fine as well. But when I try to view the report through the Reports site, you see the report try to "Generate" then the error: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'FIS1'. (rsErrorOpeningConnection) Get Online Help Database 'FIS' does not exist. FIS1 is the name of a Shared Data Source in the project. OLE DB Provider=MSOLAP.2;Client Cache Size=25;Auto Synch Period=10000;Data Source=DEVCubeServerName;Initial Catalog=FISCube "Douglas McDowell" <douglas@nospam.solidqualitylearning.com> wrote in message news:uDVTN5dJFHA.2356@TK2MSFTNGP14.phx.gbl... [quoted text, click to view] > That is what you get when you don't have rights to the AS datasource. Open > Visual Studio Report Designer by right-clicking and choosing "Run as" and > choose the same credentials you are using as stored credentials for the AS > datasource. See if you can then preview the report, you will probably get a > similar error. > -- > Douglas McDowell douglas@nospam.solidqualitylearning.com > > > "James" <carbonc@carbonc.com> wrote in message > news:e8X%231pbJFHA.3928@TK2MSFTNGP09.phx.gbl... > >I have a stand alone win2k3 reporting services server(i.e. SQL is not on > >the > > box). RS SP1 is installed. > > > > I have a SQLRS report developed in visual studio (on the same box) that > > runs > > MDX against an analysis services cube. I am using the OLE DB provider for > > OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting > > services server to get the pivot table service and 8.0 provider to be > > available) > > > > I can successfully connect to Analysis Services and preview the report in > > visual studio. > > > > When I run the report in Report Manger, the report bombs with... > > > > An error has occurred during report processing. (rsProcessingAborted) > > Get Online Help > > Cannot create a connection to data source 'ServerNameBlahBlah'. > > (rsErrorOpeningConnection) Get Online Help > > Database 'CubeNameBlahBlah' does not exist. > > > > I have a AS database role setup that should allow the stored > > credentials to successfully authenticate. > > > > > > HELP !!!! > > > > > >
I figured it out. Here is my solution to the problem.
Opened IE. Went to http://localhost/Reports Logged in and went to the desired folder holding the report and the data source. When in the report manager, I opened the Shared Data Source. Here are my settings that I changed to. Name: DSName Enable this data source "Checked" Connection Type: OLE DB Connection String: Provider=MSOLAP.2;Client Cache Size=25;Auto Synch Period=10000;Data Source=DEV2003SQL;Initial Catalog=CubeName Selected "Credentials stored securley in the report server" User name: Domain\UserName Password: password "Checked" Used as Windows credentials when connecting to the data source "Apply" This solved my problem. It seems that the only thing that did it was checking "Use as Windows credentials when connecting to the data source". I might ask you guys why...? -- James "Douglas McDowell" <douglas@nospam.solidqualitylearning.com> wrote in message news:uDVTN5dJFHA.2356@TK2MSFTNGP14.phx.gbl... [quoted text, click to view] > That is what you get when you don't have rights to the AS datasource. Open > Visual Studio Report Designer by right-clicking and choosing "Run as" and > choose the same credentials you are using as stored credentials for the AS > datasource. See if you can then preview the report, you will probably get a > similar error. > -- > Douglas McDowell douglas@nospam.solidqualitylearning.com > > > "James" <carbonc@carbonc.com> wrote in message > news:e8X%231pbJFHA.3928@TK2MSFTNGP09.phx.gbl... > >I have a stand alone win2k3 reporting services server(i.e. SQL is not on > >the > > box). RS SP1 is installed. > > > > I have a SQLRS report developed in visual studio (on the same box) that > > runs > > MDX against an analysis services cube. I am using the OLE DB provider for > > OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting > > services server to get the pivot table service and 8.0 provider to be > > available) > > > > I can successfully connect to Analysis Services and preview the report in > > visual studio. > > > > When I run the report in Report Manger, the report bombs with... > > > > An error has occurred during report processing. (rsProcessingAborted) > > Get Online Help > > Cannot create a connection to data source 'ServerNameBlahBlah'. > > (rsErrorOpeningConnection) Get Online Help > > Database 'CubeNameBlahBlah' does not exist. > > > > I have a AS database role setup that should allow the stored > > credentials to successfully authenticate. > > > > > > HELP !!!! > > > > > >
Analysis Services only supports Windows Authentication, so when you store
the login and password the "Used as Windows credentials when connecting to the data source" checkbox just distinguishes it from a non-Windows login like a mixed-mode SQL Server login. -- Douglas McDowell douglas@nospam.solidqualitylearning.com [quoted text, click to view] "James" <carbonc@carbonc.com> wrote in message news:u09r57jJFHA.732@TK2MSFTNGP12.phx.gbl... >I figured it out. Here is my solution to the problem. > > Opened IE. Went to http://localhost/Reports > Logged in and went to the desired folder holding the report and the data > source. > When in the report manager, I opened the Shared Data Source. Here are my > settings that I changed to. > > Name: DSName > > Enable this data source "Checked" > > Connection Type: OLE DB > > Connection String: Provider=MSOLAP.2;Client Cache Size=25;Auto Synch > Period=10000;Data Source=DEV2003SQL;Initial Catalog=CubeName > > Selected "Credentials stored securley in the report server" > User name: Domain\UserName > Password: password > "Checked" Used as Windows credentials when connecting to the data > source > > "Apply" > > > This solved my problem. It seems that the only thing that did it was > checking "Use as Windows credentials when connecting to the data source". > I > might ask you guys why...? > > -- James > > "Douglas McDowell" <douglas@nospam.solidqualitylearning.com> wrote in > message news:uDVTN5dJFHA.2356@TK2MSFTNGP14.phx.gbl... >> That is what you get when you don't have rights to the AS datasource. >> Open >> Visual Studio Report Designer by right-clicking and choosing "Run as" and >> choose the same credentials you are using as stored credentials for the >> AS >> datasource. See if you can then preview the report, you will probably >> get > a >> similar error. >> -- >> Douglas McDowell douglas@nospam.solidqualitylearning.com >> >> >> "James" <carbonc@carbonc.com> wrote in message >> news:e8X%231pbJFHA.3928@TK2MSFTNGP09.phx.gbl... >> >I have a stand alone win2k3 reporting services server(i.e. SQL is not on >> >the >> > box). RS SP1 is installed. >> > >> > I have a SQLRS report developed in visual studio (on the same box) that >> > runs >> > MDX against an analysis services cube. I am using the OLE DB provider > for >> > OLAP services 8.0. (Note that we had to run ptsfull.exe on the >> > reporting >> > services server to get the pivot table service and 8.0 provider to be >> > available) >> > >> > I can successfully connect to Analysis Services and preview the report > in >> > visual studio. >> > >> > When I run the report in Report Manger, the report bombs with... >> > >> > An error has occurred during report processing. (rsProcessingAborted) >> > Get Online Help >> > Cannot create a connection to data source 'ServerNameBlahBlah'. >> > (rsErrorOpeningConnection) Get Online Help >> > Database 'CubeNameBlahBlah' does not exist. >> > >> > I have a AS database role setup that should allow the stored >> > credentials to successfully authenticate. >> > >> > >> > HELP !!!! >> > >> > >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |