User profile service and User Profile Synchronization service

User profile service and User Profile Synchronization service

This is a common question that many of SharePoint administrators think at the beginning, what is the difference between those and why they are used. Here is the answer for your question.

Explanation:

Coming to a background of  user Profiles

The service application is used to import the users from other directories such as LDAP, Novell, Tivoli, Unix into SharePoint. There are many changes in user profile included in service application from Moss 2007 to SharePoint 2010 and 2013.there are two ways that we can import users. In Moss 2007 we have only option is to import users from AD to SharePoint. We cannot update the user information Vice Versa. When Coming into SharePoint 2010 and 2013,we have both the options depends on our Farm. It should be like we can only get the user from AD->SharePoint  and It should be like the user update can be done from SharePoint t-> AD

FIM(Forefront identity manager)is also introduces in between AD and SharePoint in SharePoint 2010 to get the updates.

3 data bases will be created after creating the user profile service application, those are

·         Profile database – used to store user profile information.

·         Synchronization database – used to store configuration and staging information for synchronizing profile data from external sources such as the Active Directory Domain Services.

·         Social tagging database – used to store social tags and notes created by users. Each social tag and note is associated with a profile ID.

Difference of User profile service and User Profile Synchronization service

It’s very simple to understand

·         User profiles – contain detailed information about people in an organization. A user profile organizes and displays all of the properties related to each user, together with social tags, documents, and other items related to that user.

·         Profile synchronization – provides a reliable way to synchronize groups and user profile information that is stored in the SharePoint Server 2013 profile database together with information that is stored in directory services across the enterprise.

User Profile Service:

This service should be used, If we just want to import the users from AD only not to update the user information in a way from SharePoint->AD. It’s a single way of communication

User Profile Synchronization service:

This service should be used, If we  want to update the users information Vice versa. If the information for a user is updated in SharePoint, it should be reflected also in AD because of this service. It’s a Two way communication

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

SQL Reporting services Installation with SharePoint 2013

SQL Reporting services Installation with SharePoint 2013

As we all know that we use Reporting services integrated with SharePoint. The Installation and configuration of reporting services with SharePoint 2010 is pretty straight forward but there are many changes in reporting services that to integrate with the SharePoint 2013. This post will walk through the steps required to set up SQL Server Reporting Services in Integrated mode with SharePoint 2013.

To start with, it’s important to understand that SSRS will install as a SharePoint service application. This obviously means that it must be installed on a machine that is part of the  SharePoint farm. In a single SharePoint front end environment it is much better to add SSRS to your SharePoint server than it is to add SharePoint to your SQL server. Obviously, if you have a separate SharePoint application server, that’s the best place for it.

To install and configure the Reporting services, we need to have SQL Reporting features and the SharePoint 2013 Installation  on the server.

·        SQL 2012

·        SharePoint 2013

How to Install the SQL reporting service Feature:

Follow the below article on how to install the shared feature for SQL

http://expertsharepoint.blogspot.de/2014/03/how-to-add-shared-feature-in-sql-2012.html

Check the Boxes as per the screen shot below to get the Reporting services feature.         

How to Install the SharePoint 2013:

Follow the below article on how to install the SharePoint.

http://expertsharepoint.blogspot.de/2013/11/detailed-sharepoint2013-installation-i.html

After the Installation of SQL Feature and SharePoint:

Here, we need to consider two things to get the Reporting services feature

1.   Install SharePoint First and then the Reporting services feature, Then You can see the Reporting Service Application Under Application management->service Applications

2.   Another thing that you should note is that the order of operations is important here. If you install Reporting Services prior to SharePoint  installation in the SharePoint on the farm, the option to create a Reporting Services application will not appear under the service application in SharePoint. That’s because it won’t be registered with the farm as a service application. If this happens, you can run the following Power Shell to register the Service Application

Go to SharePoint Management shell and run the below power shell commands.

Install-SPRSService

Install-SPRSServiceProxy

The next thing you need to do is to provision the service application from central administration.

Go to central administration->application management->Manage Service applications->Click on New on Ribbon

