I've been trying for the last couple of days to install a couple of older ASP.NET 2.0 apps on our new Windows 2008 R2 Web Server, running IIS 7.5. We had to make these apps installable using .MSI files, so we could put Crystal Reports XI Release 2 on, as
a merge module. Whenever I run the .MSI files they fail immediately. I was able to make the .MSI files generate verbose log files, so I could try and figure out what's wrong. It appears to me as though the .MSI file is looking for a MSOLAP.DLL file, which
it can't find, and then it aborts.
In looking around I've found that the MSOLAP.DLL is Microsoft's OLAP Services DLL. I've spent about 2 days trying to figure out what installs that, where it comes from, etc. I think I've finally found that it would be installed by running the Microsoft
Data Access Components (MDAC). I'm wondering, if it safe to install MDAC on a Windows 2008 R2 Web Server? According to the link I gave, it is already
installed on a Windows 2003 Server, but I'm working with 2008 R2, and that documentation doesn't say anything about it. And, BTW, I've tried searching for MSOLAP.DLL, and it's not on my 2008 R2 server.
MDAC is not available (and will not install) on Windows 2008. Its successor is Windows DAC 6.0, but you should already have it because its part of the OS.
Windows Data Access Components (WDAC): MDAC changed its name to WDAC - "Windows Data Access Components" since Windows Vista and Windows Server 2008. WDAC is included as part of the operating system and is not available separately
for redistribution. Serviceability for WDAC is subject to the life cycle of the operating system.
This message is provided "AS IS" with no warranties, and confers no rights!
Please 'Mark as Answer' if this post helps you.
Fabrice ZERROUKI
Marked as answer by DoctorWho on May 04, 2012 04:08 PM
WOW, that's not what I expected. OK, then, if the functionality is already on Windows Server 2008, then the issue is only that the .MSI is expecting a file named MSOLAP.DLL to be in a specific folder, and it can't find it. I've got to find some way of
getting that requirement out of the .MSI.
I just had a thought. Back in the day, when these 2 ASP.NET apps were created, we just started with VS 2005's default Web Application. I think that those type of projects automatically created a SQL Express database as a part of the app, and put it into the
App_Data folder. Could this be what's causing the .MSI to require the SqlRun_Tools.MSI to be on the server? If so, can I just delete that .MDF and .LDF, and that will get rid of the requirement?
OK, but how do I make the .MSI created by the setup project, to point to that msado15.dll on our Windows 2008 R2 server?
Don't have any clue on this one, I'm a "pure" sys engineer, never used Visual Studio, just packaged some MSI with wix (but basic ones : copying some files and executing powershell scripts...).
This message is provided "AS IS" with no warranties, and confers no rights!
Please 'Mark as Answer' if this post helps you.
Fabrice ZERROUKI
DoctorWho
31 Posts
Is it safe to install MDAC on a Windows 2008 R2 server running IIS 7.5?
May 03, 2012 08:03 PM|LINK
I've been trying for the last couple of days to install a couple of older ASP.NET 2.0 apps on our new Windows 2008 R2 Web Server, running IIS 7.5. We had to make these apps installable using .MSI files, so we could put Crystal Reports XI Release 2 on, as a merge module. Whenever I run the .MSI files they fail immediately. I was able to make the .MSI files generate verbose log files, so I could try and figure out what's wrong. It appears to me as though the .MSI file is looking for a MSOLAP.DLL file, which it can't find, and then it aborts.
In looking around I've found that the MSOLAP.DLL is Microsoft's OLAP Services DLL. I've spent about 2 days trying to figure out what installs that, where it comes from, etc. I think I've finally found that it would be installed by running the Microsoft Data Access Components (MDAC). I'm wondering, if it safe to install MDAC on a Windows 2008 R2 Web Server? According to the link I gave, it is already installed on a Windows 2003 Server, but I'm working with 2008 R2, and that documentation doesn't say anything about it. And, BTW, I've tried searching for MSOLAP.DLL, and it's not on my 2008 R2 server.
.NET 2.0 IIS7 IIS7.5 mdac 2008 server
fab777
925 Posts
Re: Is it safe to install MDAC on a Windows 2008 R2 server running IIS 7.5?
May 04, 2012 08:10 AM|LINK
Hi,
MDAC is not available (and will not install) on Windows 2008. Its successor is Windows DAC 6.0, but you should already have it because its part of the OS.
[url=http://msdn.microsoft.com/en-us/library/ms810810.aspx] http://msdn.microsoft.com/en-us/library/ms810810.aspx[/url]
Windows Data Access Components (WDAC): MDAC changed its name to WDAC - "Windows Data Access Components" since Windows Vista and Windows Server 2008. WDAC is included as part of the operating system and is not available separately for redistribution. Serviceability for WDAC is subject to the life cycle of the operating system.
Please 'Mark as Answer' if this post helps you.
Fabrice ZERROUKI
DoctorWho
31 Posts
Re: Is it safe to install MDAC on a Windows 2008 R2 server running IIS 7.5?
May 04, 2012 04:07 PM|LINK
WOW, that's not what I expected. OK, then, if the functionality is already on Windows Server 2008, then the issue is only that the .MSI is expecting a file named MSOLAP.DLL to be in a specific folder, and it can't find it. I've got to find some way of getting that requirement out of the .MSI.
Thank you, for your help.
fab777
925 Posts
Re: Is it safe to install MDAC on a Windows 2008 R2 server running IIS 7.5?
May 09, 2012 07:54 AM|LINK
Seems you can use this one instead : '%CommonProgramFiles%\System\ado\msado15.dll'
Please 'Mark as Answer' if this post helps you.
Fabrice ZERROUKI
DoctorWho
31 Posts
Re: Is it safe to install MDAC on a Windows 2008 R2 server running IIS 7.5?
May 10, 2012 04:44 PM|LINK
OK, but how do I make the .MSI created by the setup project, to point to that msado15.dll on our Windows 2008 R2 server?
DoctorWho
31 Posts
Re: Is it safe to install MDAC on a Windows 2008 R2 server running IIS 7.5?
May 10, 2012 07:13 PM|LINK
fab777
925 Posts
Re: Is it safe to install MDAC on a Windows 2008 R2 server running IIS 7.5?
May 11, 2012 08:28 AM|LINK
Please 'Mark as Answer' if this post helps you.
Fabrice ZERROUKI