Adatis BI Blogs

Reporting Services 2008 - Connection Problems

Having recently rebuilt a server entirely with "2008" technology I have a small problem with reporting services.  When trying to look at the Reports, I received the error: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." I found, that even though we are not trying to look at the secure site, the certificate causes issues.  For development and testing purposes I found it easiest to remove the certificate.  To do this perform the following steps: 1. Open Reporting Services Configuration Manager 2. Click Web Service URL and click "Advanced" 3. Remove the SSL certificates, both for IPv4 and IPv6 and click ok, and then Apply.  This will remove the SSL certificates, you should now be able to use Reporting Services 2008. 

PerformancePoint Service Pack 1 - Not long now!

I stumbled across this little nugget of information today, stating that the PPS Service Pack 1 is now in Beta, and also hinting that it's release should be in May (If I read it right, the 5th of May).  Its compatibility with Windows Server 2008 is said be fixed, and the following page highlights what is, isn't and will be, supported by Windows Server 2008;  You will find PPS in the "Applications that will be compatible in the future", stating SP1.  More to come on this in May hopefully!  

Installing MOSS 2007 on Windows Server 2008

SharePoint Server 2007 RTM or WSS 3.0 will not install on Windows Server 2008 as it requires SP1.  In order to install MOSS 2007 on Windows Server 2008 you will need to install 'MOSS with Service Pack 1' (this includes WSS with Service Pack 1). This is known as a slipstream installation and it contains the original image for MOSS/WSS RTM and the MOSS/WSS SP1 files. The problem is that this 'all in one' slipstream for MOSS was not available for download, however now it seems that this has been released and can be found here: Office SharePoint Server 2007 with SP1 (32 bit) Office SharePoint Server 2007 with SP1 (64 bit) This seems odd as the Install is about 600mb and states that it is a trial, however bear with it, you will need to register for download, and you will find 2 executables  (OfficeServer.exe 295.0 MB and OfficeServerwithSP1.exe 409.2 MB) (What would we do without broadband!). Install the OfficeServerwithSp1 executable. Initially you will be asked to enter your Product Key.  If you have an official product key you can use that, otherwise you should have been sent a trial key. Now you have a SharePoint Server that will install on Windows Server 2008, with no problems at all.  Microsoft have not yet released this as a bundle, or even on MSDN, however I am sure they will do this in time. 

PerformancePoint and Windows Server 2008

Well, the testing has continued this week after having issues with SQL 2008 with PerformancePoint, I rebuilt one of our test servers with the Latest Server CTP.  Obviously as I am keen to always know what Microsoft are up to in as many areas as possible, so I thought it wise to install Server 2008 with Hyper-V.  Now this seems like a great idea, however, it seems that this particular version is only available as a 64Bit variant at the moment, and they do not make that all to clear while installing.  So after installing this, and SQL server 2005, as to test PerfomancePoint on Server 2008, it seems that the version check for Windows fails, with is not ideal.  This seems to be solely due to the fact that it is a 64 Bit version.  So, the next step is to try the Install with the NoReqCheck option ( post on this can be found here ), now this does actually get PPS Server to install, however the configuration will not run.  I have not tested the 64 bit version of PPS on Server 2008, as it seems that Pro Clarity 6.3 is ONLY 32 bit. PPS 2007 currently doesn't offer the Analytics Component that Pro Clarity 6.3 offers. I'm sure, however this will be released in the next version of PPS 2007.

Hyper-V - What is it?

Hyper-V is in essence the new Virtual Machine software that is introduced with Windows Server 2008.  Windows Server 2008 includes Hyper-V (codename viridian), a new virtualisation technology that allows VM's to work better without 3rd Party Software, and supports 64Bit systems. The most anticipated benefit of Hyper-V is server consolidation, enabling one server to take on the workloads of multiple servers. E.g. Web Server, Fax Server, Exchange Server, and SQL Server 2008 all on one piece of Hardware. However, Hyper-V enables more than server consolidation improving network reliability, scalability, security, and flexibility. Servers that slow down due to peak usage at the start of the workday, for example, can offload some of their workloads to other servers, which increase their capabilities, or move to more powerful servers, improving network availability. Hyper-V is a key feature of Windows Server 2008, integrating with familiar, Windows-based server management tools. Businesses don’t have to purchase additional software to take advantage of powerful virtualisation features like live backup and quick migration. Applications can also be efficiently virtualised using Windows Server 2008 centralized application access technologies. Terminal Services Gateway and Terminal Services RemoteApp allow easy remote access to standard Windows-based programs from anywhere by running them on a terminal server instead of directly on a client computer—without the need for a complicated VPN. With testing the latest technology from Microsoft this Hyper-V should help developers test SQL 2008, for example, in parallel against SQL 2005. For example, a development team can test the latest version of an application on multiple platforms with a variety of virtual hardware capabilities.