Need suggestion for reports software

Hi,

We have Visual Studio 2005 , Crystal Reports, SQL Server 2005 Express Edition.

our Manager asked about the best and easiest reporting software other than Crystal Reports.

I didn't work with reports. Please assist me, if any one have idea.

Thanks in advance

Regards

Jyothi

I have worked with crystal reports and Sql Server Reporting Services and SSRS for all its problems, beats crystal and not just on price. The points with SSRS to watch are:

Choose the right style at the outset as difficult to change afterwards.|||

I tried Crystal it is expensive but has a lot of predefined functions that SSRS doesn't. But I elected to you SSRS I like it better it is easy to use and very flexible. I just wish it would conform to the same formats as excel. I found out you can not have over 160 in in viewable colum space width. Excel allows 256...

|||

Hello,

I'm currently working on SQL Reports and found out that they are better than Crystal and DEV express reports. I'm implementing a localisation functionality with ASP.net and they are very flexible.

Here are the key features.

1- Easy to integrate with ASP.net site

2- Build custom assembly and use it in your report or use VB for embeded coding.

3- Free of cost with SQL Express.

4- Plenty of support/samples and knowledge base.

5- Free of cost report designer (Business IntelligenceProject)

Thanks,

Farooq

|||

Check these links to see the features of reporting services

http://msdn2.microsoft.com/en-us/library/ms159273.aspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

Check this post for a good discussion on Crystal Reports .NEt vs. SSRS :

http://asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=720164

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

need helps in this store procedure?

Hi Everyone,

I appreciate if you can help on the following procedure. When I ran it in my project in Visual Studio, the compiler always complained that it expected a parameter "@.stud_id" that was not provided. What was wrong with this procedure?

Thank you for your help.

a123.

ALTER Procedure registerstudent
(
@.email nvarchar(100),
@.student_password nvarchar(10),
@.first_name nvarchar(25),
@.last_name nvarchar(25),
@.address nvarchar(255),
@.city nvarchar(50),
@.province nvarchar(25),
@.country nvarchar(50),
@.phone_no_cell nvarchar(25),
@.phone_no_home nvarchar(25),
@.hour_rate int,
@.status char(1),
@.stud_id int output

)
As

INSERT INTO student
(
email,
student_password,
first_name,
last_name,
address,
city,
province,
country,
phone_no_cell,
phone_no_home,
hour_rate,
status

)
VALUES
(

@.email,
@.student_password,
@.first_name,
@.last_name,
@.address,
@.city,
@.province,
@.country,
@.phone_no_cell,
@.phone_no_home,
@.hour_rate,
@.status

)

SELECT
@.stud_id = @.@.identity

Did you add an output SqlParameter to your code?

Ryan

|||

Need to know how you execute the sp in your code BTW, usually we use SCOPE_IDENTITY() instead of @.@.identity. For the differences, you can refer to:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_6n8p.asp