Reporting Server vs. Database Server

Hi everyone,
After reading through countless Microsoft pages I'm still very
confused about how to setup a correct datasource connection. I have a
database server where all the data is kept, and a reports server that
I would like to use only to generate and deploy reports to. I have
Visual Studio 2005 installed on my client computer, and I DO NOT want
to create a data source that connects directly to the database
server.
Theoretically, there is a way to load VS and connect to the database
server through the reports server. I don't want any of my client
computers directly touching the database server, but they have to be
able to generate reports from that data. How can I accomplish this?
Anyone who can solve this conundrum gets a batch of my wife's home-
made cookies!Not possible. The computer that is running VS 2005 has to have a datasource
to the data being reported off of. All the users do not need to connect to
the database server but any developer using the report designer has to have
a data source created to hit the server.
I use mixed mode on the database server, create a readonly login that I use
for reporting.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<nlandis22@.gmail.com> wrote in message
news:1177429176.362218.226390@.t38g2000prd.googlegroups.com...
> Hi everyone,
> After reading through countless Microsoft pages I'm still very
> confused about how to setup a correct datasource connection. I have a
> database server where all the data is kept, and a reports server that
> I would like to use only to generate and deploy reports to. I have
> Visual Studio 2005 installed on my client computer, and I DO NOT want
> to create a data source that connects directly to the database
> server.
> Theoretically, there is a way to load VS and connect to the database
> server through the reports server. I don't want any of my client
> computers directly touching the database server, but they have to be
> able to generate reports from that data. How can I accomplish this?
> Anyone who can solve this conundrum gets a batch of my wife's home-
> made cookies!
>|||On Apr 24, 12:38 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Not possible. The computer that is running VS 2005 has to have a datasource
> to the data being reported off of. All the users do not need to connect to
> the database server but any developer using the report designer has to have
> a data source created to hit the server.
> I use mixed mode on the database server, create a readonly login that I use
> for reporting.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <nlandi...@.gmail.com> wrote in message
> news:1177429176.362218.226390@.t38g2000prd.googlegroups.com...
>
> > Hi everyone,
> > After reading through countless Microsoft pages I'm still very
> > confused about how to setup a correct datasource connection. I have a
> > database server where all the data is kept, and a reports server that
> > I would like to use only to generate and deploy reports to. I have
> > Visual Studio 2005 installed on my client computer, and I DO NOT want
> > to create a data source that connects directly to the database
> > server.
> > Theoretically, there is a way to load VS and connect to the database
> > server through the reports server. I don't want any of my client
> > computers directly touching the database server, but they have to be
> > able to generate reports from that data. How can I accomplish this?
> > Anyone who can solve this conundrum gets a batch of my wife's home-
> > made cookies!- Hide quoted text -
> - Show quoted text -
That's for the help. I think having a read-only login is probably a
safe way to go. The only reason I asked was because of this article
that I found earlier. I don't quite understand Report Server Model's
yet... but I get the feeling it's something for Report Builder, and
not for Report Designer (VS).
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/2aef6082da0ab4a4/8db0b06920500fc2?lnk=gst&q=data+source&rnum=6#8db0b06920500fc2