In order to try out the features of Microsoft SQL Server Database Publishing Wizard as explained in this post, I had downloaded the installer (an .msi file) on my laptop. Since I had the SQL Server running on a Virtual Machine, I copied this installer from my laptop to the VM (Windows Server 2003). But when I tried executing the installer from the VM, the following error message was displayed.
I had logged on to the server using a Login which was part of the Local Administrators group. Hence permissions to the file was not an issue. When I checked the Properties of the .msi file here is what I saw.
Like I mentioned earlier, this was downloaded from one computer and copied to another. Hence Windows had blocked it considering it as a potential threat. This is a security feature in Windows Server 2003, which blocks execution of executables like .exe, .msi files, which were downloaded on some other computer.
Since the root cause of this error message was now known, all I had to do was to click on Unblock button in the Properties of the installer. After unblocking it the installer executed fine and Microsoft SQL Server Database Publishing Wizard was successfully installed.