Tuesday, 31 March 2009

How to uninstall MOSS from a Farm

If you want to wipe out and create a new MOSS Farm here are the steps

+ Run the Configuration Wizard and, on the second page, select Disconnect from this server farm and click Yes on the warning dialog. This will delete the IIS web site and the application pool.

+ Then, run the uninstall from the Control Panel's Features and Programs application and click Yes on the warning dialog. This will take a reboot.

+ Then, if you really want to get rid of it all, go to the database server and delete the Config and Admin Content databases


Alternatively you can also disconnect the central admin from the 12 hive using cmd line if nothing works:

psconfig -cmd adminvs -unprovision

psconfig -cmd configdb -disconnect

Monday, 23 March 2009

Implement Form Based Authentication

Introduction

The purpose of this document is to provide the step by step information about enabling the Form Based Authentication (FBA) for MOSS 2007 site. MOSS 2007 sites uses windows authentication by default. But some business needs form based authentication to fulfill the requirements.


Below section explains to enable Form Authentication for MOSS 2007 site.


Setting up ASP.Net 2.0 Forms Authentication User and Role Data Source


This section explains creation of database which is used to store user's information such as credentials and roles which is used for Form Authentication. This section also explains the configuration of Membership and Role providers in the web.config file and creation of users using ASP.Net configuration wizard. This article shows creating a user and which will be used for testing Form Authentication later.


Create Database


To create database, Microsoft has provided a tool/ utility called aspnet_regsql.exe that creates a database for us. This utility can be found in %windir%\Microsoft.Net\Framework\vx.x.xxxxx folder. Please see the image below:








Fig 1


Executing aspnet_regsql.exe file will open ASP.Net SQL Setup wizard that will walk through creating the ASP.Net 2.0 database. I have added the database name as FBAASPNetDb and configured it for windows authentication. Please see the image below:





Fig 2


Click on Next button. Please see the image below:





Fig 3


Select Configure SQL Server for application services option and click Next button. Please see the image below:





Fig 4


Click Next button. Now the database FBAASPNetDb is created successfully. Please see the image below:





Fig 5





Fig 6


Configure Membership and Role Providers


In the previous section, database is created successfully. Now we need to add a user in to database. Using ASP.Net Configuration Wizard, users can be added the database. This can be achieved by creating web site that will allow us to add the users and roles and also ensure the database connection strings, membership and role providers are correctly configured before we bring Sharepoint in to equation.


Below steps explains creating web site and configuring membership and role providers and executing ASP.Net Configuration Wizard.


a) Open Visual Studio 2005 and select File
à
New à Web Site. In the New Web Site dialog, select the ASP.Net Web Site template and enter the location to store the web site files. Please see the image below:






Fig 7


In the above image, location shows Z:\Inetpub\FBA. This is because Sharepoint server root directory is mapped to my system as Visual Studio 2005 is not installed in server machine. You can choose any location whichever is comfortable for you.


b) Add a new web.config file to web site project. Please see the image below:



Fig 8


c) By default, you will see a <connectionStrings/> node within <configuration> node. Specify the connection string to the database which has been created in the previous section. Please see the image below:





I have mentioned server as EC4-NETP-148429. This is the server in which SQL Server 2005 is installed. Please mention the respective server name.


d) After setting up the connection string, we need to specify the membership and role providers in the web.config file. In this article, I am using ASP.Net SQL Membership and Role providers. So specify the provider's information within the <system.web> tag. Please see the image below:





One thing we need to make sure that is, the provider name and connection string attribute specified in the web.config file should not be same as specified in the machine.config file. When we install .Net Framework 2.0, default connection string and providers are specified in the machine.config file.


e) Save web.config file and launch the ASP.Net Configuration Wizard by clicking on Website à ASP.Net Configuration. Please see the image below:





Fig 9





Fig 10


f) Set the authentication type in the above wizard. To do this, click Security link. In the Security tab, under Users section, click Select authentication type link. Select From the internet option and press Done button which is available in the bottom right corner. By selecting this option, which means that site will use form authentication to identify users. Please see the image below:






Fig 11


g) To test the membership and role providers, click on Provider tab. In the Provider tab, click on Select a different provider for each feature (advanced) link. Select right / correct membership and role provider and click Test link to ensure that providers are communicating to right database. Please see the image below:






Fig 12






Fig 13


At this point, we configured web.config file with connection string and providers information. Also we tested the providers with the database. Next section will explain adding users to database.


Create a User


a) To add users, click on Security tab. In Security tab, under Users section, click Create user link. Here I am adding user as testFBA and password as password which will be used for testing form authentication later. Please see the image below:





Fig 14


Now we have created a user successfully. Do not worry about creating roles at this time and will be explained later.


Creating Web Applications


This section explains creating web application using Sharepoint Central Administration. In this article I am creating two IIS web sites; one is extranet site which will be used by the content owners and configured to windows authentication. Another site is internet site specifically for internet users and configured to form authentication. Below section explains creating of two sites.


Creating extranet IIS Web site


Before creating new site, we need to create new web application. Below is the step by step information for creating new web application.


a) Click Start à All Programs à Microsoft Office Server à Central Administration.


b) In the Application Management tab, under Sharepoint Web Application Management section, click Crate or extend Web application link.


c) In Create or Extend Web Application page, click Create a new Web Application link. Provide the information to create new web application and click OK button. Please see the image below.





Fig 15





Fig 16





Fig 17


