Monday, August 11, 2014

The patch installer has failed to update the shared features. To determine the reason for failure, review the log files



The patch installer has failed to update the shared features. To determine the reason for failure, review the log files

Issue: The SQL server 2008 R2,CU13 upgrade installer failed with the error in Log as “The patch installer has failed to update the shared features. To determine the reason for failure, review the log files The Upgrade log

Overall summary:

 Final result: The patch installer has failed to update the following instance: INST1 INST2. To determine the reason for failure, review the log files.
  Exit code (Decimal):-2068578304
  Exit facility code:1204
  Exit error code: 0

Exit message: The patch installer has failed to update the following instance: INST1 INST2. To determine the reason for failure, review the log files.

Solutions: please follow the below solutions to resolve the issue.

Solution1:
1.     Before you try to install a cumulative update for the first time, rename the <System Drive>:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll file.
2.     If you have already tried to install a cumulative update and failed, rename the <System Drive>:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll, and then run the SQL Server repair process.

Try installing the CU for SQL once the above steps done.

Solution 2:To work around this problem, copy the existing Devenv.exe.config file from the following location to another copy that is named Devenv.exe.config.tmp..
drive:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\

And then run Setup again:

Solution 3: Copy the file SQSRVRES.DLL from C:\Program Files\Microsoft SQL Server\MSSQL10_50.<instance_name>\MSSQL\Binn\ to C:\Windows\System32\ and start the upgrade

Solution 4: Repair the shared components and then re-run the update.


Solution 5:Ensure to have a disk space available.

Solution 6: Repair the .NET Framework from Add Remove Program >Highlight .Net Framework 3.5 Sp1 >Select Change >Repair .
Run the update again

Note: The above resolutions apply all the Cu, Patches for SQL
 

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.

Cumulative update package 13 for SQL Server 2008 R2 SP2




Cumulative update package 13 for SQL Server 2008 R2 SP2

This article describes cumulative update package 13 (Build number: 10.50.4319.0) for Microsoft SQL Server 2008 R2 Service Pack 2 (SP2). This update contains hot fixes for issues that were fixed after the release of SQL Server 2008 R2 SP2.

Prerequisites
To apply this cumulative update package, you must be running SQL Server 2008 R2 SP2.

Restart information
You may have to restart the computer after you apply this cumulative update package.Downoad from the below.


 

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 feature: "windows SharePoint services integration" is not supported in this edition of Reporting Services



The feature: "windows SharePoint services integration" is not supported in this edition of Reporting Services

Environment: SharePoint 2013, SQL 2012 Reporting Services

Description: After setting up and configuring SSRS in SharePoint 2013; Once you navigate to Reporting Services Service Application and click on the Settings link you might see below error:

Error: The feature: "Windows SharePoint Services integration" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Windows SharePoint Services integration" is not supported in this edition of Reporting Services.

Solution: If this happens make sure you have the right SQL 2012 edition for the Reporting Services and Add-ins on the SharePoint server. 

For this navigate to Reporting Services log files location: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebServices\LogFiles\

Check for the following string in the log files:

"INFO: Reporting Services starting SKU: Express"
If you are able to find this line then it signifies that you have the wrong edition (i.e. SQL Express) on the server. SQL Express edition does not support Reporting Services integration and Power Pivot integration with SharePoint 2013.

To fix the issue:

Uninstall the existing SQL 2012 bits from the server. You can do that via control panel - add remove programs. Select SQL Server and then uninstall it.

Install SQL 2012 Enterprise/Standard now and follow the SSRS integration steps (running the PowerShell cmdlts and creating the Service Application).

How to configure the SSRS: http://expertsharepoint.blogspot.de/2014/03/sql-reporting-services-installation.html

MS article: http://technet.microsoft.com/en-us/library/ee384252%28v=sql.100%29.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.

Friday, August 8, 2014

Script to add or remove a user as site collection administrator in many site collections



Script to add or remove a user as site collection administrator in many site collections

Description: many times as a SharePoint administrator we required to perform a task that to add a user as administrator in many site collections. This is very difficult if has 100’s of site collections. In this article I am providing the script how to achieve this with one click.

Instructions: Follow the Instructions below to run successfully.

1.   Copy the script in notepad and save as .PS1
2.   Do modifications as said below
3.   Open power shell as Admin,Ensure your in the same location where Script is copied.
4.   Run ./Script.ps1
5.   You see a below screen once its run successfully

Modifications: You need to do below modifications according to your requirements.

1.   $newSiteCollectionAdminLoginName = "Name of user"
2.   $newSiteCollectionAdminEmail = " user  mail ID"
3.   $newSiteCollectionAdminName = " Name of user "
4.   $siteURL = " siteURL " #URL to any site in the web application.
Script:

# This script will add named Site Collection Administrator
# to all Site Collections within a Web Application.
#
# Author: Anil Avula
######################## Start Variables ########################
$newSiteCollectionAdminLoginName = ""Name of user "
$newSiteCollectionAdminEmail = " user  mail ID "
$newSiteCollectionAdminName = " Name of user "
$newSiteCollectionAdminNotes = ""
$siteURL = " siteURL " #URL to any site in the web application.
$add = 1 # 1 for adding this user, 0 to remove this user
######################## End Variables ########################
Clear-Host
$siteCount = 0
[system.reflection.assembly]::loadwithpartialname("Microsoft.SharePoint")
$site = new-object microsoft.sharepoint.spsite($siteURL)
$webApp = $site.webapplication
$allSites = $webApp.sites
foreach ($site in $allSites)
{
   
    $web = $site.openweb()
    $web.allusers.add($newSiteCollectionAdminLoginName, $newSiteCollectionAdminEmail, $newSiteCollectionAdminName, $newSiteCollectionAdminNotes)
   
    $user = $web.allUsers[$newSiteCollectionAdminLoginName]
    $user.IsSiteAdmin = $add
    $user.Update()
    $web.Dispose()
    $siteCount++
}
$site.dispose()
write-host "Updated" $siteCount "Site Collections."

 

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.

ShareThis

X