DCSIMG
April 2012 - Posts - Yuval Sinay
Sign in | Join | Help

Yuval Sinay

Yuval's blog.

April 2012 - Posts

SQL Reporting Services Migration Tool

Published at Apr 22 2012, 03:33 AM by yuval14
  • SQL Reporting Services Migration Tool allow you to migrates reports and other artifacts from one report server to another report server. It can also be used as a backup and restore tool for Reporting Services.
  • “You can use RSMigrationTool or RSMigrationUI to backup your native report server.
  • To restore or migrate the native server, run the Migration.ps1 from a PowerShell console.
  • Source and target server must be SQL Server Reporting Services 2008 R2 or later.
  • Source server
    • Source server must be native mode using Windows authentication. (We are working on support for SharePoint integrated mode and other authentication schemes.)
    • Permissions and roles from source server are not backed up o Configuration in source server is not backed up.
    • Reports and other artifacts in deeply nested subfolders may not be backed up. This is due to Windows OS restriction on the maximum length for the full path of the backup files and folders. (We are working towards a solution.)
    • Linked reports are not support in SharePoint mode, hence not backed up.
    • Database connection to source server catalog is made using Windows Integrated credentials of the user running the tool.
  • Target server
    • Target server must be SharePoint integrated mode. (We are working on support for native mode.)
    • The web application must be using Windows classic authentication mode. (We are working on support for other authentication schemes.)
    • Target server must be correctly configured. Target document library and folder must be created. For SSRS 2012, service application must be created and configured.
    • The owner of Reporting artifacts after migration is set to the user who performed migration. (We are working towards a solution.)
    • Subscription owners are set after they are migrated. If the owner does not have CreateAlerts/ManagedAlerts permission, the operation will fail.
    • Report parts are not linked correctly to the Report. (We are working towards a solution.) o Database connection to target server catalog is made using Windows Integrated credentials of the user running the tool.”
    • The tool can be download from the following link.

How to renew User/Computer certificate without require to do application side changes

Published at Apr 21 2012, 07:58 PM by yuval14

The renewal process of user/computer certificate require (in the most of the cases) to implemented changes in the application side (e.g. IIS,Outlook etc.),

As a workaround for this “limitation”, the renewal process of the User/computer certificate can be set to use exiting certificate key.

However, using exiting certificate key may reduce the system security level, and this may lead to system/certificate compromise.

Warring: To reduce the security risk of implementing changes in the Enterprise PKI (Public Key Infrastructure), its highly recommended to test this changes in a lab - before making changes in the production environment.

To renew the certificate by using exiting certificate key, please use the following instructions:

A. PKI Prerequisites:

1. Depending on the certificate template type/settings, the Certificate Authority security settings should allow the user that renew the certificate to have the following privilege: “Request Certificates”.

image

2. Depending on the certificate template type/settings, the user that renew the certificate may require the following privilege on the relevant Certificate Template: “Enroll” and/or “Autoenroll”.

image

B. The renewal process:

1. Logon to the computer.

2. Navigate to “Start” –> “Run” and type “mmc” and click “OK” to launch the Management Console 

3. Navigate to “File” > “Add/Remove” Snap In… , select “Certificates” and click “Add”.

4. Select “Computer Account” (or “User Account”) and click “Next”. Then", click “Finish”. Once back on the Snap In screen, click “OK”.

5. Expand “Certificates” > “Personal” and click on “Certificates”.

6. Right-click on the required certificate and select “All Tasks” > “Advanced Operations” > “Renew This Certificate with the Same Key”.

7. Click “Next”, and then “Enroll”. Once complete, click “Finish”.

System Center 2012 – Configuration Manager Component Add-ons and Extensions

Published at Apr 20 2012, 12:07 AM by yuval14

