31 March, 2009

SharePoint 2007 Installation on Windows Server 2008

1. You must enable the IIS7 Feature Role on Windows Server 2008 with .NET 3.0
-From Control Panel, Programs and Features, Select 'Turn Windows Features On or Off'
-Next, Under 'Server Manager, Features' Select '.NET Framework 3.0 Features'. When askedto install the IIS7 role, select yes.
-Under IIS7 'Security', be sure to select the authenticationyou want, i.e. Basic, NTLM, Kerberos, etc.
-Next, you must slipstreamWindows SharePoint Server 3.0 SP1 AND SharePoint Server 2007 SP1 into your SharePoint Server 2007 installation directory.

2. I used Winrar to extract the files from my SharePoint Server 2007 ISO, but you can alsocopy them into a directory directly from the DVD. Create a directory, we'll use c:\Slipped for our installation point. Copy the entire DVD contents to c:\Slipped

3. Next, you must download and extract both Windows SharePoint Services SP1 and SharePoint Server 2007 SP1you can get them here
http://blogs.msdn.com/sharepoint/archive/2007/12/11/announcing-the-release-of-wss-3-0-sp1-and-office-sharepoint-server-2007-sp1.aspx

-Create a directory to host the WSS 3.0 files after extraction. We will use c:\wsssp1
-create a directory to host the SharePoint Server 2007 files after extraction. We will use c:\mosssp1
-we will assume we have downloaded both service packs to c:\

Extract the WSS 3.0 service pack files by executing 'c:\wssv3sp1-kb936988-x86-fullfile-en-us.exe /extract:c:\wsssp1' Agree to the license terms, and the service pack will unpack.

Extract the SharePoint Server 2007 service pack by executing 'C:\officeserver2007sp1-kb936984-x86-fullfile-en-us.exe /extract:c:\mosssp1' Agree to the license terms, and the service pack will unpack.

4. Copy the service pack files from the above directories into the installation updates directory.
5. Last, run the setup from the x86 directory, and it should install!

Note:-Microsoft has now released a slipstreamed SharePoint Server 2007 SP1 image here

Additional Resources:
MOSS and WSS SP1 files are located here. You will need both service packs for the slipstream installation. Note: the links have both the 32 and 64 bit versions.
WSS SP1: Windows SharePoint Services 3.0 Service Pack 1 (SP1)
MOSS SP1: The 2007 Microsoft Office Servers Service Pack 1 (SP1)

I hope the above information helps you to install sharepoint on windows server 2008 successfully.
All The Best !

30 March, 2009

The restricted trust level is not supported + Infopath

Recently I tried to create an InfoPath 2007 form template and publish it to a SharePoint Forms Library and I received the following error:The restricted trust level is not supported.

This Form template cannot be uploaded to the server.Review the following 1 error(s) for more information.
Errors

The restricted trust level is not supported.

-Make sure that the form’s trust is set to domain.
-Go to Tools > Form Options > Security and Trust and Uncheck “automatically determine security level” and select “Domain”or "Full Trust" as the level of trust.
-Click “Ok”.

To publish InfoPath 2007 form to a SharePoint library:

Using SharePoint to Verify and Upload the Form Template

The SharePoint Central Administration site contains the Upload Form Template page,to verify a form template before uploading it. Once the form template is verified, enter the path to the form template and upload it to the server.

To verify the form template by using SharePoint Central Administration
1. Click Start, click All Programs, click Administrative Tools, and then click SharePoint 3.0 Central Administration.
2. In the top navigation bar, click the Application Management tab.
3. On the Application Management page, under InfoPath Forms Services, click Upload form template.
4. On the Add Form Template page, click Browse.
5. In the Choose file window, browse to C:\InfoPathLabs\deploylab01.xsn, click the template, and then click Open.
6. In the Deploy Form Template section, click Verify.
7. In the Report Details section, look for any errors and warnings for the form template.
8. If the system warns you that the template already exists, click Application Management, click Manage form templates, click the arrow that appears next to the form template, and then click Remove Form.
9. On the Remove Form Template page, click Remove.
10. If you did not receive a warning, click OK.

Stsadm access denied on Windows Server 2008

We recently faced one situation where we encountered Access Denied errors when attempting to run stsadm on a dev Windows Server 2008 Web Edition.We checked to see if the user account we were using was a local administrator on the server and it was.

We were not sure what was causing the problem.Then we looked into the User Account Control settings and those were enabled to help "protect" the server. Turning those off allowed me to run stsadm from the command line.

The User Account Control (UAC) is found under Control Panel --> User Accounts --> Turn User Account Control on or off.

You do not have permissions to open this file on Excel Services

Hello Guys,
If you receive the following Exception when you try to open the sample workbook or another workbook try the following steps:


You do not have permissions to open this file on Excel Services.Make sure that the file is in an Excel Services trusted location and that you have access to the file.

1.Open Central Administration -> go to Operations tab -Ensure that the Excel Service is running.
2.Open Central Administration -> go to your configured Shared Service -> click Excel Service Settings.

-File Access Method: ensure that it is not using Impersonation, instead the Option Process Account should be enabled.

3. Open Central Administration -> go to your configured Shared Service -> click add new trusted file location
-Field URL: here you can specify a report library or the whole portal
-Location Type: should be Windows SharePoint Services
-Children trusted: defines whether the children should also be trusted or only the definied path

How to enable SSL site collections using host headers to be browseable using ISA

1.In ISA 2006, right click Firewall Policy, New, and finally SharePoint publishing rule; type a new name for the publishing rule.Click Next.

2.Select Publish a single Web site or load balancer since we are dealing with a single site collection. Click Next.

3.Select Use SSL.. Click Next.

4.Type the name of the published web site, which is the external URL as it would appear on the certificate. Click the box next to Use a computer name or IP address to connect to the published server, and fill in the correct IP address for the server. Click Next.

5.From the drop down for Accept requests for, select This domain name. In the Public name box, type in the domain name you wish to use. Click Next.

6.We now must create a new listener. Give the new listener a name. Click Next.

7.Select Require SSL secured connections with clients. Click Next.

8.Select External Network and then the IP Address. This IP address will be dedicated to accept requests from SharePoint traffic externally. Click on OK, and then click Next.

9. Click on Select certificate and select the correct certificate with the name you are using in the public name. Click on Select.

10. Select the authentication type, and configure as needed. Click Next.

11. If SSO is being used, click on Enable SSO for Web sites published with this Web listener, and configure the SSO domain being used for authentication. Click Next.

12. Click Finish.

13. Select the new Listener, and click on Next.

14. Select the NTLM authentication, and click on Next.

15. Select the first option if AAMs are already configured; if not select the second option. Click Next.

16. Select All Authenticated Users. Click Next.

17. Click on Finish.