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

    • Windows Server 2025 security baseline to get more frequent updates, streamlines settings by Paul Hill Microsoft has announced the release of the June 2025 revision of its security baseline package for Windows Server 2025 (v2506), it is now available to download from the Microsoft Security Compliance Toolkit. After downloading it, you can test the recommended configurations in your environment and customize or implement them as you see fit. To deal with the evolving threat landscape, new Windows features, and community feedback, Microsoft is planning to revise the Windows Server baseline more frequently in the future. Windows Server security baselines are a collection of Microsoft-recommended configuration settings that help administrators establish secure and consistent Windows Server environments. This is the first security baseline update for Windows Server 2025 since January, a summary of the changes is presented in this table: Security Policy Change Summary Deny log on through Remote Desktop Services Allow remote logon for non-admin local accounts on MS and add “BUILTIN\Guests” to both DC and MS. WDigest Authentication Remove from the baseline Allow Windows Ink Workspace Remove from the baseline Audit Authorization Policy Change Set to “Success” in both DC and MS Include command line in process creation events Enable in both DC and MS Control whether exclusions are visible to local users Moved to Not Configured as it is overridden by the parent setting. Of these changes, the removal of WDigest Authentication and the addition of Include command line in process creation events are significant. Microsoft said it removed WDigest Authentication from the security baseline because it is no longer necessary for Windows Server 2025. The policy was originally enforced so that WDigest couldn’t store plaintext passwords in memory, which was a significant theft risk. Since the 24H2 update in Windows Server 2022, the policy has been deprecated, so there’s no need to enforce this setting. The update also adds Include command line in process creation events to improve the visibility of how processes are executed across the system. By capturing the command-line arguments, it makes it easier to detect and investigate malicious activity that may otherwise seem legitimate. If you want to learn more about the other changes in a bit more depth, refer to Microsoft’s announcement of this security baseline update.
    • Camtasia 2025.1.3 by Razvan Serea TechSmith Camtasia is the complete professional solution for high-quality screen recording, video editing and sharing. Camtasia 2023 makes editing your videos easier, and faster than ever. The new editor is packed with enhanced video processing, all-new production technology, an innovative library, and stock videos and other creative assets to help you create more polished, professional videos. No video experience needed. Anyone can create informative, engaging videos. Create professional, eye-catching videos: Add special video effects - Apply Behaviors that are perfectly designed to animate your text, images, or icons. Get a crisp, polished look without being a professional video editor. Drag-and-drop your edits - What you see is what you get. Every effect and element in your video can be dropped and edited directly in the preview window. And you can edit at resolutions up to beautiful 4K, for clear video at any size. Get exceptional performance - Camtasia takes full advantage of your computer’s processor with 64-bit performance. You’ll get fast rendering times and enhanced stability—even on your most complex projects. Camtasia 2025.1.3 changelog: New Features Added the Edit Image in Snagit feature. Allow importing SNAGX files as images. Feature Updates Add ability to double click the FPS button and open the project settings menu. Background tab in the Rev window is updated with new files. Added user configurable keyboard shortcut for Add Audio Point. Updates for IT Administrators swfobject.js was unused and has been removed from the install. Bug Fixes Fixed a bug where video streams in MTS files could fail to decode. Fixed a bug with the FPS button so it no longer opens up the playhead time control. Fixed a bug with tooltips that prevented shortcut commands from displaying correctly. Fix a bug where MP4 files recorded on Google Pixel 7 Pro could fail to decode video. Fixed a crash when ripple replacing the placeholder with legacy noise reduction effect. Fixed a bug that could cause some ADPCM audio streams to be ignored. Fixed a bug where a group's audio waveforms would not update after a trim and undo. Fixed an issue where the media Duration popup could leave a 1 frame gap between media. Fixed a bug where the installer could hang when running it quietly when the app is already installed. Fixed a bug where the installer could hang on exit after running it when another installation was already in progress. Fixed a user-reported licensing error. Download: Camtasia 2025.1.3 (64-bit) | 335.0 MB (Shareware) View: Camtasia Homepage | Tutorials | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • From what I understand, RAID 1 makes a copy of one disk. How does it do this? If something happened to one drive, could I take the other one out, plug it into a PC and use it like a normal disk? I have two hard drives that have the same information on - a bit of protection if one drive fails. But I've just been manually copying the data twice.
  • Recent Achievements

    • One Month Later
      Leonard grant earned a badge
      One Month Later
    • Week One Done
      pcdoctorsnet earned a badge
      Week One Done
    • Rising Star
      Phillip0web went up a rank
      Rising Star
    • One Month Later
      Epaminombas earned a badge
      One Month Later
    • One Year In
      Bert Fershner earned a badge
      One Year In
  • Popular Contributors

    1. 1
      +primortal
      537
    2. 2
      ATLien_0
      205
    3. 3
      +FloatingFatMan
      167
    4. 4
      Michael Scrip
      151
    5. 5
      Som
      126
  • Tell a friend

    Love Neowin? Tell a friend!