EugeneChiang.com

Knowledge is Power. Never Stop Learning. Seek the Truth.

.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress

Failed to load expression host assembly. Details: Could not load file or assembly or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingExprHostAssembly)

Error: Got the following error after upgrading SSRS. Failed to load expression host assembly. Details: Could not load file xxxxxxx or assembly or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingExprHostAssembly) Fix: For SQL Server 2014 to 2016, copy the missing dll to the new folder. From… C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting... » read more

0
Read
echiang
SQL Server Jobs Permission

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here’s how you can do so by using SQLAgentReaderRole in SQL Server. If you have several SQL Agent jobs on your system, it is inevitable that at some point in some of your in-house... » read more

0
Read
echiang
Microsoft Report Builder

Install Report Builder https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-report-builder?view=sql-server-ver15

0
Read
echiang
SSRS Semantic modeling language (SMDL)

Semantic Modeling Language (SMDL) SQL Server 2016+ SMDL models were deprecated as of the release of SQL Server 2014, the ability for them to function was still there. SSRS 2016 or later doesn’t support the Report Models feature. Uploading and managing report models is a discontinued feature on SQL Server 2016 (is no longer a... » read more

0
Read
echiang
TDE Certificate Expiration and Replacement

A certificate used in TDE will continue to work even after its expiration date. This is because the Database Encryption Key (DEK) in the user database is the key that encrypts the data at rest. DEK is the symmetric key stored in the user database boot record. The certificate which is stored in the master... » read more

0
Read
echiang
Retrieve SSRS RDL file from Database

You can get it from the Report Server Database. All the Reports deployed to the Server get stored in Catalog table in Binary data format and we need to convert it into XML file. And that XML file will be your actual Report. Use the following query to retrieve a list of SSRS reports with... » read more

0
Read
echiang
Always On stuck in Synchronizing State

Issue: Databases keep being in a status “synchronizing”. Question mark in the icon for primary server. Answers: “Synchronizing” state is the normal, healthy state for an Asynchronous-commit replica. Asynchronous-commit replicas support only the manual failover mode. Moreover, because they are never synchronized, they support only forced failover. Asynchronous-commit replicas are never synchronized

0
Read
echiang
Enable Promotion of Distributed Transaction for RPC for Linked Server

Also configured in the Linked Server Properties “Server Options” section called “Enable Promotion of Distributed Transactions for RPC”. ‘remote proc transaction promotion‘ is a new option on SQL Server 2008, which allows you to control whether or not you want to enlist remote stored procedure call in a distributed transaction. When this option is off (FALSE),... » read more

0
Read
echiang
Troubleshooting Distributed Transaction Coordinator (DTC)

Make sure the “Distributed Transaction Coordinator” service is running in the Window Services. Make sure the Security settings is configured correctly in Windows Component Services. Make sure firewall is not being blocked in the “Allow apps to communicate through Windows Firewall” section of Windows Firewall Control Panel section. If SQL Server Linked Server is setup,... » read more

0
Read
echiang
TSQL BEGIN DISTRIBUTED TRANSACTION

Specifies the start of a Transact-SQL distributed transaction managed by Microsoft Distributed Transaction Coordinator (MS DTC). Unlike a transaction on a local database, a distributed transaction involves altering data on multiple databases. Consequently, distributed transaction processing is more complicated, because the database must coordinate the committing or rolling back of the changes in a transaction as a self-contained unit. Sources: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/begin-distributed-transaction-transact-sql?view=sql-server-ver15

0
Read
echiang