Pages

Saturday, January 29, 2011

Install sharepoint in SQL authentication method

Below steps for "Installing sharepoint 2010 in SQL authentication"
  1. Configure SQL Server to use mixed authentication. You can configure SQL Server to used mixed authentication when you install SQL Server. For information about how to change the authentication mode after you install SQL Server, visit the following Microsoft Web site:
  2. Add a new SQL Server account in Microsoft SQL Server 2005. Then, grant the roles of security administrator and database creator to the account. To do this, follow these steps:
    1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
    2. In SQL Server Management Studio, expand Security, right-click Logins, and then click New Login.
    3. In the Login - New dialog box, type the name of the SQL Server account, clickSQL Server Authentication, type the password, and then click Server Roles.
    4. In the results pane, click to select the following check boxes, and then click OK:
      • dbcreator
      • securityadmin
  3. In the domain in which the server that is running SharePoint Server resides, create new domain accounts for the SharePoint Server service account and for the SharePoint Server Application Pool account. To do this, follow these steps:
    1. Click Start, point to Administrative Tools, and then click Active Directory Users and Computers.
    2. In the Active Directory Users and Computers snap-in, right-click Users, point toNew, and then click User.
    3. In the New Object - User dialog box, type the account name that you want to use for the SharePoint Server service domain account, and then click Next.
    4. Type the password two times.
    5. Click to clear the User must change password at next logon check box, click to select the Password never expires check box, click Next, and then clickFinish.
    6. Repeat steps 3b to 3f to create the SharePoint Server Application Pool account.
  4. Install SharePoint Server 2010. However, do not select the stand-alone installation. After SharePoint Server 2010 is installed, click Cancel when you are prompted to run theSharePoint Products and Technologies Configuration Wizard.
  5. Log on to the server that is running SharePoint Server 2010, click Start, click Run, typecmd in the Open box, and then click OK.
Run the below stsadm command

once you run the command, you finished the creating central admin and farm

The Central Admin path is set automatically on Port: 14370 (in my case), but not deployed on IIS Server. (check IIS Manager and you will see no central admin is deployed, the Farm is also only created on WSS v4 level because the SharePoint Server Features are not installed & deployed)
To provision the central admin on IIS you can execute:  psconfig –cmd adminvs -provision
Now check your IIS and you will see the central admin web application:
clip_image017
clip_image019

Now while you browsing services/feature, you could find the some missed features, So Finally we have to Rerun the SharePoint Configuration wizard in the GUI Mode and then you will all the features.