Trouble with MS SQL 2000 Reporting Services


Recommended Posts

Need help or at least some guidance with MS SQL 2000 Reporting Services. There are 3 servers that are important in this configuration:

Server 1: Windows 2000 Server running IIS 5.0

Server 2: Windows 2000 Server running MS SQL Server 2000 Std, also primary DC

Server 3: Windows 2000 Server running Terminal Services, and MS Visual Web Developer Express 2005.

Because I work from home most of the time I figured that I'd install VWDE on the TS. I could not find out which of the machines I should install Reporting Services (RS) on, so I started by putting it on server #3, figuring I could work from home on the reporting stuff. The install failed, it said RS requires IIS 5.0, ASP.NET 1.1, and Visual Studio .NET 2003 and SQL server. It doesn't seem to recognize VWDE 2005 as an upgrade path to VS .NET 2003 (is it? I'm not sure).

So then I tried the install on the SQL Server (#2). The install gave me warnings about: no IIS 5.0, no ASP.NET 1.1, no Visual Studio .NET 2003. Then I clicked continue and it gave me an error code 1603 "SetDialogs".

At that point I gave up for the time being subject to more research. What I discovered was some info on the error 1603 here and here, but am I going down a path to failure anyway?

Rather than solve the technical problems with the install, I'm looking for guidance in terms of getting SQL Server 2000 Reporting Services to work when IIS 5.0, SQL Server 2000, and MS Visual Web Developer Express 2005 are all on different computers. I can't seem to find anything that tells me outright whether it is a valid setup or not. Also I don't know if RS will work with VWDE 2005 instead of VS .NET 2003? The goal is to get reporting set up for administrators and end users.

Failing this, I will be evaluating Crystal Reports and a few open-source reporting packages. Also should mention that what is not up for discussion at this point is upgrading the servers to more current versions.

Any help would be most appreciated.

Thanks for your help bobbba, I discovered in the meantime that RS 2000 only plays nice with VS .NET 2003 but not any of the current 2005 tools. I can't risk going to all the trouble of getting old reporting tools to work only to have something else in the future break them, so I'll be looking at non-MS reporting. Props to you btw, I got no replies in the last 2 days on MSDN or MS Technet regarding this... :(

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • No, my laptop really, truly does not meet the specs for Copilot, which is no doubt why it was never installed. So there's no problem here to solve.
    • This feature has been useful when applying for jobs and creating/editing cover letters in seconds! Not worried MS might see the jobs I'm applying to 🤣
    • What annoys me is the people that try to buy a higher end product, and then low ball you, and say but I don't need that function, all I need is to use it for video out so I don't feel like paying higher price.   I had a person that was trying to buy RTX 3080 from me for $100 and his excuse was, well I won't be playing games on it, I just need four monitor outout. Or someone was trying to buy 2TB Gen5 M.2 for $50, well I don't need the speed, is just for basic storage. Or i was offered $80 for 20TB hard drive, that person said well, right now I only about 7TB, so rest won't be in use Just some examples in last month or two...   The guy with the 3080, I replied to with something like go to Chevy dealer and offer them $15K for that brand new corvette and tell them that you you only need to drive to work, so you don't need to go fast.   There a lot of low ballers that try to take advantage.
    • Not in Syracuse, NY. They're about to break ground! https://www.syracuse.com/micro...on-and-other-tech-jobs.html
    • Here in Finland we have lots of rural areas with narrow roads, one of the highest taxes in the world (cars are taxed way above EU standards) and fuel is quite expensive. Yet we educate our drivers to drive responsibly and safely in all areas, and our people respect each others rights and freedom to move around safely. Which is why we have even small children under 10 years old walking and cycling alone to schools in the streets, even in big cities. Safety is about being responsible and about respecting others. And I would hate to see AI (or anyone else) destroy our way of life. There are and always will be outliers, accidents happen and machines break. I dont't want to see people relying on AI to do things like driving for them. I want people to think and react to the world around them themselves, and being responsible instead of them browsing TikTok or whatever instead of looking out the window, and then saying that "It wasn't me, it was the car". Already people walk around town with their eyes glued to a screen – I don't want people driving around the same way.
  • Recent Achievements

    • One Month Later
      POR2GAL4EVER earned a badge
      One Month Later
    • One Year In
      Orpheus13 earned a badge
      One Year In
    • One Month Later
      Orpheus13 earned a badge
      One Month Later
    • Week One Done
      Orpheus13 earned a badge
      Week One Done
    • Week One Done
      serfegyed earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      537
    2. 2
      ATLien_0
      250
    3. 3
      +FloatingFatMan
      178
    4. 4
      +Edouard
      166
    5. 5
      Xenon
      118
  • Tell a friend

    Love Neowin? Tell a friend!