Cant PREVIEW SAMPLE REPORTS

Hi,
I tried to view the sample reports provided by microsoft, but I cant even
preview them...I get the error::
AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION TO
THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
DENIED...
But the wierd thing is that I CAN PREVIEW THE FOODMART SALES REPORT!... Why
is that?
Also, when I tried to create a subscription as in their walkthrough I get
the error:
"The dataset cannot be generated. An error occurred while connecting to a
data source, or the query is not valid for the data source.
(rsCannotPrepareQuery)
SQL Server does not exist or access denied. A valid query must be
specified. "
But the query is simply Select * from table...
Any idea why these things are happening? Also, the reports are already
successfully deployed to the server...
Plz help...Thanks
--
pmudAs part of setup did you choose to install the AdventureWorks2000 database?
If so did you make sure the AdventureWorks shared datasource was pointed to
wherever that database was installed?
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
> Hi,
> I tried to view the sample reports provided by microsoft, but I cant even
> preview them...I get the error::
> AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION TO
> THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
> DENIED...
> But the wierd thing is that I CAN PREVIEW THE FOODMART SALES REPORT!...
> Why
> is that?
> Also, when I tried to create a subscription as in their walkthrough I get
> the error:
> "The dataset cannot be generated. An error occurred while connecting to a
> data source, or the query is not valid for the data source.
> (rsCannotPrepareQuery)
> SQL Server does not exist or access denied. A valid query must be
> specified. "
> But the query is simply Select * from table...
> Any idea why these things are happening? Also, the reports are already
> successfully deployed to the server...
> Plz help...Thanks
> --
> pmud|||Hi Douglas,
the adventure works database is installed bcoz the forrdmart sales report is
using it & i can preview that sample report... But how to make sure that
adventuer works databse was pointed to '
Thanks
"Douglas McDowell" wrote:
> As part of setup did you choose to install the AdventureWorks2000 database?
> If so did you make sure the AdventureWorks shared datasource was pointed to
> wherever that database was installed?
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
> > Hi,
> >
> > I tried to view the sample reports provided by microsoft, but I cant even
> > preview them...I get the error::
> >
> > AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION TO
> > THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
> > DENIED...
> >
> > But the wierd thing is that I CAN PREVIEW THE FOODMART SALES REPORT!...
> > Why
> > is that?
> >
> > Also, when I tried to create a subscription as in their walkthrough I get
> > the error:
> >
> > "The dataset cannot be generated. An error occurred while connecting to a
> > data source, or the query is not valid for the data source.
> > (rsCannotPrepareQuery)
> > SQL Server does not exist or access denied. A valid query must be
> > specified. "
> >
> > But the query is simply Select * from table...
> >
> > Any idea why these things are happening? Also, the reports are already
> > successfully deployed to the server...
> >
> > Plz help...Thanks
> > --
> > pmud
>
>|||Foodmart Sales is the only report that does not use AdventureWorks2000, it
uses FoodMart, the default Analysis Services OLAP database. Open Enterprise
manager on the SQL Server instance that you are pointing your shared
datasource to and see if it has an AdventureWorks2000 database.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:4B67C061-122A-42F6-BF3F-58DBC3539326@.microsoft.com...
> Hi Douglas,
> the adventure works database is installed bcoz the forrdmart sales report
> is
> using it & i can preview that sample report... But how to make sure that
> adventuer works databse was pointed to '
> Thanks
> "Douglas McDowell" wrote:
>> As part of setup did you choose to install the AdventureWorks2000
>> database?
>> If so did you make sure the AdventureWorks shared datasource was pointed
>> to
>> wherever that database was installed?
>> --
>> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>>
>> "pmud" <pmud@.discussions.microsoft.com> wrote in message
>> news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
>> > Hi,
>> >
>> > I tried to view the sample reports provided by microsoft, but I cant
>> > even
>> > preview them...I get the error::
>> >
>> > AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION
>> > TO
>> > THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
>> > DENIED...
>> >
>> > But the wierd thing is that I CAN PREVIEW THE FOODMART SALES
>> > REPORT!...
>> > Why
>> > is that?
>> >
>> > Also, when I tried to create a subscription as in their walkthrough I
>> > get
>> > the error:
>> >
>> > "The dataset cannot be generated. An error occurred while connecting to
>> > a
>> > data source, or the query is not valid for the data source.
>> > (rsCannotPrepareQuery)
>> > SQL Server does not exist or access denied. A valid query must be
>> > specified. "
>> >
>> > But the query is simply Select * from table...
>> >
>> > Any idea why these things are happening? Also, the reports are already
>> > successfully deployed to the server...
>> >
>> > Plz help...Thanks
>> > --
>> > pmud
>>|||Hi Douglas,
I checked the enterprise manager, it has the Adventure works database...
Also, I faced a similar problem just now.. I think it has smthg to do with
analysis manager & enterprise manager... I bought the book by
Microsoft..."SQL service sreporting services 2000 Step by Step" & installed
the samples from CD... It had a sample database called rs2000DW which got
restored to the ANALYSIS MANAGER...
Now I tried to create a report using this data source.... But i get the
error :: Connection open...SQL server doesnt exist or access denied... In
the server name i had typed localhost....I even tried typing the IP address
there & the Computer name... But it gives the same error msg...
Can it be bcoz In my enterprise manager... the SQL server instance name is
DEVELOPMENT\DEV & in the ANALYSIS MANAGER its called DEVELOPMENT '
It doesnt see the data source from ANALYSIS Mgr . but sees from enterprise
manager when i use the server name as DEVELPOMENT\DEV..'
Whats wrong? Plz help...
Thanks
"Douglas McDowell" wrote:
> Foodmart Sales is the only report that does not use AdventureWorks2000, it
> uses FoodMart, the default Analysis Services OLAP database. Open Enterprise
> manager on the SQL Server instance that you are pointing your shared
> datasource to and see if it has an AdventureWorks2000 database.
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:4B67C061-122A-42F6-BF3F-58DBC3539326@.microsoft.com...
> > Hi Douglas,
> >
> > the adventure works database is installed bcoz the forrdmart sales report
> > is
> > using it & i can preview that sample report... But how to make sure that
> > adventuer works databse was pointed to '
> >
> > Thanks
> >
> > "Douglas McDowell" wrote:
> >
> >> As part of setup did you choose to install the AdventureWorks2000
> >> database?
> >> If so did you make sure the AdventureWorks shared datasource was pointed
> >> to
> >> wherever that database was installed?
> >> --
> >> Douglas McDowell douglas@.nospam.solidqualitylearning.com
> >>
> >>
> >> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> >> news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
> >> > Hi,
> >> >
> >> > I tried to view the sample reports provided by microsoft, but I cant
> >> > even
> >> > preview them...I get the error::
> >> >
> >> > AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION
> >> > TO
> >> > THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
> >> > DENIED...
> >> >
> >> > But the wierd thing is that I CAN PREVIEW THE FOODMART SALES
> >> > REPORT!...
> >> > Why
> >> > is that?
> >> >
> >> > Also, when I tried to create a subscription as in their walkthrough I
> >> > get
> >> > the error:
> >> >
> >> > "The dataset cannot be generated. An error occurred while connecting to
> >> > a
> >> > data source, or the query is not valid for the data source.
> >> > (rsCannotPrepareQuery)
> >> > SQL Server does not exist or access denied. A valid query must be
> >> > specified. "
> >> >
> >> > But the query is simply Select * from table...
> >> >
> >> > Any idea why these things are happening? Also, the reports are already
> >> > successfully deployed to the server...
> >> >
> >> > Plz help...Thanks
> >> > --
> >> > pmud
> >>
> >>
> >>
>
>|||Looks like you have a named instance of SQL Server, so in your SQL Server
connection string for your datasource you need to specify DEVELOPMENT\DEV
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:7E49FB2F-C9D3-49F8-A3CD-FA4CF586C2DE@.microsoft.com...
> Hi Douglas,
> I checked the enterprise manager, it has the Adventure works database...
> Also, I faced a similar problem just now.. I think it has smthg to do with
> analysis manager & enterprise manager... I bought the book by
> Microsoft..."SQL service sreporting services 2000 Step by Step" &
> installed
> the samples from CD... It had a sample database called rs2000DW which got
> restored to the ANALYSIS MANAGER...
> Now I tried to create a report using this data source.... But i get the
> error :: Connection open...SQL server doesnt exist or access denied... In
> the server name i had typed localhost....I even tried typing the IP
> address
> there & the Computer name... But it gives the same error msg...
> Can it be bcoz In my enterprise manager... the SQL server instance name is
> DEVELOPMENT\DEV & in the ANALYSIS MANAGER its called DEVELOPMENT '
> It doesnt see the data source from ANALYSIS Mgr . but sees from enterprise
> manager when i use the server name as DEVELPOMENT\DEV..'
> Whats wrong? Plz help...
> Thanks
> "Douglas McDowell" wrote:
>> Foodmart Sales is the only report that does not use AdventureWorks2000,
>> it
>> uses FoodMart, the default Analysis Services OLAP database. Open
>> Enterprise
>> manager on the SQL Server instance that you are pointing your shared
>> datasource to and see if it has an AdventureWorks2000 database.
>> --
>> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>>
>> "pmud" <pmud@.discussions.microsoft.com> wrote in message
>> news:4B67C061-122A-42F6-BF3F-58DBC3539326@.microsoft.com...
>> > Hi Douglas,
>> >
>> > the adventure works database is installed bcoz the forrdmart sales
>> > report
>> > is
>> > using it & i can preview that sample report... But how to make sure
>> > that
>> > adventuer works databse was pointed to '
>> >
>> > Thanks
>> >
>> > "Douglas McDowell" wrote:
>> >
>> >> As part of setup did you choose to install the AdventureWorks2000
>> >> database?
>> >> If so did you make sure the AdventureWorks shared datasource was
>> >> pointed
>> >> to
>> >> wherever that database was installed?
>> >> --
>> >> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>> >>
>> >>
>> >> "pmud" <pmud@.discussions.microsoft.com> wrote in message
>> >> news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
>> >> > Hi,
>> >> >
>> >> > I tried to view the sample reports provided by microsoft, but I cant
>> >> > even
>> >> > preview them...I get the error::
>> >> >
>> >> > AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE
>> >> > CONNCTION
>> >> > TO
>> >> > THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
>> >> > DENIED...
>> >> >
>> >> > But the wierd thing is that I CAN PREVIEW THE FOODMART SALES
>> >> > REPORT!...
>> >> > Why
>> >> > is that?
>> >> >
>> >> > Also, when I tried to create a subscription as in their walkthrough
>> >> > I
>> >> > get
>> >> > the error:
>> >> >
>> >> > "The dataset cannot be generated. An error occurred while connecting
>> >> > to
>> >> > a
>> >> > data source, or the query is not valid for the data source.
>> >> > (rsCannotPrepareQuery)
>> >> > SQL Server does not exist or access denied. A valid query must be
>> >> > specified. "
>> >> >
>> >> > But the query is simply Select * from table...
>> >> >
>> >> > Any idea why these things are happening? Also, the reports are
>> >> > already
>> >> > successfully deployed to the server...
>> >> >
>> >> > Plz help...Thanks
>> >> > --
>> >> > pmud
>> >>
>> >>
>> >>
>>|||Thanks Douglas , that solves one of my problems. I can preview th sample
reports now... Thanks... I guess my other doubts should be aske din the next
question...
Thanks again...
"Douglas McDowell" wrote:
> Looks like you have a named instance of SQL Server, so in your SQL Server
> connection string for your datasource you need to specify DEVELOPMENT\DEV
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:7E49FB2F-C9D3-49F8-A3CD-FA4CF586C2DE@.microsoft.com...
> > Hi Douglas,
> >
> > I checked the enterprise manager, it has the Adventure works database...
> >
> > Also, I faced a similar problem just now.. I think it has smthg to do with
> > analysis manager & enterprise manager... I bought the book by
> > Microsoft..."SQL service sreporting services 2000 Step by Step" &
> > installed
> > the samples from CD... It had a sample database called rs2000DW which got
> > restored to the ANALYSIS MANAGER...
> >
> > Now I tried to create a report using this data source.... But i get the
> > error :: Connection open...SQL server doesnt exist or access denied... In
> > the server name i had typed localhost....I even tried typing the IP
> > address
> > there & the Computer name... But it gives the same error msg...
> >
> > Can it be bcoz In my enterprise manager... the SQL server instance name is
> > DEVELOPMENT\DEV & in the ANALYSIS MANAGER its called DEVELOPMENT '
> >
> > It doesnt see the data source from ANALYSIS Mgr . but sees from enterprise
> > manager when i use the server name as DEVELPOMENT\DEV..'
> >
> > Whats wrong? Plz help...
> >
> > Thanks
> > "Douglas McDowell" wrote:
> >
> >> Foodmart Sales is the only report that does not use AdventureWorks2000,
> >> it
> >> uses FoodMart, the default Analysis Services OLAP database. Open
> >> Enterprise
> >> manager on the SQL Server instance that you are pointing your shared
> >> datasource to and see if it has an AdventureWorks2000 database.
> >> --
> >> Douglas McDowell douglas@.nospam.solidqualitylearning.com
> >>
> >>
> >> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> >> news:4B67C061-122A-42F6-BF3F-58DBC3539326@.microsoft.com...
> >> > Hi Douglas,
> >> >
> >> > the adventure works database is installed bcoz the forrdmart sales
> >> > report
> >> > is
> >> > using it & i can preview that sample report... But how to make sure
> >> > that
> >> > adventuer works databse was pointed to '
> >> >
> >> > Thanks
> >> >
> >> > "Douglas McDowell" wrote:
> >> >
> >> >> As part of setup did you choose to install the AdventureWorks2000
> >> >> database?
> >> >> If so did you make sure the AdventureWorks shared datasource was
> >> >> pointed
> >> >> to
> >> >> wherever that database was installed?
> >> >> --
> >> >> Douglas McDowell douglas@.nospam.solidqualitylearning.com
> >> >>
> >> >>
> >> >> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> >> >> news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
> >> >> > Hi,
> >> >> >
> >> >> > I tried to view the sample reports provided by microsoft, but I cant
> >> >> > even
> >> >> > preview them...I get the error::
> >> >> >
> >> >> > AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE
> >> >> > CONNCTION
> >> >> > TO
> >> >> > THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
> >> >> > DENIED...
> >> >> >
> >> >> > But the wierd thing is that I CAN PREVIEW THE FOODMART SALES
> >> >> > REPORT!...
> >> >> > Why
> >> >> > is that?
> >> >> >
> >> >> > Also, when I tried to create a subscription as in their walkthrough
> >> >> > I
> >> >> > get
> >> >> > the error:
> >> >> >
> >> >> > "The dataset cannot be generated. An error occurred while connecting
> >> >> > to
> >> >> > a
> >> >> > data source, or the query is not valid for the data source.
> >> >> > (rsCannotPrepareQuery)
> >> >> > SQL Server does not exist or access denied. A valid query must be
> >> >> > specified. "
> >> >> >
> >> >> > But the query is simply Select * from table...
> >> >> >
> >> >> > Any idea why these things are happening? Also, the reports are
> >> >> > already
> >> >> > successfully deployed to the server...
> >> >> >
> >> >> > Plz help...Thanks
> >> >> > --
> >> >> > pmud
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>