Thursday, October 28, 2010

Install the SharePoint integrated mode default configuration option is disabled while configuring the Reporting Services on SQL Server 2008 R2

I had a SQL Server 2008 Standard edition setup for the DBEngine and Integration Services. For some reason I did not install the Reporting Services at that time. Now I was trying to get the Reporting Services (RS) deployed with SharePoint 2010 in the integration mode.

The first choice was to install the RS. I got started, but to my surprise I saw the first two options “Install the Native mode…” and “Install the SP integrated mode…” disabled. I only had the option “Install, but do not configure the report server.” available to me.

Man, where did I go wrong. This is what it came to me first. But after a little search, I realized that this happens if you try it installing after the initial installation. And that is what I was doing. So I decided to proceed. I did see some warnings but they were not of much concerns.

I had to start the RS Configuration Manager from the Configuration Tools option and the later setups were pretty much the same old way of going through the wizard steps.

So there I was. And as the next steps, definitely you need the RS Add-In on SP 2010 box and take care of the rest of standard CA configuration steps.

Tuesday, October 26, 2010

Cannot access a host named SharePoint 2010 site locally from the server

I had a SP 2010 site setup and access it from my client machines. I was able to perform all administrative tasks from CA when I decided to switch to the server box and use the same host url “http://sharepoint.mycompany.com” that I was using from my client machine.

Guess what, I was not able to login to the site and it kept prompting me for my userid/pwd.

After  much of looking around, found this useful article which seems to be pointing to the security measures put in place by Microsoft starting Windows Server 2003 SP1 and later. It essentially got the loopback check in-place to prevent Man-In-The-Middle (MITM) attack from malicious apps.

You can read more about is here.