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 ...

Error : SERVER1: Windows 2008 R2 (x64) SharePoint 2010 SERVER2: Windows 2008 R2 (x64) SQL 2008 Services running on SERVER1 : (none as localsystem, localservice, networkservice) SharePoint 2010 Administration (started/auto) SharePoint 2010 Timer (started/auto) SharePoint 2010 Tracing (started/auto) SharePoint 2010 User Code Host (stopped/disabled) SharePoint 2010 VSS Writer (stopped/manual) SharePoint Foundation Search V4 (started/manual) SharePoint Server Search 14 (started/manual) The RELATED ISSUE(s): Search/indexing is not working, and in return, backups are failing claiming: Failure Message Object Query-0 (D: on SERVER1) failed in event On Backu p Search Service Application reports: Index Partition - 0 - SERVER2\Search_Service_Application_PropertyStoreDB_9a482efd99954748a062952a3d2617d7 Query Component 0 SERVER1 Not Responding System Event Log on SERVER1 reports: Event ID 2587 The following conditions are currently affecting index propagation to...

Symptoms When users perform a search in a Microsoft SharePoint environment, they receive the following error message: Internal server error exception: Troubleshoot issues with Microsoft SharePoint Foundation Additionally, the following critical exception may be written to the ULS log of the SharePoint Web front-end server:  Process : OWSTIMER.EXE (0x1CE0) Product : SharePoint Foundation Category : Topology EvendID : 8031 Message : An exception occurred while updating addresses for connected app {eaf6c00c-cc3f-460e-8bf2-ad9b991ea6ea_aa16845d-045a-46bc-bbc6-d701ff13950d}. The uri endpoint information may be stale. System.InvalidOperationException: The requested application could not be found at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ProcessCommonExceptions(Uri endpointAddress, String operationName, Exception ex, SPServiceLoadBalancerContext context) at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ExecuteOnChannel(String operationName, CodeBl...

This topic describes how to configure a Windows firewall for Database Engine access in SQL Server 2016 by using SQL Server Configuration Manager. Firewall systems help prevent unauthorized access to computer resources. To access an instance of the SQL Server Database Engine through a firewall, you must configure the firewall on the computer running SQL Server to allow access. For more information about the default Windows firewall settings, and a description of the TCP ports that affect the Database Engine, Analysis Services, Reporting Services, and Integration Services, see  Configure the Windows Firewall to Allow SQL Server Access . There are many firewall systems available. For information specific to your system, see the firewall documentation. The principal steps to allow access are: Configure the Database Engine to use a specific TCP/IP port. The default instance of the Database Engine uses port 1433, but that can be changed. The port used by the Database Engine is l...

Error : Failed to get the server time zone id. Exception: Microsoft.SharePoint.SPEndpointAddressNotFoundException: There are no addresses available for this application.  When I check the View Web Analytics Reports from Central Admin on Production, it throws the above error though it works on Test environment. To resolve this, I have performed the following steps by looking at the ULS Logs. Navigate to  Central Administration   System Settings  and click on  Manage Services on Server Stopped  the following two services though it was already started Web Analytics Data Processing Service Web Analytics Web Service Started  the above two services but when I check View Web Analytics Report, doesn’t seem to work. On Further checks found the  Manage Metadata Service App  wasn’t able to retrieve the metadata Stopped and Started  the  Managed Metadata Web Service This resolved the issue for me now able to view th...

To prevent Enterprise keyword fields from offering suggestions from a team set then unckeck this setting  Office 2010/2013 can integrate with Managed Metadata site column If you want to use Content type hubs then you need to activate this site collection feature :Content Type Hub Syndication feature.

Farm Information: Web Application published internally and externally (so make sure both URLs added to  Alternate Access Mapping ) Office Web Apps 2013 (Published externally via  TMG 2010  and internally) I have a farm which connected to Office Web Apps 2013 and It's working fine internally so then we decided to enable it to open Office Web Apps externally by the following steps : 1- In Office Web Apps Server , Open Power Shell and run this command to add the External URL to existing Farm: Set-OfficeWebAppsFarm -ExternalURL  http://test.com/  2-In SharePoint Server , Open SharePoint 2013 Management Shell and run the following commands:  Remove-SPWOPIBinding –All:$true New-SPWOPIBinding -ServerName OfficeWebAppServer.com -AllowHTTP Set-SPWopiZone internal-http $c = Get-SPSecurityTokenServiceConfig $c.AllowOAuthOverHttp = $true $c.Update()  then when I tried to access the Office documents from External URL I got the following error ...

Image Renditions Good Ref : http://blog.mastykarz.nl/image-renditions-sharepoint-2013/ http://msdn.microsoft.com/en-us/library/jj720398.aspx http://msdn.microsoft.com/en-us/library/jj720392.aspx http://sp2013.blogspot.com/2012/07/image-renditions.html Required to enable Blob Cache IFrame Support Good Ref : http://www.learningsharepoint.com/2012/11/24/how-to-use-iframes-in-sharepoint-2013/ SEO ,Friendly URLs and SiteMap Good Ref : http://blog.mastykarz.nl/search-engine-optimization-sharepoint-2013/ http://www.informedconsulting.nl/blog/?p=283 Managed Navigation Good Ref : http://blog.robgarrett.com/2012/09/23/sharepoint-2013-managed-navigation / Cross Site Publishing Good Ref : http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=1038 http://blogs.msdn.com/b/justinvoels/archive/2012/09/24/sharepoint-2013-search-driven-publishing-and-cross_2d00_site-collection-publishing-overview.aspx http://blog.mastykarz.nl/easier-working-assets-cros...

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