d) Create site under the above web application. To do this, in Application Management tab, under Sharepoint Site Management section, click Create site collection link.


e) In Create Site Collection page, select the web application which have been created in the previous step and provide other information to crate the site and click OK button. Please see the image below.







Fig 18




Fig 19


Now we created the web application and site successfully. Next section explains creating internet site.


Creating internet IIS Web site


This section explains extend our web application to another internet site which has been created in the previous sections. This site is for anonymous or internet users.


a) Click Start à All Programs à Microsoft Office Server à Central Administration.


b) In the Application Management tab, under Sharepoint Web Application Management section, click Crate or extend Web application link.


c) In Create or Extend Web Application page, click Extend an existing Web application link. Provide the information to extend the web application and click OK button. Please see the image below.







Fig 20


Now we have successfully created extranet and internet site. Below is the URL for these sites.


For extranet site: http://ec4-netp-148429:4040


For internet site:

http://ec4-netp-148429:4041


Open the browser and test both the site by typing the URL. But these two sites are asking about windows authentication because these sites are not yet configured to form authentication.


Below section explains configuration of web.config file of each site with connection string and providers information.


Configure Web Application to communicate with Form Authentication Data Store


In this section, we are modifying the web.config file of two sites. Web.config file resides in the root directory of the site i.e. c:\Inetpub\wwwroot\wss\Virtual Directories. Under this, two folders i.e. 4040 and 4041 are available. Web.config file of specific site is available inside these folders.


Configure web.config file of extranet site


The web.config file of extranet site is available in c:\Inetpub\wwwroot\wss\VirtualDirectories\4040 folder.


a) Open web.config file, specify the <connectionStrings> node defined in the section 2.2.c just after the closing </SharePoint> tag and opening <system.web> tag. Please see the image below:







Fig 21


b) Add the membership and role provider node which is defined in the section 2.2.d, just after opening the <system.web> tag. Please see the image below:










Fig 22


c) Save the web.config file.


Configure web.config file of internet site


The web.config file of internet site is available in c:\Inetpub\wwwroot\wss\VirtualDirectories\4041 folder.


a) Open the web.config file and follow the same step specified in the Section
4.1


Configure SharePoint Central Administration


The web.config file of Central Administration site is available in c:\Inetpub\wwwroot\wss\VirtualDirectories\13035 folder. To find the virtual directory open IIS. Under Web Site folder, find Sharepoint Central Administration v3. Right click to open properties. In the Properties pop up, click Home Directory tab and find the Local Path.


a) Open the web.config file and follow the same step specified in the Section
4.1


b) Here we need to very careful while specifying defaultProvider information for Role Provider. In the Role Manager attribute, add AspNetWindowsTokenRoleProvider as defaultProvider. This is necessary because Central Administration still uses Windows Authentication for the role provider. Please see the image below:







Fig 23


c) Save the web.config file.


Enable Form Authentication for Internet site


Enabling Form Authentication to internet site using Central Administration is very simple. Below steps explains the enabling form authentication.


a) Browse to Central Administration web site. Select Application Management Tab.


b) In the Application Management Tab, under Application Security section, click on Authentication Providers link. Please see the image below:







Fig 24


c) Select the Extranet Web Application. You could see Default and Internet zone for the extranet web application. In this we are configuring form authentication for Internet application. Please see the image below:




Fig 25


d) Click on Internet zone option. Edit Authentication page will open. Select Authentication Type as Forms. Check the enable anonymous
access check box and provide membership and role manager name. After providing the information, click on Save button. Please see the image below:





Fig 26



Now we successfully enabled the form authentication for the internet site. To prove form authentication is actually working with our data store, we need to add the user to the site. Below step explains to adding user to site.


e) Browse to extranet web site. In our case it is http://ec4-netp-148429:4040


f) Click Site Actions à Site Settings à People And Groups. Please see the image below:





Fig 27


g) Click on New à Add User.


h) In the Add User page, enter user name as testFBA which we created in the previous steps and provide the permission for the user. Please see the image below:





Fig 28


Now we created a user and granted the permission successfully. Below steps explains testing form authentication.


i) To test Form Authentication, Browse the internet site. In our case it is http://ec4-netp-148429:4041


j) Now system will redirect to Sign In page. Please see the image below:





Fig 29


k) Enter testFBA as user name and password as password and click on Sign In button. Please see the image below:





Fig 30






Fig 31


Now we successfully log in into internet site with form authentication.

Sunday, 15 March 2009

Unable to display this Web Part

"Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web server administrator"

I was with this wierd problem, when i got a migration project from 2003 to 2007 . I was trying to create DataView Webpart from a List. I created the List in the site and then DVWP from it, all went fine. I imported both into my Test Server from Dev,OOOOpppsssssssss it broke throwing the error.

It took almost 2 days finding all possible solutions to fix it none worked ,ya finally googled got lots of hits but none was feasible for me.

Finally i got an incredible simple solution

Cause
========
The cause for this problem is a Sharepoint 2007 Designer BUG !!!! ,if you create a DVWP in Sharpeoint designer 2007 it will append the GUID of the LIST in the code and would link to DVWP, if you try to create a new List it will always create a new GUID which will never match up with the DVWP and it breaks.

Solution
=========
This would be pretty simple once you know the trick.



Open the page having problem in Sharepoint Designer 2007 Search for "ListID" and replace with "ListName" and change the "DefaultValue=" to your List name, VIOLA !! this would fix it.