Having a very hard time trying to install some SQL 2005 tools

  • I'm trying to get a couple of ASP.NET 2.0 apps installed onto our new web server. I've run into a problem installing it; I can't remember but I think I've posted a message on this list about it. We install both of these apps using a .MSI setup, because we've got to get Crystal Reports XI Release 2 onto the server (we use several reports written in Crystal). The setups fail immediately, before it has a chance to do anything. I finally found a way to get the msiexec to write to a log file, and have looked it over. It appears to me that the problem is it can't find a MSOLAP.DLL file on the server. In researching that I've found that Windows 2008 R2 Web Server already has OLAP services installed, so this installer is looking for something that is no longer relevant. So now I'm trying to find a way to get rid of the dependency upon OLAP. I've looked through all of our code, and there's nothing in there that uses OLAP services, so frankly I'm guessing the culprit is Crystal (the bane of my existence these days). So I found a way of editing the dependencies the Crystal reports in VS 2005. I've spent time doing that and have gotten it down to only what we need. Then I started another build of the .MSI, and at this point I ran into another problem, which I don't understand and has me stumped.

    For some reason trying to build the new setup requires that it run a SqlRun_Tools.msi file. I've pulled out our SQL Server 2005 DVD's, and found the file there, and tried to install it. It failed. I next went through old MSDN DVD's we've got, found the file on them, and have tried to use them, but that fails again. I've even copied SqlRun_Tools.msi onto my old XP machine (where I've got VS 2005 installed, and where I used to make the .MSI files for installing onto our old web server back years ago), and tried running it there, but it fails. Each and every time it's failed, it gives me an error saying:

    The feature you are trying to use is on a CD-ROM or other removable disk that is not available.

    Insert the ‘Microsoft SQL Server 2005 Tools' disk and click OK.

    Well, I'm using the only media I've got, back when we first installed SQL 2005 on our database server, years ago. I'm really stumped and at a complete loss as to what to do and how to proceed.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • Seems to be the SQL Edition issue, can you try the same binaries which you did earlier. That time it will succeed.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply