User Profile Synchronization Service Requirements

To ensure that the User Profile Synchronization Service starts and your SharePoint servers be able to import and synchronize correctly with your AD services the above action should be performed before starting the configuration process of this service.
- The farm service account should be member of the local administrator group of the SharePoint server hosting the User Profile Synchronization Service.
- The service account of the User Profile Synchronization Service should have the permission of Replicate Directory Changes on the configuration partition of your AD.
  

1	Start ADSI Edit
2	Right click ADSI Edit and then  click Connect to…
3	Check Select a well known Naming Context , select Configuration from the dropdown list and the click Ok
4	Right click the Configuration entry and click Properties on the context menu
5	On the Security tab add the User Profile Synchronization Service account and give him the permission Replicating Directory Changes

- The User Profile Synchronization Service account should be delegated the Replicating Directory Changes on the domain :

1	From ADUC console, right click the domain name and then click Delegate Control…
2	Click Next
3	Add the User Profile Synchronization Service Account and then click Next
4	Check Create a custom task to delegate and then click Next
5	Click Next
6	Check Replicating Directory Changes in permissions list  and then click Next
7	Click Finish

Office Web Apps - Can’t View Office Documents in Browser !!!

After installing Office Web Apps 2010 on SharePoint 2010 Server you expect viewing and editing on the browser your office documents.
   
Regarding which Web Application is hosting the Document Library containing this documents you should ensure that the Application Pool Accounts used for :

- Word Viewing Service Application
- Excel Service Application
 
- PowerPoint Service Application
Are allowed to access its content databases.

Step by Step Clustering SQL Server 2008 R2 Part VI

Part I – Before we start
Part II – Creating Windows Cluster
Part III – Clustering MSDTC
Part IV – Installing the first SQL Server Cluster Node
Part V – Adding the second node
Part VI – Post installation tasks

On this last part we will only demonstrate how to enable Filestream feature on SQL Server 2008 clustered configuration.
on future posts we will discuss other administrative tasks and tips.
Note : All actions described on these part should be performed on each node.

1	Start the SQL Server Configuration Manager
2	Click Yes on the User Account Control
3	Open the properties windows of the SQL Server Service by right clicking on it   and then the Properties context menu
4	Check Enable FILESTREAM for Transact-SQL access and Enable FILESTREAM for file I/O streaming access   Type the Windows Share Name to use and then click Apply
5	Verify that a File Share Resource with the same Share Name as configured on the FILESTREAM tab appears and it’s online on the  Failover Cluster Manager, the resource should appear as depending on the SQL Server service
6	Run the SQL Script : EXEC sp_configure filestream_access_level , 2 reconfigure

Step By Step Clustering SQL Server 2008 R2 Part V

Part I – Before we start
Part II – Creating Windows Cluster
Part III – Clustering MSDTC
Part IV – Installing the first SQL Server Cluster Node
Part V – Adding the second node
Part VI – Post installation tasks

1	Run the setup program of SQL Server 2008 R2
2	Click Yes on the User Account Control
3	Select the Installation Page on the SQL Server Installation Center and then click Add node to a SQL Server Failover cluster
4	Click Ok after verifying that all Tests are passed on the Setup Support Rules page
5	Type your Product Key and then click Next
6	Check I accept the license terms and then click Next
7	Click Install on the Setup Support Files page
8	Verify that all the Tests are passed on the  Setup Support Rules and then click Next For the Network Binding order warning ensure that the Network configuration is correct as described on the first part of this Post
9	The setup program will detect automatically the clustered instances on your configuration and from the Cluster Node Configuration Page you will be able to choose to which SQL cluster you would like to add this node   Choose the instance id and then click Next
10	On the service Accounts Page retype the password for each account and the click Next
11	Click Next on the Error Reporting Page
12	Click Next on the Add Node Rules
13	Click Install on the Ready to Add Node Page
14	Wait for the installation Progress
15	Click Close on the Complete Page Now you have a full functional two nodes cluster of SQL Server 2008 R2

Step by Step Clustering SQL Server 2008 R2 Part IV

Part I – Before we start
Part II – Creating Windows Cluster
Part III – Clustering MSDTC
Part IV – Installing the first SQL Server Cluster Node
Part V – Adding the second node
Part VI – Post installation tasks

1	Using the CLSSetup account that have the privileges to join computers to domain and configured as Local Administrator on each node open a session and run the setup program of SQL Server 2008 R2
2	Click Yes on the User Access Control message if it’s appear
3	Select the Installation page and then click New SQL Server failover cluster installation
4	on the Setup Support Rules verify that all tests are passed and then click Ok
5	Type you Product Key and then click Next
6	Check  I accept the license terms Click Next
7	On the Setup Support Files click Install
8	When Support files are installed a new rules check will be processed by the setup program ensure that all tests are passed and then click Next
9	Select the features that will be installed and the click Next. Note : SSRS is not cluster aware
10	On the Instance Configuration page type the Network Name that will be used for your Clustered SQL Server  Instance , type an instance ID if you won’t use the default name MSSQLSERVER and then click Next
11	Click Next on the Disk Space Requirements Page
12
13	Select the Shared Disks that will depend on your SAL Server Cluster Group  and then click Next
14	Type the virtual IP Address that will be used for your SQL Server Cluster Click Next
15	Click Next on the Cluster Security Group page
16	Type the account names and their passwords for the services accounts that will be used
17	Click on the Collation tab if you want to change the default collation of the server by clicking the Customize button Click  Next
18	On the Database Engine Configuration Page choose your Authentication Mode, type the password for the sa account if you choose Mixed Mode. Add the AD users or groups that will have the sysadmin role.
19	Click Data Directories Tab and then configure the different drive for each kind of data that will be host on the nodes and then click Next
20	Click Next on the Error Reporting Page
21	Click Next on the Cluster Installation Rules
22	Click Install on the Ready to Install Page
23	Wait for the Installation progress
24	Click Close on the Complete Page
25	From the Failover Cluster Manager verify that all resources was created and are Online on the first node