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
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

can't install sample databases plus no documents or tutorials

I have downloaded and run all the .msi's for the sample databases. To install them I am suppose to use "SQL Server 2005 Setup, you need to click the Advanced button....". I don't seem to have a "SQL Server 2005 Setup" - did the docs revert back to SQL Server rather than SQL Express or what ?

R
Perhaps I was unclear on the problem (people have looked at my post but no one has replied). I am trying to follow the instructions at

http://download.microsoft.com/download/d/8/6/d865cf0c-c44b-401b-b426-b3bf5c628112/GettingStartedWithSQLSamples.htm
Don't know why that doesn't show up as an URL.

Anyway the intructions do not match what I have downloaded.

Any help would be greatly appreciated

Thanks

R
|||

I downloaded the files couple of days ago on my own for a training. I think the process described here is for non-Express version, but for express version (or as a standalone inspection) you can download the sample files here:

http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Thanks Jens for the reply and the link; however, that link is the crux of the problem. I have done everything specified on that link until I get to the point of using SQL Server 2005 Setup - which I don't have. I think I have a very neat application but it hard to implement it without a database to practice on.

R
|||

The first three steps of the Getting Started with SQL Server Samples document that your reference deal specifically with how to install the SqlSamples.msi file when you are installing SQL Server. These do not apply to SQL Express because we do not include the SqlSamples.msi as part of our installer package. (We do this to keep it small.) Steps starting with four still apply.

Rather, you need to install the samples separately by downloading SqlSamples.msi from the Samples page that Jens pointed to. You will see a bunch of links on that page that break the Sample installation files up by processor type, e.g. x86. The direct link for the x86 version is http://download.microsoft.com/download/a/1/8/a1872d6b-f740-4c52-a2c5-0eb5bdd1a7e3/SqlServerSamples.msi.

Once you've downloaded this file, just run it and it will install the Samples onto your computer. You can then use the Start menu (All Programs | Microsoft SQL Server 2005 | Documentation and Tutorials | Samples Directory) to open the directory and find the various sub-categories. Each specific sample has a read-me with more information about how to use it. For many, you will need AdventureWorksDB installed, which is also a separate download for Express and available on the same page with the samples. (i.e. the one that Jens gives.)