Report Moving Script

Does anyone have a script that they would like to share that would move some directory and it's tree from one server to another?
Thanks!
ScottI don't have one but note that reports are not in any directories. They are
stored in the database. They only exist in files on the development
machines. When you deploy they are stored in the database.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:ecuGSBr8EHA.4072@.TK2MSFTNGP10.phx.gbl...
> Does anyone have a script that they would like to share that would move
some directory and it's tree from one server to another?
> Thanks!
> Scott
>|||Right, but the whole API is also scriptable, correct?
I'm just wondering if there is a script that I can use with the RS script engine that will move reports (i.e. from dev to prod)
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message news:uHEwIEr8EHA.1452@.TK2MSFTNGP11.phx.gbl...
>I don't have one but note that reports are not in any directories. They are
> stored in the database. They only exist in files on the development
> machines. When you deploy they are stored in the database.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
> news:ecuGSBr8EHA.4072@.TK2MSFTNGP10.phx.gbl...
>> Does anyone have a script that they would like to share that would move
> some directory and it's tree from one server to another?
>> Thanks!
>> Scott
>>
>|||Yes you can script it and RS ships with an example. I'm at home so I can't
tell you where it is. Note that you can setup multiple targes for deploying
from Visual Studio. Also, you can deploy a single report, multiple reports
or all reports. The first time you deploy the data sources get deployed and
then you need to go to Report Manager and reconfigure them to go against
your production data but thereafter the default is to not overwrite the data
sources so you just get a warning that it couldn't deploy the data sources.
You might want to play around some with the capabilities in the designer for
deployment before deciding you need to script it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:OSVmFqt8EHA.3336@.TK2MSFTNGP11.phx.gbl...
> Right, but the whole API is also scriptable, correct?
> I'm just wondering if there is a script that I can use with the RS script
> engine that will move reports (i.e. from dev to prod)
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uHEwIEr8EHA.1452@.TK2MSFTNGP11.phx.gbl...
>>I don't have one but note that reports are not in any directories. They
>>are
>> stored in the database. They only exist in files on the development
>> machines. When you deploy they are stored in the database.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in
>> message
>> news:ecuGSBr8EHA.4072@.TK2MSFTNGP10.phx.gbl...
>> Does anyone have a script that they would like to share that would move
>> some directory and it's tree from one server to another?
>> Thanks!
>> Scott
>>
>>
>

Report Manager Virtual Directory disabled

Hi,
I have problem with Reporting Services 2005 configuration on Win2k3.
Every setting has green mark, except Rprt Manager Virtual Directory
which is grey and Web Service Identity has not configured mark. And I'm
aware that during instalation RS didn't add Reports dir to IIS, but I
don't know why.
Has anyone met with that problem?
Regards,
BartoloHi,
Yes I have just this same problem - but on an XP machine with SP2 (needed
for a demo setup).
Complete new install of SQLExpress Adv version. ReportServer is installed,
but Report Manager is grayed out.
Any resolution anyone please '.
Regards
Graham
"Bartolo" <andrew.osa@.gmail.com> wrote in message
news:1152266153.281436.141940@.k73g2000cwa.googlegroups.com...
> Hi,
> I have problem with Reporting Services 2005 configuration on Win2k3.
> Every setting has green mark, except Rprt Manager Virtual Directory
> which is grey and Web Service Identity has not configured mark. And I'm
> aware that during instalation RS didn't add Reports dir to IIS, but I
> don't know why.
> Has anyone met with that problem?
> Regards,
> Bartolo
>|||Hi,
OK - I just managed to get past this problem :-).
The issue seems to be that I failed to select 'Report Manager' during
initial installation - even though I DID select Reporting Services - Report
Manager seems to be unselected by default !!.
The problem however is then :
1. Re-running the original SQL Express Adv installer, and checking Report
Manager - then tells me that there is nothing to install !! - it apparently
LIES.
2. Running Add/Remove programs, select SQL Server, Change takes me to the
re-install screens BUT my original installation folder was temporary and so
has been deleted :-O.
To get around this problem :
1. Run the main installer again, but at the point where it says nothing to
insall use Explorer to grab a copy of the installers temporary SQL 'Setup'
folder, and store this somewhere safe. Then let the installer exit and
delete its files - you're left with your copy ;-).
2. Run Add/Remove etc - select Report Manager and continue until it
complains that it cannot find 'sqlrun_rs.msi' (as its pointing at the (now
deleted) temp folder. Point this to your copied folder and the install
completes :-)).
Now run the config tool and it shows Report Manager is available !!.
Now all I have to do is to fix the ASP.NET permissions - as it now complains
that the ASP.NET account used to access the webservice (and which I cannot
change) does not have access to the GAC :-O.
Some hoops huh :-O. Maybe Microsoft can comment on the installation failures
?.
NB I already have RS installed on a 2003 server and went through a different
set of hoops to get it running on there :-O.
Hope this helps...
Regards
Graham
"Bartolo" <andrew.osa@.gmail.com> wrote in message
news:1152266153.281436.141940@.k73g2000cwa.googlegroups.com...
> Hi,
> I have problem with Reporting Services 2005 configuration on Win2k3.
> Every setting has green mark, except Rprt Manager Virtual Directory
> which is grey and Web Service Identity has not configured mark. And I'm
> aware that during instalation RS didn't add Reports dir to IIS, but I
> don't know why.
> Has anyone met with that problem?
> Regards,
> Bartolo
>|||Hi Graham,
Thx for help, now I'm on holiday.
So I'd check your solution as soon as I come back to the job.
Then I'll share with my experience.
Regards,
Bartolo|||Thank you for this information, helped me get the Report Manager up and running on my XP box
From http://www.developmentnow.com/g/115_2006_7_0_0_784539/Report-Manager-Virtual-Directory-disabled.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager and The request failed with HTTP status 400