“Following System Center 2012 – Configuration Manager add-ons and extensions are available for download:
Package Conversion Manager (PCM) The Microsoft System Center 2012 Configuration Manager Package Conversion Manager allows for converting packages and programs into applications and deployment types in System Center Configuration Manager 2012. There is a migration feature which will be released with the Configuration Manager 2012 that allows packages to be migrated from 2007 to 2012. Once you have migrated your package objects and installed PCM then it is just a matter analyzing your packages in order to determine which readiness state each are in, and then converting those packages that are in the appropriate readiness state. . This release comes in 4 languages.
Physical to Virtual (P2V) Migration Toolkit
The System Center 2012 Configuration Manager P2V Migration Toolkit facilitates the re-utilization of existing x64 server hardware using virtualization technologies, Windows Server 2008 R2 and Hyper-V. The P2V Migration Toolkit was specifically designed to assist in situations where there are remote Configuration Manager 2007 SP 2 site servers that need to be retained during side-by-side migration process to System Center 2012 Configuration Manager. The P2V Migration Toolkit is geared to supporting P2V migrations at remote, branch offices that do not have existing onsite Virtual Machine Manager infrastructure.
System Center 2012 Configuration Manager Toolkit The Microsoft System Center 2012 Configuration Manager Toolkit contains nine downloadable tools to help you manage and troubleshoot Microsoft System Center 2012 Configuration Manager. The following list provides specific information about each tool in the toolkit.

  • Client Spy - A tool that helps you troubleshoot issues related to software distribution, inventory, and software metering on System Center 2012 Configuration Manager clients.
  • Policy Spy - A policy viewer that helps you review and troubleshoot the policy system on System Center 2012 Configuration Manager clients.
  • Security Configuration Wizard Template for Microsoft System Center 2012 Configuration Manager - The Security Configuration Wizard (SCW) is an attack-surface reduction tool for the Microsoft Windows Server 2008 R2 operating system. Security Configuration Wizard determines the minimum functionality required for a server's role or roles, and disables functionality that is not required.
  • Send Schedule Tool - A tool used to trigger a schedule on a client or trigger the evaluation of a specified DCM Baseline. You can trigger a schedule either locally or remotely.
  • Power Viewer Tool – A tool to view the status of power management feature on System Center 2012 Configuration Manager clients.
  • Deployment Monitoring Tool - The Deployment Monitoring Tool is a graphical user interface designed help troubleshoot Applications, Updates, and Baseline deployments on System Center 2012 Configuration Manager clients.
  • Run Metering Summarization Tool - The purpose of this tool is to run the metering summarization task to analyze raw metering data
  • Role-based Administration Modeling and Auditing Tool – This tool helps administrators to model and audit RBA configurations.
  • License Tracking PowerShell Cmdlets - The PowerShell cmdlet “Get-ConfigMgrAccessLicense” is used to get license usage information for all the servers and clients within scope of System Center 2012 Configuration Manager. The cmdlet returns a list of licensable features and a list of unique users and devices per unique licensable feature.”

The System Center 2012 – Configuration Manager Component Add-ons and Extensions can be download from the following link.

Microsoft Deployment Toolkit (MDT) 2012

Published at Apr 17 2012, 03:11 PM by yuval14

“Microsoft Deployment Toolkit (MDT) 2012 is the newest version of Microsoft Deployment Toolkit, a Solution Accelerator for operating system and application deployment. MDT 2012 supports deployment of Windows 7, Office 2010 and 365, and Windows Server 2008 R2 in addition to deployment of Windows Vista, Windows Server 2008, Windows Server 2003, and Windows XP.”.

The Microsoft Deployment Toolkit (MDT) 2012 can be downloaded from the following link.

Update Rollup 2 for Exchange Server 2010 Service Pack 2 (KB2661854)

Published at Apr 16 2012, 08:24 PM by yuval14

“Update Rollup 2 for Exchange Server 2010 Service Pack 2 resolves issues that were found in Exchange Server 2010 Service Pack 2 since the software was released. This update rollup is highly recommended for all Exchange Server 2010 Service Pack 2 customers.”

The Update Rollup 2 for Exchange Server 2010 Service Pack 2 can be downloaded from the following link.

Exchange 2010 Backup issues due Shadow Copy error “Last error: Retryable error”

Published at Apr 16 2012, 12:41 PM by yuval14

Customers that using a Backup/Snap/Cloning/Replication (from common hardware vendors) may report on failed jobs during Backup/Snap/Cloning/Replication operation/s.

Using “vssadmin list writers” command, that following error message may appear:

clip_image001

To resolve this issue, please consider the following steps:

1. Reboot the server.

2. Reconfigure the Backup/Snap/Cloning/Replication jobs to not run in the same time.

3. Free 4-6 GB from the “C”/System Drive drive of the Exchange server.

4. Upgrade to the latest version of the Backup/Snap/Cloning/Replication software.

5. Contact your Backup/Snap/Cloning/Replication vendor/provider for further information.

Microsoft® SQL Server® 2012 Best Practices Analyzer

Published at Apr 09 2012, 08:50 AM by yuval14

“The Microsoft SQL Server 2012 BPA is a diagnostic tool that performs the following functions:

  • Gathers information about a Server and a Microsoft SQL Server 2012 instance installed on that Server
  • Determines if the configurations are set according to the recommended best practices
  • Reports on all configurations, indicating settings that differ from recommendations
  • Indicates potential problems in the installed instance of SQL Server
  • Recommends solutions to potential problems”

The SQL Server 2012 Best Practices Analyzer can be downloaded from the following link.

Active Directory Recycle Bin feather in Windows 8

Published at Apr 06 2012, 01:47 AM by yuval14

Active Directory Recycle Bin feather introduced in Windows 2008 R2 Active Directory. However, using Active Directory Recycle Bin feather

in Windows 2008 R2 required using a complex suite of PowerShell commands.

Windows 8 introduce a new management console for Active Directory that allow you centralize the management of common Active Directory tasks

from one location.

One of settings that can be enabling in the “Active Directory Administrative Center”, is enabling Active Directory Recycle Bin feather by using a user friendly console.

Before we start to enable the new feather, a few useful tips:

a, Please note that Active Directory Recycle Bin feather require Windows 2008 R2 Forest Mode or higher.

b. Deleted Active Directory object that pass the tombstone lifetime cant be recovered by Active Directory Recycle Bin feather.

c. The tombstone lifetime attribute should be set to 180 days (the default value for new Forest).

d. You cant disable Active Directory Recycle Bin after you enabled it.

 

To enable and use Active Directory Recycle Bin feather, please use the following steps:

1. Under “Server Manager” press on “Tools” button.

image

2. From the drop menu choose “Active Directory Administrative Center”.

image

3. In the left side of the screen, press on the server name.

image

4. In the right screen (“Tasks” section) press on “Enable Recycle Bin”.

Note1: You can use instead “Enable-ADOptionalFeature” PowerShell command.

Note2: The new settings would need replicate to all the domain controllers in the forest.

4. The “Enable Recycle Bin” should be mark with a gray color.

image

5.Right click on the server name and choose “Deleted Objects” button.

image

6. Now, new Active Directory object that need to be restore (e.g. “test” user account), can be restore by one-two mouse clicks.

image

 

For further information, please review:

Active Directory Administrative Center Enhancements

Microsoft® Connectors v1.2 for Oracle and Teradata

Published at Apr 04 2012, 12:29 PM by yuval14

Microsoft® Connectors v1.2 for Oracle and Teradata provide additional value for SQL Server Integration Services (SSIS).

“Microsoft Connector Version 1.2 for Oracle by Attunity - The Oracle source and destination components are written to achieve optimal performance when loading data into Oracle or unloading data from Oracle in the context of Microsoft SSIS.
Microsoft Connector Version 1.2 for Teradata by Attunity - The components are written to achieve optimal performance when loading data into Teradata or unloading data from Teradata in the context of Microsoft SSIS.
Microsoft SSIS Connectors by Attunity Version 1.2 is a minor release. It includes performance enhancements, bug fixes, and continued improvements for ease of use.
The following enhancements were made:

  • Teradata Enhancement - Support for TPT API 14.0 and TPT API 13.10.
  • Support was added for Teradata 13.10 and Teradata 14.0 by supporting TPT API version 13.0 and TPT API version 14.0 (14.00.00.02 or higher). Previous versions of the TPT API are still supported.
  • Teradata Enhancement - Starting from Teradata 13.0 Teradata database supports DDL with no primary index which was introduced specifically for loading data faster into Teradata; these tables were not listed in the table dropdown list.
  • Teradata Bug Fix - Teradata DDL supports column names being reserved words. Teradata Connector could not work with tables having such columns.
  • Teradata Bug Fix - Teradata destination component failed to read problematic rows from the error table with the following error: “Errors while trying to read error tables. Invalid TPT operator.””
  • The tool can be downloaded from the following link.