SQL account used for SharePoint

SQL account used for SharePoint

When we plan to build the SharePoint, The first and most important part is the account used for the SQL admin. Please find the details below that provide you more information on the account.

1. SQL Admin Account
SQL Admin account would be use to install SQL Server for your SharePoint and would be created in AD. This account should be a domain user and must be a local administrator on database server. These rights are enough to successfully install SQL Server. Do not use any other domain admin account or never make this as a domain admin account. I have seen people using domain admin account to install SQL and SharePoint which is a mistake and a threat to security. You can name this account as "sql_install" or "sql_admin".

2. SQL Service Account
This is the account that runs the SQL Server instance. This should be a domain user but do not make this as a local administrator for security reasons. You can name this as "sql_user" or "sql_services". While installing SQL Server with SQL Admin account, necessary permission would be granted to this account for running the SQL Server instance. At Server Configurations step during SQL Server installation, mention your SQL Service account as the account for SQL Server Database Engine and SQL Server Browser and automatically necessary rights would be granted to this account to run the SQL Server instance.

3. SharePoint Setup Account
Create an account "sp_install" (a recommendation, you can name it anything) in your AD and put this account in local administrator group on all SharePoint Servers. Make sure you do not put this account in domain administrator account. You should never use a domain admin account to install SharePoint and its services.

 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

The windows power shell snap in “microsoft.sharepoint.powershell“ is not installed on this computer.

The windows power shell snap in “microsoft.sharepoint.powershell“ is not installed on this computer.

 

Issue: The windows power shell snap in „microsoft.sharepoint.powershell“ is not installed on this computer

Cause: There could be many reasons for the issue. Below are some of the reasons.

1.    SharePoint is not installed

2.    Missing of .DLL file in the path(C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SharePoint.PowerShell)

3.    .DLL file is corrupted

4.    Unsupported version of power shell.

Solutions: Please follow the solutions below to resolve the issue

Solution1: Ensure the SharePoint is installed in the server.

Solution 2: please run the command to get the Dll fixed for SharePoint 2013.

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\InstallUtil /LogToConsole=true C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SharePoint.PowerShell\v4.0_15.0.0.0__71e9bce111e9429c\Microsoft.SharePoint.Powershell.dll

Solution3:Ensure the compatible versions of power shell is installed according to the product version.

 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

System Center 2012 R2 Operation Manager

System Center 2012 R2 Operation Manager

The SCOM 2012 is  the latest version to monitor the Systems. I found a very good article from MS which describes the details. Please find the link below.

 

 https://technet.microsoft.com/en-in/library/dn249696.aspx

I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

permissions needed to administrate SharePoint Server

permissions needed to administrate SharePoint Server 

The below are the permissions that required to user to administer the SharePoint farm.

1.   Local Administrator rights

2.   Farm Administrator rights

3.   Shell Administrator rights

Local Administrator rights are required in order to work with objects that require that right (such as creating IIS sites or importing the Microsoft.SharePoint.Powershell module).

Farm Administrator rights are required to perform various functions on the farm. Various APIs within SharePoint have an explicit farm administrator rights check.

Shell Administrator rights gives you additional rights on the databases in use by the farm so you can operate directly against them (working with databases via Central Administration is done via the Farm Admin account).

 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Regional settings in SharePoint

Regional settings in SharePoint the regional settings are determined by the regional settings of the computer that is running the Microsoft Dynamics NAV Windows client. SharePoint Server 2010 has the following regional Settings.
To change the regional settings for a SharePoint site Open the site on which you want to change the regional settings. On the Site Actions menu, choose Site Settings. On the Site Settings page, under Site Administration, choose Regional settings. On the Regional Settings page, select the settings that you want for this site, and then choose the OK button

 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.