21,834 questions with SQL Server-related tags

Sort by: Updated
3 answers

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
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,826 questions
asked 2026-02-22T20:30:09.4333333+00:00
Sabyasachi Paul 0 Reputation points
commented 2026-10-20T13:37:39.8866667+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
1 answer

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
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,188 questions
asked 2025-04-28T08:26:50.4333333+00:00
Swa1209 90 Reputation points
answered 2026-10-20T04:45:01.19+00:00
Rukshan edirisinghe 2,045 Reputation points
1 answer

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,188 questions
asked 2025-04-30T21:12:59.78+00:00
Ryan Brothers 0 Reputation points
answered 2026-10-20T04:42:54.9066667+00:00
Rukshan edirisinghe 2,045 Reputation points
1 answer

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
answered 2026-10-20T04:41:17.67+00:00
Rukshan edirisinghe 2,045 Reputation points
1 answer

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
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,188 questions
asked 2026-09-17T01:36:22.14+00:00
Yang Zhao 0 Reputation points
answered 2026-10-20T04:39:34.0433333+00:00
Rukshan edirisinghe 2,045 Reputation points
1 answer

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
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,826 questions
asked 2026-09-17T23:24:19.2066667+00:00
Alan Macdonald 0 Reputation points
answered 2026-10-20T04:38:11.76+00:00
Rukshan edirisinghe 2,045 Reputation points
1 answer

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
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,826 questions
asked 2026-09-22T12:47:14.6166667+00:00
GVC 10 Reputation points
answered 2026-10-20T04:36:41.02+00:00
Rukshan edirisinghe 2,045 Reputation points
1 answer

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
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,380 questions
asked 2026-09-24T10:17:43.5566667+00:00
Kayal 0 Reputation points
answered 2026-10-20T04:34:57.0766667+00:00
Rukshan edirisinghe 2,045 Reputation points
1 answer

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
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,826 questions
asked 2026-10-19T20:58:44.25+00:00
Mauro Mariño 0 Reputation points
commented 2026-10-19T21:18:14.9633333+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
1 answer

electronic signature report

Is there a report I can pull electronic signatures by provider in Expanse?

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,188 questions
asked 2026-10-19T18:44:03.38+00:00
Block Alyssa 0 Reputation points
answered 2026-10-19T18:46:01.86+00:00

AI answer

2 answers

Request to speak to a representative about SQL express

I cannot install sql express. Can I speak to a representative?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,826 questions
asked 2026-10-19T14:09:13.83+00:00
miriam litwin 0 Reputation points
edited an answer 2026-10-19T17:04:23.55+00:00
Bruce (SqlWork.com) 85,621 Reputation points
7 answers One of the answers was accepted by the question author.

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
asked 2026-03-24T22:21:49.96+00:00
Steve Margolis 35 Reputation points
answered 2026-10-19T15:24:38.8833333+00:00
Reich, Christian 0 Reputation points
2 answers

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
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,188 questions
asked 2026-10-19T13:24:31.3566667+00:00
Nitin Jain 0 Reputation points
answered 2026-10-19T14:21:52.2133333+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
1 answer

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
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,380 questions
asked 2026-10-19T11:28:50.89+00:00
Syed Uzair 0 Reputation points
answered 2026-10-19T11:30:58.0933333+00:00

AI answer

1 answer One of the answers was accepted by the question author.

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
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,717 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,826 questions
asked 2022-06-09T17:50:14.997+00:00
ahmed salah 3,216 Reputation points
commented 2026-10-17T23:15:32.8+00:00
jenari millender 0 Reputation points
1 answer One of the answers was accepted by the question author.

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
asked 2026-08-21T14:07:13.2433333+00:00
Hubert 20 Reputation points
commented 2026-10-17T20:34:38.23+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
1 answer

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
asked 2026-10-14T13:28:50.75+00:00
David Spenner 5 Reputation points
recommended 2026-10-17T10:42:50.32+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
3 answers

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
asked 2026-10-13T16:34:07.7866667+00:00
Freya Davies 5 Reputation points
commented 2026-10-16T15:52:30.89+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

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
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

610 questions
asked 2026-10-16T13:04:16.5066667+00:00
Naveen C 20 Reputation points
commented 2026-10-16T15:27:19.02+00:00
Bruce (SqlWork.com) 85,621 Reputation points
2 answers

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
asked 2026-09-30T16:28:53.53+00:00
orville wright 0 Reputation points
edited an answer 2026-10-16T07:45:30.5366667+00:00
Ana Mihaila (BLUEHAWK LLC) 0 Reputation points Microsoft External Staff Moderator