02 April, 2009

Microsoft Office SharePoint Server (MOSS 2007) Versions

How do you find out what version of SharePoint you are running?

The first approach is to open a web browser and got to the site settings page (Site Actions > Site Settings > Modify All Settings).

The second approach is against the databases. Open SQL Server Management Studio, Connect to the server, new query, run the following:
SELECT [VersionId]
,[Version]
,[Id]
,[UserName]
,[TimeStamp]
,[FinalizeTimeStamp]
,[Mode]
,[ModeStack]
,[Updates]
,[Notes]
FROM [SharePoint_Config].[dbo].[Versions]
WHERE VersionId = '00000000-0000-0000-0000-000000000000'
ORDER BY Id DESC
This returns :-





The top row is the latest version. The query is performed on the SharePoint Configuration database. If you have called this database something instead of "SharePoint_Config" change the query to reflect this.
You can also look at the versions for Content Databases, by changing the database name. For example: FROM WSS_Content_MySites.[dbo].[Versions]

WSS SP1:- Download

MOSS SP1:- Download

MOSS 2007 post SP1 hotfix KB941422

MOSS 2007 post SP1 hotfix KB941274

MOSS 2007 post SP1 hotfix KB948945

MOSS 2007 Infrastructure Update KB951695 & KB951297

MOSS 2007 Cumulative update KB956056 & KB956057







31 March, 2009

Uninstalling Windows SharePoint Services 2.0

There are different degrees to which you can uninstall Microsoft Windows SharePoint Services. Depending on your needs, you can choose from the following options:

-Remove Windows SharePoint Services from a virtual server and preserve the site content.
You can choose to remove Windows SharePoint Services, but keep the site content in the content databases. This allows you to extend the virtual server again later and reconnect to the site content. If you leave the content databases intact, you can reconnect to them, from the same virtual server or from a different virtual server, and continue hosting the site content using the same Uniform Resource Locator (URL). Use this method to temporarily remove and then restore a virtual server, or to change which virtual servers are hosting which content in a server farm setting.

-Remove Windows SharePoint Services from a virtual server and delete the site content.
You can choose to remove Windows SharePoint Services and delete the site content in the database. Use this method to remove a virtual server permanently, but continue using Windows SharePoint Services on other virtual servers. For example, use this method if you are finished with a project and no longer need the associated Web sites.

-Uninstall Windows SharePoint Services completely from a server.
You can choose to uninstall Windows SharePoint Services by using the Add/Remove Programs control panel. This method does not delete site content. You can reinstall and reconnect to the site content. Use this method to repair an installation or to remove a Web front-end server from a server farm.

Removing from a Virtual Server by Using HTML Administration
To remove Windows SharePoint Services from a virtual server by using HTML Administration, you use the Remove Windows SharePoint Services from Virtual Server page.

Remove from a virtual server
-Click Start, point to All Programs, point to Administrative Tools, and then click SharePoint -Central Administration.
-On the Central Administration page, under Virtual Server Configuration, click Configure virtual server settings.
-On the Virtual Server List page, select the virtual server you want to configure.
-On the Virtual Server Settings page, under Virtual Server Management, click Remove Windows SharePoint Services from Virtual Server.
-On the Remove Windows SharePoint Services from Virtual Server page, select one of the following:
-Remove without deleting content databases
This removes only the Windows SharePoint Services folders from the virtual server — the content database remains intact, so you can reconnect to it later using the same virtual server or a different one.
-Remove and delete content databases
This both removes the Windows SharePoint Services folders from the virtual server and deletes the content database. You will not be able to reconstruct the sites previously stored on that virtual server unless you have a backup.
-Click OK.

Removing from a Virtual Server by Using the Command Line
You can use the unextendvs operation with the Stsadm.exe command line utility to remove Windows SharePoint Services from a virtual server. The unextendvs operation takes the -url parameter and the optional -deletecontent parameter. When you use unextendvs without the -deletecontent parameter, it leaves the content databases in place, so that you can reconnect to the content for a virtual server. When you include the -deletecontent parameter, the content databases are removed and the virtual server is removed from the configuration database.

For example, to remove Windows SharePoint Services from a virtual server, but preserve the content databases, use the unextendvs operation with syntax like the following:
stsadm -o unextendvs -url http://servername

To remove Windows SharePoint Services from a virtual server and remove the content databases permanently, use the unextendvs operation with syntax like the following:
stsadm -o unextendvs -url http://servername -deletecontent

Note:-When you use the unextendvs operation with the -deletecontent parameter, you cannot reconnect to the site content later.

Uninstalling from the Server Computer
If you want to remove Windows SharePoint Services from a server computer entirely, you can uninstall by using the Add or Remove Programs control panel. Uninstalling Windows SharePoint Services does not remove any chained products that were installed, such as WMSDE. You must uninstall these programs separately.

Uninstall
-On the server computer, click Start, click Control Panel, and then click Add or Remove Programs.
-Select Windows SharePoint Services, and then click Remove.

When you use the Add or Remove Programs control panel to remove Windows SharePoint Services from a server, it calls a command-line operation, stsadm -o uninstall, to perform the task. The uninstall operation does not remove any chained products that were installed. The uninstall operation takes the optional -deletecontent parameter. When uninstall is used without the -deletecontent parameter, it leaves the content and configuration databases in place, so that Windows SharePoint Services can be reinstalled, and you can reconnect to the databases and continue hosting sites. When the -deletecontent parameter is used, the content and configuration databases are removed, and you cannot recover the site content.

Refferance:-http://technet.microsoft.com/en-us/library/cc288469.aspx

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.