251 questions with SQL Server-related tags

Sort by: Updated
0 answers

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
asked 2025-06-26T05:23:56.6233333+00:00
SAi 0 Reputation points
0 answers

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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-06-24T01:07:50.8+00:00
Toan Nguyenngoc 0 Reputation points
0 answers

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
asked 2025-06-23T17:39:41.2266667+00:00
Gaddam Abhishek Reddy 0 Reputation points
0 answers

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
asked 2025-06-19T03:39:02.9066667+00:00
Jessica - 568Win 0 Reputation points
0 answers

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 Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
asked 2025-06-17T11:07:16.47+00:00
Kevin Seerup 0 Reputation points
0 answers

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
asked 2025-06-13T14:17:10.49+00:00
Matthew Tanner 0 Reputation points
0 answers

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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-06-06T16:02:21.78+00:00
Karthik Ponugoti 0 Reputation points
0 answers

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
asked 2025-06-05T07:13:31.92+00:00
Omkar Raikar 0 Reputation points
0 answers

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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
asked 2025-06-03T14:12:59.0933333+00:00
Acid Aquamarine 0 Reputation points
edited the question 2025-06-03T14:14:09.07+00:00
Acid Aquamarine 0 Reputation points
0 answers

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 Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-06-02T15:38:53.3733333+00:00
Apostolu, Chris 0 Reputation points
0 answers

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
asked 2025-05-28T22:14:31.2133333+00:00
Michael Fuller 0 Reputation points
0 answers

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
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
asked 2025-05-15T13:41:37.1833333+00:00
Straughn, Wayne 0 Reputation points
0 answers

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
asked 2025-05-07T12:34:09.6366667+00:00
Shane P. Watson 0 Reputation points
0 answers

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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-05-07T09:46:27.6+00:00
azure aajith 0 Reputation points
0 answers

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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
asked 2025-05-06T14:32:32.11+00:00
Ali kayra Zorlu 0 Reputation points
0 answers

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
asked 2025-03-05T23:49:04.68+00:00
bestrongself 1 Reputation point
edited the question 2025-05-06T10:57:27.1966667+00:00
VarunTha 14,850 Reputation points Microsoft External Staff Moderator
0 answers

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
asked 2025-05-05T02:53:11.8933333+00:00
Vinod Kumar Nerella 0 Reputation points
0 answers

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
asked 2025-05-01T09:43:27.76+00:00
Maneesh Murali 0 Reputation points
edited the question 2025-05-01T10:15:07.23+00:00
simo-k 10,415 Reputation points Volunteer Moderator
0 answers

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
asked 2025-04-30T21:12:59.78+00:00
Ryan Brothers 0 Reputation points
0 answers

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',…

SQL Server Database Engine
asked 2025-04-30T10:31:00.4933333+00:00
Yasir Anis Janjua 0 Reputation points