SharePointSupport

Click to GetHelp

Cannot connect to database master at SQL Server at server_name. The database might not exist, or the current user does not have permission to connect to Error : "Cannot connect to database master at SQL Server at server_name. The database might not exist, or the current user does not have permission to connect to it"  Solution : Open the Windows Firewall with Advanced Services and add an inbound rule to allow traffic over port 1433. https://youtu.be/GIwcnNZWui4

Error  : There was an error while running  Install Prerequisite (prerequisiteinstaller.exe)    “Failed to create configuration database. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details. ” Solution : you may face this issue while installing manually instead of using the prerequisiteinstaller.exe Uninstall  WcfDataServices   and then reinstalling the WcfDataServices using the prequisiteinstaller.exe automatically or using command with the appropriate parameter. prerequisiteinstaller.exe /wcfdataservices56: WcfDataServices.exe location Then delete two databases from SQL Server which are created by previous psconfiguration and run Products Configuration Wizard again, it will be successful.       Click to GetHelp

“ This program can’t start because api-ms-win-crt-heap-l1-1-0.dll is missing from your computer. ” error while running SharePoint Products Configuration Wizard. *Missing update patches " Windows 10 Universal Runtime update " for Windows Server 2012 R2. * Installation of Windows Server 2012 R2 patch  KB299926  is required so as to resolve this issue. But  “ The update is not applicable to your computer. ” error came after that as below. This is because Windows 10 Universal C Runtime  KB2999226  is dependent on a Windows Server 2012 R2 Cumulative Update package in  KB2919355 . Check windows updates, install patch  KB2919355  and “The update is not applicable to your computer.”error will be resolved and after which there will be no error in installation of  the Windows 10 Universal C Runtime. Have a look into my previous post  Install Prerequisite (prerequisiteinstaller.exe) SharePoint 2016 . Unable to install Microsoft...

Hi Everyone. The waiting came to an end and started working with the most recent version of SharePoint.It's very exciting to work with newer version SharePoint 2016 . We started with the installation of SharePoint 2016 and faced one issue in the first step . When I run the  Install Prerequisite (prerequisiteinstaller.exe) , the “ There was an error during installation.Unable to install Microsoft Information Protection and control Client 2.1 ” error appears as below. This means that there is error in downloading automatically and this needs to be downloaded and installed manually. You can click on the links to download directly. Application Server Role, Web Server (IIS) Role Microsoft SQL Server 2012 SP1 Native Client Microsoft ODBC Driver 11 for SQL Server Microsoft Sync Framework Runtime v1.0 SP1 (x64) Windows Server AppFabric 1.1 Windows Identity Foundation (KB974405) Microsoft Information Protection and Control Client 2.1 Microsoft WCF Data Services 5.6 ...

I have got this error while trying to install SharePoint 2013 What is Max Degree of Parallelism ? When an instance of SQL Server runs on a computer that has more than one microprocessor or CPU, it detects the best degree of parallelism, that is, the number of processors employed to run a single statement, for each parallel plan execution. You can use the  max degree of parallelism  option to limit the number of processors to use in parallel plan execution. SQL Server considers parallel execution plans for queries, index data definition language (DDL) operations, and static and keyset-driven cursor population. Read this for more details http://technet.microsoft.com/en-us/library/ms189094.aspx How to fix it ? Open Microsoft SQL Server Management Studio Login with sysadmin user Right Click on instance name and select properties >> Advanced Change  Max Degree of Parallelism  to 1 Restart the SQL Service

* Though this topic is very simple and highly recommended approach in the enterprise deployments, I have seen many deployments which are not following this approach. E.g.: Using SQL client alias for SharePoint installations will be really useful if you want  move all databases to another SQL Server  by just making alias change point to the new SQL server. * In this post I’m going to cover how we can install & configure SharePoint 2013 Preview with SQL Client Alias. Though this post is talking about SharePoint 2013 preview, the underlying concept will be same for SharePoint 2010 & SharePoint 2013 RTM. * In my test lab, I have total four virtual machines configured. This post is based on a SharePoint small server farm for setup and proof of concept. I will refer to this same environment in my future blog posts, there will be more servers adding to the existing server farm. litdc  : is the domain controller and AD server (domain : litware.local), this m...

If you block UDP port 1434 or TCP port 1433 on the computer that is running SQL Server, you must create a SQL Server client alias on all other computers in the server farm. You can use SQL Server client components to create a SQL Server client alias for computers that connect to SQL Server. To configure a SQL Server client alias 1. Verify that the user account that is performing this procedure is a member of either the sysadmin or the serveradmin fixed server role. 2. Run Setup for SQL Server on the target computer, and install the following client components:  Connectivity Components  Management Tools 3. Open SQL Server Configuration Manager. 4. In the navigation pane, click SQL Native Client Configuration . 5. In the main window under Items, right-click Aliases , and select New Alias . 6. In the Alias - New dialog box, in the Alias Name field, enter a name for the alias. For example, enter SharePoint_alias. 7. In the Port No field, enter the port number fo...

Account Purpose Requirements SQL Server service account The SQL Server service account is used to run SQL Server. It is the service account for the following SQL Server services:  MSSQLSERVER  SQLSERVERAGENT If you do not use the default SQL Server instance, in the Windows Services console, these services will be shown as the following:  MSSQL<InstanceName>  SQLAgent<InstanceName> Use either a Local System account or a domain user account. If you plan to back up to or restore from an external resource, permissions to the external resource must be granted to the appropriate account. If you use a domain user account for the SQL Server service account, grant permissions to that domain user account. However, if you use the Network Service or the Local System account, grant permissions to the external resource to the machine account (<domain_name>\<SQL_hostname>). The instance name is arb...

In this article we learn how to configure a user profile and My Site configuration in SharePoint 2013. In earlier versions of SharePoint, each user had a profile and a personal site (e.g., My Site). The 2013 version of SharePoint splits My Site into three sections: Newsfeed, SkyDrive, and Sites. A global navigation bar provides access to each section. These social features are tightly integrated into SharePoint 2013, so you no longer need to launch a web browser to access them. Use the following procedure to create a My Site Host site collection:     1. Verify that the user account that is performing this procedure has the following credentials:         The user account that performs this procedure is a farm administrator         The user account that performs this procedure is a member of the Administrators group on the computer that is running SharePoint Server.      ...

There are many great articles that talks about how to configure your SharePoint 2013 farm for apps development . At the end of this article I will list a lot of these great references. I’m going to try to summarize the important things you need to know and also cover few FAQs along the way. First of all, you need to know that there are two main types of SharePoint apps you can develop on prim in your local SharePoint 2013 farm: SharePoint hosted apps SharePoint provider hosted apps The third type SharePoint Auto hosted (Azure auto hosted apps) is only available on SharePoint online tenants part of Office 365 . Also it’s important to note that if you plan to publish your SharePoint app into the SharePoint store to make some money the above mentioned types (Hosted & provider hosted) are the only allowed ones as long as they don’t request full control permission. For more details about the submission requirements check this link . In order to make your SharePoint 20...