SQL Server: Impact of renaming the partitioned table on data

Hello all, Recently I helped an application team to rename a partitioned table of a production database. The application team had questions around data availability when the table is being renamed and ensure that the existing data is intact even post renaming the table. In this blog, I am covering the scenario of renaming the…

0

SSIS package execution failure when SSISDB is configured with AlwaysOn

Hello all, Recently I worked on an interesting issue with SSIS package execution issue. In this blog, I am sharing the steps taken to isolate the cause and fix it. Issue Description: SSIS Package execution fails when it is executed from Integration Services catalog from the secondary replica node using the listener name. No issue…

0

Database Mirroring Configuration Failure scenarios

Hello all, In this blog, I am covering few scenario’s that I have encountered while configuring Database mirroring as a high availability solution for SQL Server database. For demonstration purpose, I am using SQL 2012 instances on Windows 2012 R2 server. Principal Server: SQLServer\SQL2012Mirror Server: SQLServerDR\SQL2012Witness Server: Witness\WitnessMirrored Database: DBMirrorMirroring Port : 5022Service Account: SQLServiceAccount@contoso.lab…

5

OPENDATASOURCE query execution error while using SQL public account

Hello all, Recently, I was trying to load data from an Excel file without having SysAdmin rights. I used the OPENDATASOURCE command to accomplish this, and I failed. However, if I used the SysAdmin account to execute the query, I was able to successfully load the Excel data. In this blog, I am covering this…

10

SQL Server Report Execution Fails with "rsRenderingExtensionNotFound" error.

Hello all, Recently, I came across a scenario with a report execution issue. In this blog, I would like to share the steps I used to fix the issue. Problem Description SQL report execution fails with the following error: You have attempted to use a rendering extension that is either not registered for this report…

1

Report Server database migration fails at "Setting DSN" step

Hello all, Recently I worked on a scenario where the requirement was to migrate the ReportServer database from SQL 2008 R2 instance to SQL 2014. In this blog, I would like to share the steps used to fix the issue. To illustrate the issue, I have installed SQL 2008 R2 Reporting Server “SSRSServer” on Windows…

3