You can see the SQL server Reporting services Application, Click on the Service and fill out the details And select OK. Ensure  that you navigate to the bottom of the form and select the applications to activate SSRS on

Once the service application and proxy have been created, click on it to access the management screen.

You’ll want to access each of the sections and fill out the appropriate options for your installation. you should back up your encryption key in the key management section, Set your unattended execution account, and your email server settings if you want to be able to deliver reports via email. If you want to enable self service subscriptions and alerts, fill out that section, and it contains instructions for setting up the SQL agent service to support it.

The most important section is System Settings, which controls the bulk of how Reporting Services will run. Clicking on it accessed the service itself, 

If you can access your system settings, then you should be good to go. The next step is to enable SSRS in your site collections. To do this, Go to Every site>site settings->Check the Report services Option and enable settings.

That’s It. Your good to access the Reports now.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Installation of SQL server 2012

Installation of SQL server 2012

I am providing the step-by-step instructions in this article on how to install SQL server 2012 with a Single Instance on a windows server 2012.

·        Run setup.exe

·        Click on Installation

      

·        Click on New SQL server stand alone or add feature to an existing installation

·        Rule check in progress will start, Click OK once done

         

·        Enter the product key, click Next

·        Accept the License agreement, click next

·        Install setup files will start

        

·        Setup support rules will start, click next

          

·        Select SQL server feature installation, Click next

          

·        Select the Instance Features as you required, Change the directory of the Features if required,Select the Management tools on botom to open the SQL in management studio. click next

              

·        Click next

·        Select Named Instance, If you want to create Instance or else select Default Instance, click next

          

·        Disk space requirements checks starts, Click next

·        Once the credentials provided, click next

·        Click on ADD current user and check the Data Directories, click next

             

·        Click next on Error reporting

·        Click next on installation configuration Rules

·        Click Install

·         Click Close once the installation done.
       

How to open SQL:

·        Go to Search->type->SQL

               

·        Click On SQL server Management studio

·        Open a POP up with server name and Instance, click Connect

·        You can able to connect the Instance.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

How to Add Shared Feature in SQL 2012

How to Add Shared Feature in SQL 2012

We face difficulty many times, when we want to add the shared feature in SQL 2012 related to SharePoint. the features that we normally add related to SharePoint is Reporting services, Integration services etc..In this article I am giving details on how to add  the Shared features.

·        Go to SQL 2012 binary, double Click on Setup.EXE

·        Process will start

·        Click on Installation->select “new SQL server stand alone installation or add features to an existing installation”

·        Rule check in progress starts, click OK,Ignore the below Error

·        Click on next

·        Click Next once Check done

·        If you want to add features to Instance select "add features to existing instance", If you want to add on Default instance, select "Perform new installation of SQL server 2012"

·        Click on next and Choose product Key

·        Click on next

·        Accept the Terms and conditions and click next

·        This is where we need to choose the SQL server feature installation, Click next

·        Choose the feature that you want to add and click next

·        Process starts, click on next

·        Drive space requirements shows, click on next

·        Provide the Account details and next

·        Click on next

·        Installation configuration rules, click on next

·        Ready to install, Click on install

·        Installation progress starts

·        Click Close once the feature added.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

How To Remove of Shared Feature in SQL 2012

How To Remove of Shared Feature in SQL 2012

We face issue many times, when we want to remove the shared feature in SQL 2012 related to SharePoint. the features that we normally install related to SharePoint is Reporting services, Integration services etc..In this article I am giving details on how to remove the Shared features.

·        Go to control panel of the server    

·        Select the Microsoft SQL server 2012(64Bit),Right click on that

·        Click on Uninstall or change a program

·        Click On Remove

     

·        The process will start and Rule check in progress starts

·        Click OK once the check in progress completes

·        If want to remove the Total Instance, Choose Instance and click Next.

·        If only Shared Features, Choose Remove Shared Features only, click next

·        Here, you need to select Which feature you want to remove. I choose Integration services, Click Next

·        Click next

·        A screen will appear with the Confirmation, Click on Remove

·        Remove of feature will start

·        Once Done, Click on close. the feature get removed

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!