I have installed Reporting services on a win2k3 on a completely different
irtual Directory than Default Directory .My Report Server is working fine
but I can't get my reporting manager working it give me this error:
The request failed with HTTP status 400:bad request,
Is there somebody who can help me.
ThnaksI think I got the answert ,,
I'm using a DNS for the new virtual directory that I have installed report
server and report manager on it and I forogt to update <ReportServerUrl> in
the RSWebApplication.config file of "Report Manager"
in the following address:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
It was pointing to the wrong address http://localhost/reportsver where as it
should be http://MyDNS/reportsver.
HTH,
ALI-R
"ALI-R" <newbie@.microsoft.com> wrote in message
news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> I have installed Reporting services on a win2k3 on a completely different
> irtual Directory than Default Directory .My Report Server is working fine
> but I can't get my reporting manager working it give me this error:
> The request failed with HTTP status 400:bad request,
> Is there somebody who can help me.
> Thnaks
>|||Hi all,
we're still in trouble as our ReportManager webapp still won't work.
I verified the RSWebApplication.config files of both Report Manager and
Report Server to contain
<ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
and
<UrlRoot>http://localhost/ReportServer</UrlRoot>
respectively.
I already verified all permissions and even changed both above URLs to read
http://<servername> instead of localhost. This does not make any noticable
difference.
This is real trouble, MS, I'd hate to have to resort to reïnstalling
everything from scratch, as there's no telling how if, or how long, this will
work...
Please help? :o(
Ramses.
Still, the ReportServer works just fine on both
http://localhost/ReportServer and http://severname/ReportServer, wheras the
ReportManager simply refuses to work. It keeps yielding the dreaded
The request failed with HTTP status 400: Bad Request.
"ALI-R" wrote:
> I think I got the answert ,,
> I'm using a DNS for the new virtual directory that I have installed report
> server and report manager on it and I forogt to update <ReportServerUrl> in
> the RSWebApplication.config file of "Report Manager"
> in the following address:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
> It was pointing to the wrong address http://localhost/reportsver where as it
> should be http://MyDNS/reportsver.
> HTH,
> ALI-R
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> > I have installed Reporting services on a win2k3 on a completely different
> > irtual Directory than Default Directory .My Report Server is working fine
> > but I can't get my reporting manager working it give me this error:
> >
> > The request failed with HTTP status 400:bad request,
> >
> > Is there somebody who can help me.
> >
> > Thnaks
> >
> >
>
>|||Hi all,
we're still in trouble as our ReportManager webapp still won't work.
I verified the RSWebApplication.config files of both Report Manager and
Report Server to contain
<ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
and
<UrlRoot>http://localhost/ReportServer</UrlRoot>
respectively.
I already verified all permissions and even changed both above URLs to read
http://<servername> instead of localhost. This does not make any noticable
difference.
This is real trouble, MS, I'd hate to have to resort to reïnstalling
everything from scratch, as there's no telling how if, or how long, this will
work...
Please help? :o(
Ramses.
"ALI-R" wrote:
> I think I got the answert ,,
> I'm using a DNS for the new virtual directory that I have installed report
> server and report manager on it and I forogt to update <ReportServerUrl> in
> the RSWebApplication.config file of "Report Manager"
> in the following address:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
> It was pointing to the wrong address http://localhost/reportsver where as it
> should be http://MyDNS/reportsver.
> HTH,
> ALI-R
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> > I have installed Reporting services on a win2k3 on a completely different
> > irtual Directory than Default Directory .My Report Server is working fine
> > but I can't get my reporting manager working it give me this error:
> >
> > The request failed with HTTP status 400:bad request,
> >
> > Is there somebody who can help me.
> >
> > Thnaks
> >
> >
>
>|||I would check the host header in IIS. I have been having a problem
where I can't view the report properties, export a report, or schedule
a report (viewing is fine, though).
I was messing with the host headers in IIS and got that message if I
had things configured incorrectly. For working locally, you should
probably not have anything in the host header value for the site.|||I have no Host-headers set for the default website - checked this numerous
times. The default website is bound to both 127.0.0.1 and the LAN IP address
of the server. Note that my http://<servername>/Reports tests wouldn't have
worked otherwise.
Still at a loss. :o(
"cybermud" wrote:
> I would check the host header in IIS. I have been having a problem
> where I can't view the report properties, export a report, or schedule
> a report (viewing is fine, though).
> I was messing with the host headers in IIS and got that message if I
> had things configured incorrectly. For working locally, you should
> probably not have anything in the host header value for the site.
>