Security rules violation exception when running subscriptions with SSRS Custom Authentication
I have implemented SSRS Custom Authentication using Microsoft.Samples.ReportingServices.CustomSecurity. Everything works correctly in SQL Server 2022 ReportServer- except for subscriptions. When I add new subscriptions and executed it, I get the…
SQL Server Reporting Services
how to fix issue om.microsoft.sqlserver.jdbc.TDSChannel enableSSL WARNING: TDSChannel ( ConnectionID:1 TransactionID:0x0000000000000000) SSL handshake failed: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
Previously, I used JDK 1.6.0, but due to company requirements, I had to switch to OpenJDK 8u422 in Eclipse. After making the change, I received warnings, and some functions also showed warnings when running. There are a few functions that do not display…
SQL Server Integration Services
SSRS URL certificate renewal
The SQL Server certificate associated with the SSRS URLs will expire on June 26th. A replacement certificate has been installed on the SQL Server, but instructions are needed for correctly binding it to the SSRS URLs. Could you please advise whether…
SQL Server Reporting Services
Can't enlist target server for SQL Server Agent
TITLE: Microsoft.SqlServer.Smo MSX enlist failed for JobServer 'iris-wl-a301.tw01.ppanggu.com'. For help, click:…
SQL Server Database Engine
Error trying to use latest SQL Server Migration Assistant for Access
I have the latest SSMA for Access installed but can't get past a "New Workspace Error" either via the start wizard or trying to open a solution I created about 9 months ago. The error states "The type initializer for…
SQL Server Migration Assistant
SQL Server Always On – Intermittent Cluster Failures in Test Setup
I am reaching out to receive support for SQL Server Always On configurations, specifically involving multi-node clusters with geographically distributed replicas in a test environment. I am currently evaluating the integration of an asynchronous…
SQL Server Database Engine
SSIS package row delimiter Failure
Hi, I have a package that reads a file from a network location and inserts the data into a database. The data flow task includes four components: Flat File Source Derived Column to convert DT_NText to DT_WTSR Derived Column to convert DT_WTSR to…
SQL Server Integration Services
Unable to Connect Azure SQL Managed Instance to Power BI
I am currently experiencing issues connecting Azure SQL Managed Instance to Power BI Desktop. Despite adding service tags and enabling the public endpoint, I am still unable to establish a connection. Please assist in resolving this issue.
SQL Server Reporting Services
Incorrect final summation in tabular model
Good day. I encountered a problem with incorrect aggregation. There is a dimension in the system with a hierarchy built in it. During aggregation, incorrect summation of data for hierarchy members occurs. At the same time, with each processing on the…
SQL Server Analysis Services
Deployed SSIS package has access denied to file directories and work fine in VS
I’ve tested a couple of things out with different packages that have been deployed to SQL Server. I noticed that within the same package, I can have a script task which fails to connect to a file directory but I don’t have an issue with connecting a flat…
SQL Server Integration Services
SQL Server 2025 AG health-check diagnostics to actually spit out their perf-counter dump (per the docs here: Lease & Health-Check Timeout),
Hey SQL Friends - I’ve been banging my head against the wall trying to get SQL Server 2025 AG health-check diagnostics to actually spit out their perf-counter dump (per the docs here: Lease & Health-Check Timeout),…
SQL Server Database Engine
Microsoft SQL Server Migration Assistant for Oracle Extension Pack missing SSMA for Oracle Data Migration Assistant.dll
We installed SSMA for Oracle 10.1 and were trying to use the client side migration but it is calling for too much ram, so we tried to use the server side migration. However that fails immediately without much info as to why. We installed the…
SQL Server Migration Assistant
SSMS not showing Attach Database/Locate Database Files Dialog DIR Tree.
I am unable to Attach a Database in SSMS. The Locate Database Files Dialog text is frozen on a USB port folder that no longer exists. Even entering a dummy database file *.mdf, the OK button does not enable. When I tried to repair SSMS, Error message;…
SQL Server Database Engine
flexi server database version from 14 to 15
Hi team, I would like to upgrade my production flexi server database version from 14 to 15 , but I want to retain the databases without any deletion or recreation. Is that possible ?
SQL Server Integration Services
My 30120 port is not working (FiveM Server)
Hello dear microsoft team i think i have a big problem. once upon a little time created a FiveM server then i did every single settings to do it perfect and when my server is done then i called my friend to join my server and play together but when he…
SQL Server Integration Services
summary.txt after rebuild the system database.
I ran the following command to rebuild the system database X:\Backups\2019>setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=domain\myusername Microsoft (R) SQL Server 2019 15.00.2000.05 Copyright (c) 2019 Microsoft. …
SQL Server Database Engine
Unable to Pull Docker Image for SQL Server
docker pull mcr.microsoft.com/mssql/server Using default tag: latest Error response from daemon: failed to resolve reference "mcr.microsoft.com/mssql/server:latest": failed to do request: Head…
SQL Server Database Engine
MDS migration - No data in the mdm view MasterDataServices
Hi , I migrated a model of Master Data Services using MDSModelDeploy.exe createpackage -package "C:\temp\pck.pkg" -model "Product" -service MDS1 -includedata -version VERSION_1 and MDSModelDeploy.exe deploynew -package…
SQL Server Database Engine
PDF Export with a custom font giving the error "Cannont find or create the font 'xyz,Bold'."
I've ran into an issue I have never seen before, maybe somebody could help before I pull my hair out any more. We've got some reports we did for a customer in SSRS. They work fine and render fine. Recently the customer gave us a custom font their…
SQL Server Reporting Services
How to get audit details from sys.fn_get_audit_file, sys.dm_audit_class_type_map and sys.dm_audit_actions ?
Hi, I want to extract audit details by using following dmvs SELECT distinct event_time, succeeded, server_principal_name, database_name, object_name, statement,fng.action_id ,da.name,fng.class_type FROM sys.fn_get_audit_file('C:\Audit*.sqlaudit',…