Any Help please!

Hi there
I am new to asp.net so I am not sure what I am doing wrong??
I have installed Visual Studio 2003, and the .net framework, we currently use sql server 2000
I have created a report in visual studion with raw SQL and I want to deploy it to my local host, however I get the message "no report server was found at (my server)"
I also tried to install reporting services but when I do I get the message "asp.net not registered with web server"
I know I am proberly missing something simple but I just cant locate it
Any help appreciated
Thanks
TimHi

catalystcommercial

You can't install SQL Reporting Services on a non server OS. You can only install a client version on XP to allow you to create SRS reports and preview them. When you build your SRS projects in VS 2003 it tries to deploy the report to your actual reportserver(server OS box). In your case you didn't specify a location. Do this : In VS2003. Click on Project >> Properties >> Configuration Properties >> Delpoyment. Fill in the "TargetServerURL" something likehttp:\\<server>\reportserver and add a TargetFolder to deploy the report to. Just click OK and build the Solution it will deploy the report to your SQL Reporting Server box.

, Hope this helps

l0n3i200n

|||

Hi

Thanks for the reply, I tried what you said and I still get the message "no report server was found at....."

PS: I am running this on our local server with server 2000

Regards

Tim

|||

There is a necessary sequence of events to follow:

Let me try to understand what you have posted -

Windows 2000 or 2003 was installed as the OS -

After installation did you go to MANAGE YOUR Server and indicate that within MANAGE YOUR SERVER ROLES the following:

Application Server indicate to configure Front Page Extensions and ASP.Net

After that you installed SQL 2000

Installed the service packs especially SP3a

Downloaded RSEVAL (Reporting Services)

Installed with SP1 and SP2

After reporting services was installed - go to IIS and select properties of Report Server and make sure anonymous access is disabled.

From your browserHTTP://localhost/reports

If you cannot get to the above http - then there are a bunch of minor issues - post back!

If you can get to above URL

edit administrator and ensure they can dio everything for the time being

Within your RS project point to your server and also to your database within the project properties and also ensure this is the dame within your data sources (shared) or spperate.

Data Source=YOUR SERVER NAME;Initial Catalog=YOUR DATA BASE NAME

Post back so we can help!

|||I read this post again - Run RSGEGISTER -- Done deal --|||

I am having the same problem. My SQL Server is on my machine. But the Report Server is on a server that I have to access, not on my machine. I keep getting the error:

---

An error has occurred during report processing. (rsProcessingAborted)Get Online HelpCannot create a connection to data source 'SANDO'. (rsErrorOpeningConnection)Get Online HelpAn OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.