Report Viewer not available in VB Express?

I'm trying to use report viewer controls, but the controls do not appear in the toolbox. The file reportviewer.exe was not in the location specified in the help files, but I have downloaded it, and when I try to add it to the toolbox, I get the message 'ReportViewer.exe' is not a .Net module. Should there be a .dll somewhere? Is it not possible to use this control w/ VB Express / SQLExpress?

ReportViewer.exe contains the dlls for the controls. You need to run it to extract the dlls, and install them in the GAC. See http://msdn2.microsoft.com/en-us/library/ms251723(VS.80).aspx

Report Services installation problem

I've installed SQL Express 2005 on an XP Professional machine and I'm trying to configure Report Services. In Reporting Services Configuration Manager, all items are "green" except "Web Service Identity". The value is <machinename>\ASPNET and isn't configurable. I've searched the forums and followed the advice I've found to remove and reinstall .NET, but it hasn't helped. User ASPNET does exist on the machine with a local account, and IIS5 is running. SQL gurus, please help me figure out what to do! Thanks.The Web Service Identity is supposed to be read-only. If everything is grean RS should be already configured and good to go. What's not working?|||

I apologize - I didn't offer full details. I was frustrated!

Clicking "Apply" on the "Web Service Identity" dialogue results in an error. Clicking the link for details reveals this:

---

ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias.

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

---

The ASPNET user does exist however! I don't understand what's wrong. Thanks for your help.

|||

Not sure what's going on. It's seeme like there is something wrong with the ASPNET account. Is ReportServer vroot in IIS running under asp.net 2.0. Are any other web applications on that machine working OK?

|||That's a little over my head, I know little about IIS. Other "web pages" are accessible, such as http://localhost/printers and http://localhost/tsweb. This machine is dedicated to running SQL Server Express, so no other applications are running that I can test for web connectivity. Any direction you can point me in is greatly appreciated! Thanks again for your help.|||

1. Open up Internet Information Services applet in the Administrators group.

2. Right-click on the ReportServer node and choose Properties. Flip to the ASP.NET tab. What's the ASP.NET version?

|||The ASP.NET version is 2.0.50727. Thanks for helping me through this!

Report Services installation problem

I've installed SQL Express 2005 on an XP Professional machine and I'm trying to configure Report Services. In Reporting Services Configuration Manager, all items are "green" except "Web Service Identity". The value is <machinename>\ASPNET and isn't configurable. I've searched the forums and followed the advice I've found to remove and reinstall .NET, but it hasn't helped. User ASPNET does exist on the machine with a local account, and IIS5 is running. SQL gurus, please help me figure out what to do! Thanks.The Web Service Identity is supposed to be read-only. If everything is grean RS should be already configured and good to go. What's not working?|||

I apologize - I didn't offer full details. I was frustrated!

Clicking "Apply" on the "Web Service Identity" dialogue results in an error. Clicking the link for details reveals this:

---

ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias.

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

---

The ASPNET user does exist however! I don't understand what's wrong. Thanks for your help.

|||

Not sure what's going on. It's seeme like there is something wrong with the ASPNET account. Is ReportServer vroot in IIS running under asp.net 2.0. Are any other web applications on that machine working OK?

|||That's a little over my head, I know little about IIS. Other "web pages" are accessible, such as http://localhost/printers and http://localhost/tsweb. This machine is dedicated to running SQL Server Express, so no other applications are running that I can test for web connectivity. Any direction you can point me in is greatly appreciated! Thanks again for your help.|||

1. Open up Internet Information Services applet in the Administrators group.

2. Right-click on the ReportServer node and choose Properties. Flip to the ASP.NET tab. What's the ASP.NET version?

|||The ASP.NET version is 2.0.50727. Thanks for helping me through this!

Report Server/Reporting Data Services in SQL 2005 Express

As stated in this page:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
The above-mentioned features are to be part of SQL Server 2005 Express at a
future date.
Does anyone know when this is to be?
TIA,
Eddy VugteveenEddy,
Take a look at
http://www.microsoft.com/downloads/details.aspx?familyid=57856CDD-DA9B-4AD0-9A8A-F193AE8410AD&displaylang=en.
You need the SQL Express with Advanced Services Edition.
I believe that the definitive version of SP1 should be available later
this month.
Andrew Watt [MVP]
On Thu, 13 Apr 2006 04:47:02 -0700, Eddy Vugteveen <Eddy
Vugteveen@.discussions.microsoft.com> wrote:
>As stated in this page:
>http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
>The above-mentioned features are to be part of SQL Server 2005 Express at a
>future date.
>Does anyone know when this is to be?
>TIA,
>Eddy Vugteveen|||Hi Andrew
The information I got from someone in Microsoft was Reporting services
was still not available for SQL Express.
If as you say Reporting Services is available in reporting Services how
does the licensing work
Thanks
Karen

Report server not inizialized after installation

Platform : SQL Server Express SP2 with advanced services

I have an install script that installs all of the services and features with the exception of management studio express. My install script is very basic, the only addition was to have RSSQLOCAL=1, and I set RSCONFIGURATION=Default.

After the installation, when I navigate to localhost\Reports$SQLEXPRESS or localhost\ReportServer$SQLEXPRESS, I get an authentication error. When I go into the reporting services configuration manager, everything looks OK, but the 'Initialized' status is 'NO' under status. If I go to 'Database Setup', choose Connect, and then 'Apply', the reporting services now becomes initialized, and everything seems to be OK.

What is the reason for this manual step in the reporting configuration manager? Any ideas?
I don't know why that happens either. A bit of a mystery...but trust me, if that is the only problem you had installing....... You're Lucky.|||Hmmm,

Thanks for the reply.

Sounds like installation can be a huge headache for SSRS. Has anyone compiled a page with install issues and resolutions for SSRS?
|||According to this post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=838483&SiteID=1

You simply have to restart the PC for it to be initialized.
|||

ajhuddy wrote:

Hmmm,
Has anyone compiled a page with install issues and resolutions for SSRS?

Yes, a good portion of these forums.

Report Server Instalation - please help!!!

Hey,

I've installed the reporting services with the SQL EXPRESS 2005.

I've succeed to make some reports, and now i want to deploy them.

When i'm trying to run the reporting services configuration manger, i get the message "bad namespace". ican't connect in the instalation window to any machine that i'm trying to connect.

iI've tried to connect my computer, other computers with SQLEXPRESS and with SQL 2000, but i didn't succed.

How i should configure the report server ?

please, help !

Please HELP S.O.S !!!!

Report server

I am using sql express. I started report server using window services. It started and stopped automatically. How can it be kept going? I did use the configuration utility in report server.

thanks,

hobby

Hi Hobby,

Could you, please, take a look in the Reporting Services windows service log file to see what error you find there?

I would also recommend to take a look in the event viewer to see what was logged there regarding the stop of your service.

The Reporting Services windows service log file lives in this directory:

%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles

and its name looks like this:

ReportServerService__<timestamp>.log

Mihaela