Why would I get the following Error ?

[Recce]

Good day,

I have just started with Microsoft Reporting Solutions and do not know a lot about it. I can create reports and graphs and all sorts of nice stuff in the Visual Basic .NET environment on Reporting Solutions but, getting it on the web is a nightmare and I have not succeede in this ever since I have started with Microsoft Reporting Solutions.

I get the following error when trying to publish my reports to the web folder:

"No Report Server was found at "MyWebpath""

Would anyone be able to help me with this or even just a quick run through of what I need on my Web Server in order to publish Reports. Another thing, I do my development on my desk top pc and my server is somewhere elsse on the domain.

Thanks

"We know nothing but, that what we know is not the truth..." - Me

 

[ookete]

Do you know if your server is set up already? Like... can you go

http://MyWebServer/ReportServer

and see a list of files directories and files? Can you access the report manager at all yet?

 

[Recce]

Hi ookete,

Thanks for the reply. No I can not do any of that. I have also learned, since this morning that I do not have a Report service running on my box. I tried running the Setup.exe in "C:\SQLRSEVAL" and this told me that I need a Hotfix which is located in the below article on Knowledge Base

http://support.microsoft.com/default.aspx?scid=kb;en-us;821334#appliesto

Besides the above I can also see that there are other .exe's within the "C:\SQLRSEVAL" directory. Would you be able to tell me if I should run those ?

I would also like to know if it is neccesary for VB.NET to be installed on my server ?

Thanks for your time.

Regards

"We know nothing but, that what we know is not the truth..." - Me

 

[Catadmin]

Visual Studio .Net only needs to be installed on the server which you are using Report Designer. It needs to have a connection to a valid SQL Server too.

Not sure if VB .Net gives you the same interface, but the books all say Visual Studio, not Visual Basic, so that's what I would go with.

You have to have IIS running on the machine that you are going to have the Report Server & Report Manager on. Check the box to make sure that IIS is even running. If it is, check and make sure that your default directory has the proper permissions. Reporting Services ordinarily installes as two virtual directories in the Default Website of IIS. If you're installing to a different site than the default, you'll need to manually create the completely separate site for RS. THen change the .config files and run the aspnet_regiis.exe with the correct parameters.

If you installed IIS *after* you installed the Report Server, you'll need to manually register RS with the IIS server.

BTW, I'm getting all my info from HitchHiker's Guide to SQL Server 2000 Reporting Services. It's a really good reference book.

Does any of this help you out?



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[Recce]

Thanks for the reply Catadmin.
I have Visual Studio .Net on my client pc (desk top pc). Yes, I have a valis SQL server and I can connect to it from my pc via Visual Studio .NET in order to build my reports.
The reports look good and it has all the data in it that they should so, I am happy with that. I'm sorry, I sead VB .NET but, I meant Visual Studio .NET

Yes, IIS is running and it has been running for a while since I use it to access spread sheets and other documents via IE6. IIS was installed first and only after that did I install Reporting Services.

I am going to phone around now to get that "HitchHiker's Guide to SQL Server 2000 Reporting Services". Thanks for the help.

"We know nothing but, that what we know is not the truth..." - Me

 

[ookete]

Catadmin is correct. RS has a few components that we can break down:

Report Server
This is the server that serves out the reports to your applications or other delivery methods. It resides on a web server with IIS installed.

Report Manager
This is the web interface that allows you to manage reports. It also resides on your web server with IIS installed.

Report Designer
This is the design interface that you've been working with. It can be installed on any machine that has .NET.

SQL Server 2000 database
The Report Server above uses SQL Server to store all of the report information, schedules, etc. So your web machine that hosts the Report Server needs to be able to access SQL Server and create a database there. I don't believe it has to be the same machine... it can be different.

It is feasible that you could have all of this on the same box, but you would need all three of these: IIS, SQL Server 2000, and Visual Studio .NET. In my case however (and more commonly) we have a box for our web server, one for database storage, and my local development machine. Reporting Services needs to be installed on the web server (only the Server and Manager components) and on my dev machine (only Design component). RS does not need to be installed on the database box... the web server just needs access to the database.

I hope this helps. Until you get your Report Server and Report Manager working, you will only be able to view your reports locally on your dev machine. Good luck.

By the way... in order to publish a report, you access the Report Manager and simply click the button "Upload Report", which brings up a copy of your local compiled .rdl (report definition file) to the Report Server. You access the Report Manager by opening a browser and typing "

http://MyWebServer/reports".

This is assuming you have successfully installed the manager, of course.

 

[Recce]

Hi ookete,

Thanks for the explenations. It help me to beter understand how everything fits together.
I am unsure how to install Report Manager and Report Server because I only had one large .exe that I got from the web and I installed that and that is it.
I presume I am on the right track if I run the Setup.exe that I found in C:\SQLRSEVAL directory ?

"We know nothing but, that what we know is not the truth..." - Me

 

[ookete]

Yes, your C:\SQLRSEVAL folder contains the same installation that you would run on any machine, whether it is the web server that will host the Server and Manager, or whether it is your development machine running the Designer.

From what I remember, the installer checks to see if you have certain requirements met (IIS, VS.NET, SQL Server) and gives options to install components accordingly. For example, if you only had VS.NET on your machine when you ran the Setup, then you would only have the Designer installed. If later you activated IIS and SQL Server, the the Report Server and Manager still would not work... you would need to reinstall the Setup from your C:\SQLRSEVAL folder.

 

[Catadmin]

Did you actually run the setup on the box that has IIS on it, or just on your desktop?

If the later, re-run the setup on the box with IIS to get Report Server & Report Manager installed.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[Recce]

Hi everyone,

Thanks for the info. Yes, I ran the Setup.exe on my server which has IIS and SQL but not Visual Studio.net I am running this Setup.exe long after everything (IIS and SQL server)was installed.

My problem however is that when I do run the Setup.exe then it stop in the middle and informs me that I need to install a HotFix first. Apparently this HotFix changes/install something that is needed by my server. So, I will get try and get that fix this week and then I will run the Setup again and I will let everyone know if it was successful. Thank you so much for all the info and your time. I am really learning so much from everyone. Regards

"We know nothing but, that what we know is not the truth..." - Me

 

[Recce]

Good day everyone,

I am back. I have now installed SP4 and the Hotfix which RS needed. It looks like RS is installed 100% and I can even see the Report Server Service. The service is running however, when I type

http://MyServer/Reportserver

then, I still see nothing. Problem is I have no idea what to go and change, tweak or install. Any sugestions ? Please

"We know nothing but, that what we know is not the truth..." - Me

 

[Catadmin]

When you are typing this, are you typing it from the client PC or the PC that has IIS installed? If you're working from the client, got to the actual IIS box and check permissions both on the default website and the Reporting Services permissions. RS has a screwy permissions setup so that if you don't have permissions to see the home folder, you can't see anything. IIS is just as bad. If, for some reason, you don't have permissions to see the default website, you can't see anything.

BTW, you never did answer my comment about if you installed RS on a non-default website or not. Did you? If so, recheck my first reply. There's hoops to be jumped through to get the non-default IIS website working with RS.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[nvegamarrero]

I just want to know how can I publish my reports manually.
I mean ,copying the Files or something like that not using the VS.NET

 

[Catadmin]

Nvegamarrero,

First, you'll get a better response if you start a new question in a new thread instead of tacking it onto a thread that doesn't have a lot to do with your question.

Secondly, when you repost, please explain what you mean by manually publishing your reports.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???