I've done a number of RS installs, this one is on a new 2003 server. I have
VS.NET on the computer and can develop and deploy successfully.
I can view the report from VS.NET preview or using IE, typing
http://localhost/ReportServer?/yada/yada
However if I want to run Reports Manager, typing http://localhost/Reports
then I get an error,
Access denied to 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\BIN'. Failed to start monitoring file changes.
I've changed permissions on the folder and the ReportServer service is now
started with the Admin account, no success yet.It is fixed now. This is what I did in case it can help someone in the
future.
Un-install Reporting Services.
Use Enterprise Manager to delete the 2 Reporting Services databases, the
un-install did not.
Delete the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services
directory and sub-directories.
Install again.
"Chris Botha" <chris_s_botha@.AThotmail.com> wrote in message
news:#5EIp0$HFHA.2564@.tk2msftngp13.phx.gbl...
> I've done a number of RS installs, this one is on a new 2003 server. I
have
> VS.NET on the computer and can develop and deploy successfully.
> I can view the report from VS.NET preview or using IE, typing
> http://localhost/ReportServer?/yada/yada
> However if I want to run Reports Manager, typing http://localhost/Reports
> then I get an error,
> Access denied to 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\BIN'. Failed to start monitoring file changes.
> I've changed permissions on the folder and the ReportServer service is now
> started with the Admin account, no success yet.
>
Showing posts with label develop. Show all posts
Showing posts with label develop. Show all posts
Wednesday, March 21, 2012
Reports Use one Model dynamically connected to several databases with identical schema
We have several archived databases with identical schema. Is it
possible to develop a single SQL Server 2005 report model such that
the user can generate reports by picking which database to connect to?
The report model are only based on the schema of one database. It is
not required to cross reference data from different archived
databases.
We have to support multiple users such that we cannot rename the
database while the report is generated.
Thanks in advance.
SimonEven if you manage to do for all databases, how to give an option of
selecting the database and binding to the model ? Not possible.
My suggestion is you can create the same model and copy that and change the
database it is pointing and the name. e.g
Data 2003, Data 2004, Data 2005 some thing like this.
When the user goes to the report model designer he can see all the model
available, let him select whichever he wants and creates a report.
Amarnath, MCTS.
"Simon" wrote:
> We have several archived databases with identical schema. Is it
> possible to develop a single SQL Server 2005 report model such that
> the user can generate reports by picking which database to connect to?
> The report model are only based on the schema of one database. It is
> not required to cross reference data from different archived
> databases.
> We have to support multiple users such that we cannot rename the
> database while the report is generated.
> Thanks in advance.
> Simon
>|||On Mar 16, 3:03 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
The issue is that the archives are not limited to yearly archive. The
user can create an archive at will.
I tried to use "Data Source Expressions" but failed because that data
source expression can not be used in a shared data source.
Simon
> Even if you manage to do for all databases, how to give an option of
> selecting the database and binding to the model ? Not possible.
> My suggestion is you can create the same model and copy that and change the
> database it is pointing and the name. e.g
> Data 2003, Data 2004, Data 2005 some thing like this.
> When the user goes to the report model designer he can see all the model
> available, let him select whichever he wants and creates a report.
> Amarnath, MCTS.
>
> "Simon" wrote:
> > We have several archived databases with identical schema. Is it
> > possible to develop a single SQL Server 2005 report model such that
> > the user can generate reports by picking which database to connect to?
> > The report model are only based on the schema of one database. It is
> > not required to cross reference data from different archived
> > databases.
> > We have to support multiple users such that we cannot rename the
> > database while the report is generated.
> > Thanks in advance.
> > Simon- Hide quoted text -
> - Show quoted text -|||Simon,
Infact you need to have report model for RB, it means the RModel should be
fixed with all possible links with tables, so that the user can select any
field. So RModel cannot be on the fly created by the user, unless you create
a custom code, which will be difficult, and I hope that should not be the
options, due to difficulty..
Amarnath, MCTS.
"Simon" wrote:
> On Mar 16, 3:03 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> The issue is that the archives are not limited to yearly archive. The
> user can create an archive at will.
> I tried to use "Data Source Expressions" but failed because that data
> source expression can not be used in a shared data source.
>
> Simon
> > Even if you manage to do for all databases, how to give an option of
> > selecting the database and binding to the model ? Not possible.
> >
> > My suggestion is you can create the same model and copy that and change the
> > database it is pointing and the name. e.g
> > Data 2003, Data 2004, Data 2005 some thing like this.
> >
> > When the user goes to the report model designer he can see all the model
> > available, let him select whichever he wants and creates a report.
> >
> > Amarnath, MCTS.
> >
> >
> >
> > "Simon" wrote:
> > > We have several archived databases with identical schema. Is it
> > > possible to develop a single SQL Server 2005 report model such that
> > > the user can generate reports by picking which database to connect to?
> >
> > > The report model are only based on the schema of one database. It is
> > > not required to cross reference data from different archived
> > > databases.
> >
> > > We have to support multiple users such that we cannot rename the
> > > database while the report is generated.
> >
> > > Thanks in advance.
> > > Simon- Hide quoted text -
> >
> > - Show quoted text -
>
>
possible to develop a single SQL Server 2005 report model such that
the user can generate reports by picking which database to connect to?
The report model are only based on the schema of one database. It is
not required to cross reference data from different archived
databases.
We have to support multiple users such that we cannot rename the
database while the report is generated.
Thanks in advance.
SimonEven if you manage to do for all databases, how to give an option of
selecting the database and binding to the model ? Not possible.
My suggestion is you can create the same model and copy that and change the
database it is pointing and the name. e.g
Data 2003, Data 2004, Data 2005 some thing like this.
When the user goes to the report model designer he can see all the model
available, let him select whichever he wants and creates a report.
Amarnath, MCTS.
"Simon" wrote:
> We have several archived databases with identical schema. Is it
> possible to develop a single SQL Server 2005 report model such that
> the user can generate reports by picking which database to connect to?
> The report model are only based on the schema of one database. It is
> not required to cross reference data from different archived
> databases.
> We have to support multiple users such that we cannot rename the
> database while the report is generated.
> Thanks in advance.
> Simon
>|||On Mar 16, 3:03 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
The issue is that the archives are not limited to yearly archive. The
user can create an archive at will.
I tried to use "Data Source Expressions" but failed because that data
source expression can not be used in a shared data source.
Simon
> Even if you manage to do for all databases, how to give an option of
> selecting the database and binding to the model ? Not possible.
> My suggestion is you can create the same model and copy that and change the
> database it is pointing and the name. e.g
> Data 2003, Data 2004, Data 2005 some thing like this.
> When the user goes to the report model designer he can see all the model
> available, let him select whichever he wants and creates a report.
> Amarnath, MCTS.
>
> "Simon" wrote:
> > We have several archived databases with identical schema. Is it
> > possible to develop a single SQL Server 2005 report model such that
> > the user can generate reports by picking which database to connect to?
> > The report model are only based on the schema of one database. It is
> > not required to cross reference data from different archived
> > databases.
> > We have to support multiple users such that we cannot rename the
> > database while the report is generated.
> > Thanks in advance.
> > Simon- Hide quoted text -
> - Show quoted text -|||Simon,
Infact you need to have report model for RB, it means the RModel should be
fixed with all possible links with tables, so that the user can select any
field. So RModel cannot be on the fly created by the user, unless you create
a custom code, which will be difficult, and I hope that should not be the
options, due to difficulty..
Amarnath, MCTS.
"Simon" wrote:
> On Mar 16, 3:03 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> The issue is that the archives are not limited to yearly archive. The
> user can create an archive at will.
> I tried to use "Data Source Expressions" but failed because that data
> source expression can not be used in a shared data source.
>
> Simon
> > Even if you manage to do for all databases, how to give an option of
> > selecting the database and binding to the model ? Not possible.
> >
> > My suggestion is you can create the same model and copy that and change the
> > database it is pointing and the name. e.g
> > Data 2003, Data 2004, Data 2005 some thing like this.
> >
> > When the user goes to the report model designer he can see all the model
> > available, let him select whichever he wants and creates a report.
> >
> > Amarnath, MCTS.
> >
> >
> >
> > "Simon" wrote:
> > > We have several archived databases with identical schema. Is it
> > > possible to develop a single SQL Server 2005 report model such that
> > > the user can generate reports by picking which database to connect to?
> >
> > > The report model are only based on the schema of one database. It is
> > > not required to cross reference data from different archived
> > > databases.
> >
> > > We have to support multiple users such that we cannot rename the
> > > database while the report is generated.
> >
> > > Thanks in advance.
> > > Simon- Hide quoted text -
> >
> > - Show quoted text -
>
>
Wednesday, March 7, 2012
ReportingServer Path (Url)
Hello
I develop my reports local on my pc (VS2003, IIS5, SQL Server 2000 and
ReportingServer are on the same Pc) and when i be finish then i want
transfer the reports to official ReportingServer.
Now my question witch files must transfer to the ReportingServer? And when i
transfer the files to another server then i think i must change the
ReportingServer-Path, how can do that? I see that i can change the path in
the VS-Project-Code, but can i do that purhaps with a Config-File or at real
time?
Thank you very much
Regards
RogerIf you are talking about reports ONLY , then the .RDL file is the only file
which must be transferred...
A common method is to use the Web interface on the production server to
UPLOAD the RDL files. That way you do not have to change anything on your
test side...Just tell the production guy where the RDL is.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"R.Odermatt" <roger.odermatt@.nospam.swica.ch> wrote in message
news:uME3TRi%23EHA.1544@.TK2MSFTNGP11.phx.gbl...
> Hello
> I develop my reports local on my pc (VS2003, IIS5, SQL Server 2000 and
> ReportingServer are on the same Pc) and when i be finish then i want
> transfer the reports to official ReportingServer.
> Now my question witch files must transfer to the ReportingServer? And when
i
> transfer the files to another server then i think i must change the
> ReportingServer-Path, how can do that? I see that i can change the path in
> the VS-Project-Code, but can i do that purhaps with a Config-File or at
real
> time?
> Thank you very much
> Regards
> Roger
>|||The only issue deployment might give you is if you have used jump to url
action. Otherwise everything is handled for you. Install your production
server, then from the the development environment you set the
TargetServerURL (you can have multiple configuration, for instance I have a
debug server and a production server). To set the TargetServerURL you do a
right mouse click on the project in your solution explorer, properties.
Then you deploy from the IDE (you can also script this but using the Visual
Studio is easiest). It deploys the data sources as well and after deployment
you might need to configure them at the server. After deploying once VS does
not overwrite the data sources, it just warns, so once you setup the data
sources on your production server they will not get overwritten.
Be sure to read up on how to setup security as well on the production
server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R.Odermatt" <roger.odermatt@.nospam.swica.ch> wrote in message
news:uME3TRi%23EHA.1544@.TK2MSFTNGP11.phx.gbl...
> Hello
> I develop my reports local on my pc (VS2003, IIS5, SQL Server 2000 and
> ReportingServer are on the same Pc) and when i be finish then i want
> transfer the reports to official ReportingServer.
> Now my question witch files must transfer to the ReportingServer? And when
i
> transfer the files to another server then i think i must change the
> ReportingServer-Path, how can do that? I see that i can change the path in
> the VS-Project-Code, but can i do that purhaps with a Config-File or at
real
> time?
> Thank you very much
> Regards
> Roger
>
I develop my reports local on my pc (VS2003, IIS5, SQL Server 2000 and
ReportingServer are on the same Pc) and when i be finish then i want
transfer the reports to official ReportingServer.
Now my question witch files must transfer to the ReportingServer? And when i
transfer the files to another server then i think i must change the
ReportingServer-Path, how can do that? I see that i can change the path in
the VS-Project-Code, but can i do that purhaps with a Config-File or at real
time?
Thank you very much
Regards
RogerIf you are talking about reports ONLY , then the .RDL file is the only file
which must be transferred...
A common method is to use the Web interface on the production server to
UPLOAD the RDL files. That way you do not have to change anything on your
test side...Just tell the production guy where the RDL is.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"R.Odermatt" <roger.odermatt@.nospam.swica.ch> wrote in message
news:uME3TRi%23EHA.1544@.TK2MSFTNGP11.phx.gbl...
> Hello
> I develop my reports local on my pc (VS2003, IIS5, SQL Server 2000 and
> ReportingServer are on the same Pc) and when i be finish then i want
> transfer the reports to official ReportingServer.
> Now my question witch files must transfer to the ReportingServer? And when
i
> transfer the files to another server then i think i must change the
> ReportingServer-Path, how can do that? I see that i can change the path in
> the VS-Project-Code, but can i do that purhaps with a Config-File or at
real
> time?
> Thank you very much
> Regards
> Roger
>|||The only issue deployment might give you is if you have used jump to url
action. Otherwise everything is handled for you. Install your production
server, then from the the development environment you set the
TargetServerURL (you can have multiple configuration, for instance I have a
debug server and a production server). To set the TargetServerURL you do a
right mouse click on the project in your solution explorer, properties.
Then you deploy from the IDE (you can also script this but using the Visual
Studio is easiest). It deploys the data sources as well and after deployment
you might need to configure them at the server. After deploying once VS does
not overwrite the data sources, it just warns, so once you setup the data
sources on your production server they will not get overwritten.
Be sure to read up on how to setup security as well on the production
server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R.Odermatt" <roger.odermatt@.nospam.swica.ch> wrote in message
news:uME3TRi%23EHA.1544@.TK2MSFTNGP11.phx.gbl...
> Hello
> I develop my reports local on my pc (VS2003, IIS5, SQL Server 2000 and
> ReportingServer are on the same Pc) and when i be finish then i want
> transfer the reports to official ReportingServer.
> Now my question witch files must transfer to the ReportingServer? And when
i
> transfer the files to another server then i think i must change the
> ReportingServer-Path, how can do that? I see that i can change the path in
> the VS-Project-Code, but can i do that purhaps with a Config-File or at
real
> time?
> Thank you very much
> Regards
> Roger
>
Subscribe to:
Posts (Atom)