Additional SQL Server features and topics not covered by specific categories
Import and Export Data option greyed out in SSMS 22 with SQL Server 2025 Developer
Hello, I am using SQL Server 2025 (RTM) – 17.0.1000.7 (Enterprise Developer Edition, 64-bit) on Windows 10 Pro. I installed: Database Engine Services (Default instance: MSSQLSERVER) Integration Services (added later via “Add features to existing…
SQL Server | Other
SSRS Permissions Issue: User Unable to View Reports despite Browser Role
Hello, I’m facing an issue with SQL Server Reporting Services (SSRS). I have a user who is assigned to the “Browser” role on the folder, but despite this, the user is unable to view the reports. The user receives the error: Does anyone have…
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.
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
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
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
Core component of SQL Server for storing, processing, and securing data
Report server doesn't support schedule refresh when using SharePoint Online as the data souce
Hi team, According to this page, https://learn.microsoft.com/en-us/power-bi/report-server/data-sources. I noticed the power BI report server doesn't support schedule refresh when connecting to SharePoint Online related as the data source. Would there be…
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.
Help with the Azure SQL DTU Calculator
I am trying to load a CSV file into the DTU Calculator without success. Refer https://dtucalc.azurewebsites.net/ I receive a generic error message: Error! An error occurred while processing your request. See below for the first few lines of the CSV file…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Need original microsoft hecksum value for latest Microsoft Command Line Utilities for SQL Server before downloading
Hi, I need to download the latest version of Microsoft Command Line Utilities x64 for SQL Server for Windows OS. I can see it is available here: https://learn.microsoft.com/en-us/sql/tools/bcp/bcp-download-install?view=sql-server-ver17 Before installing…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Cube failure due to data length issue
Cube failure with below error “Errors in the OLAP storage engine: An error occurred while the 'Diagnosis' attribute of the 'DimUniqueDiagnosis' dimension from the 'CQMC_RBGBGWS_Analysis_Test' database was being processed.” We are doing SL3 to SL4 server…
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.
Problemas persistentes al instalar y desinstalar SQL Server: error en KERNELBASE.dll y bloqueo de sqlservr.exe
Estoy experimentando problemas persistentes al intentar instalar y ejecutar SQL Server en mi PC. El problema continúa incluso después de desinstalar y reinstalar SQL Server y eliminar las carpetas de instalación. Según el análisis realizado por el…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
electronic signature report
Is there a report I can pull electronic signatures by provider in Expanse?
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.
AI answer
Request to speak to a representative about SQL express
I cannot install sql express. Can I speak to a representative?
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Where are the SQL Server developer edition downloads
Where are the developer edition download files for SQL Server 2022, SQL Server 2019, and SQL Server 2017?
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Non-User Account Information
Currently can export the report for one owner only. We need requirement to pull this report for Level6 Org. ?Can we have this feature?
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.
How to avoid refreshing full data everytime on refreshing in on premises PowerBI Dashboards
I work in a finance corporate where there is a lot of data in our on premises PowerBI dashboards from either sql or excel, so on regular basis we face challenges on refreshing all the dashboards as every time it refreshes from the beginning, so I want a…
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.
AI answer
How to Replace %S with Feature Value on Feature String Based on Feature Name and partid?
I work on sql server 2017 i need write select query Replace %S with Feature Value on Column Feature String Based On partid and Feature Name Related . as example partid 1211 have Feature String AC(%S)Boil(%S)Temp(%S) I need to replace %S…
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
New CE ignores statistics for LIKE predicates on varchar columns with UTF-8 collations — fixed 9% guess (partially fixed in CE 170, `%x%` still affected, no backport)
SUMMARY For varchar columns using any UTF-8 collation (collation name ending in _UTF8), the modern cardinality estimator (CE model 120 to 160) never consults the histogram or string statistics for LIKE predicates. Every "LIKE 'prefix%'" and…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
SQL Server connect error with SSL Cert
Hello, I get this error when logging in to an SQL Server instance: ssl provider error 0 an existing connection was forcibly closed by the remote host error 10054 That happened after I added a certificate to that instance. The same certificate works…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Resolve Deadlocks on Transaction Tables
I configured high-traffic transaction tables for our corporate workstation applications and enterprise services. Not only was I not able to maintain normal query performance during peak business hours due to parallel execution deadlocks, I have been…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
I have been purchased Microsoft SQL Server Standard Edition 2025 downgrade Kit. But product license key is showing SQL Server Standard Edition 2019
I do require 2022 Product License Key. There is a mismatch with SQL Server Standard Edition 2025 downgrade kit and Product key license 2019
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
firewall rule preventing user login
I have a sql database "LIMLdb" running on "apgsystems01" sql server running on a virtual machine. I need to be able to have my users log in from different locations. When they try the are assigned a new ip and cannot log in until I…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data