21,598 questions with SQL Server-related tags

Sort by: Updated
4 answers

Cannot add users or groups in report server portal

The problem is that I cannot set the users or groups after adding the custom security.

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,161 questions
asked 2022-07-25T05:39:09.167+00:00
PATRICK WONG ZHEN HONG 1 Reputation point
answered 2026-05-28T15:28:15.2633333+00:00
Avinash G 0 Reputation points
1 answer

Performance Degradation after moving from SQL 2019 to SQL 2025

I am in the processing of upgrading our SQL environment from 2019 to 2025. We are troubleshooting perf issues in our pre prod env right now before upgrading production and I have a fairly simple query that loads 1.6m rows to a temp table and typically…

SQL Server Database Engine
asked 2026-05-07T17:39:23.1566667+00:00
Mantini, Ronald M 6 Reputation points
commented 2026-05-28T15:26:11.38+00:00
Erland Sommarskog 134.3K Reputation points MVP Volunteer Moderator
1 answer

NOT BEING ABLE TO INSTALL SQL SERVER IN MY DEVICE

I can't insatall SQL SERVER 2025 , tried all the version and failed on every please help me !!!

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,743 questions
asked 2026-03-29T11:33:41.1366667+00:00
Arpit Sharma 0 Reputation points
commented 2026-05-28T15:24:58.0833333+00:00
Arpit Sharma 0 Reputation points
3 answers

locking issue in MSSQL

Issue: the holdlock script has locking the multi-thread(10) insert/update We would like to revise the multi-thread script to from (HOLDLOCK) to (UPDLOCK, SERIALIZABLE) Original script: MERGE testtable WITH (HOLDLOCK) AS t USING (SELECT @P0 hjmpTS, @P1…

SQL Server Database Engine
asked 2026-05-20T07:28:48.0066667+00:00
Sam Chung 0 Reputation points
commented 2026-05-28T12:16:00.1333333+00:00
Lakshmi Narayana Garikapati 1,315 Reputation points Microsoft External Staff Moderator
2 answers

We need to retrieve a SQL 2019 key

We purchased SQL 2019 Standard in 2022 from First Technology Group in South Africa (DG7GMGF0FKX90003). We have recently lost our server after a violent storm resulting in a power surge and now need to re-install SQL 2019 on a new server. We contacted…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,743 questions
asked 2026-05-17T11:16:50.7766667+00:00
Charmaine Lindsay 0 Reputation points
commented 2026-05-28T12:14:48.46+00:00
Lakshmi Narayana Garikapati 1,315 Reputation points Microsoft External Staff Moderator
2 answers

Distribution Cleanup Job Failing Silently in SQL Server 2019 Transactional Replication Causing Distribution DB Growth to 1.5 TB

Hello All, We are facing an issue with SQL Server Transactional Replication where the Distribution Cleanup job has been failing silently, and the distribution database has grown to approximately 1.5 TB, causing severe disk space issues. Environment SQL…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,743 questions
asked 2026-05-16T08:14:26.1766667+00:00
Parag Nimbhore 5 Reputation points
commented 2026-05-28T12:13:59.3266667+00:00
Lakshmi Narayana Garikapati 1,315 Reputation points Microsoft External Staff Moderator
1 answer

SQL Server 2022 Express installation error -2061893606 and service error 1067

Hello, I have a problem installing Microsoft SQL Server 2022 Express for EBP Gestion Commerciale ELITE 2025. Errors: Error -2061893606 SQL Server service (EBP) cannot start Error 1067 Shared Memory Provider, error: 40 What I already tried: …

SQL Server Database Engine
asked 2026-05-14T10:18:59.6533333+00:00
Youssef Maach 0 Reputation points
commented 2026-05-28T06:35:30.5+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
1 answer

How to see the daily sales of division 115P in SQL Server Reporting Service?

The PIDV 115P is no longer displayed in SQL Server Reporting Service Link: [http://w1892/Reports_PROD2/report/Demand%20Chain/Shipments_from_Factory_Warehouse] Can you enter it again? Or now where can I see the daily sales of division 115p?

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,161 questions
asked 2026-05-13T18:17:50.9233333+00:00
Leslie Rosario Hernandez 0 Reputation points
commented 2026-05-28T06:34:28.35+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
2 answers

The error was while running the store procedure runs xp_cmdshell to run a batch file

The stored procedure SP_CreateClientDatabase internally uses xp_cmdshell to execute a batch file located at: F:\ECLOUD_DB_Script\CreateDB.bat However, the execution is currently failing with the below error:An error occurred during the execution of…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,743 questions
asked 2026-05-13T05:50:36.9933333+00:00
Jeyamani Sekar 20 Reputation points
commented 2026-05-28T06:33:33.94+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
2 answers

SSIS Package Fails with System.Data.SQLite Could Not Load Error (E_POINTER)

I have deployed an SSIS project using an .ispac file into SSISDB. The project contains Cdata Odoo components and Kingswaysoft toolkit. When I try to execute the package (both from SSISDB and from Visual Studio), it fails with the following…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,792 questions
asked 2026-04-29T06:12:42.41+00:00
Ishika Raiyani 20 Reputation points
commented 2026-05-28T06:18:53.4833333+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
1 answer

BULK INSERT cannot access UNC path, error code 5 (Access is denied) using gMSA unless locally triggered

Running a stored procedure to bulk insert from a UNC path works locally via SSMS and via SQL agent job but if run remotely I receive Operating system error code 5 (access is denied). Please help as this workaround is not suitable for our…

SQL Server | SQL Server Transact-SQL
asked 2026-04-28T02:03:11.9766667+00:00
Michelle 0 Reputation points
commented 2026-05-28T05:35:45.2133333+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
3 answers

getting below error while installing microsoft sql server 2025

SQL Server Database Engine
asked 2026-05-25T16:59:03.3033333+00:00
Manisha Shinde 0 Reputation points
commented 2026-05-28T04:40:59.2966667+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
1 answer

Asset KPI's didnt calculated

Some of the asset KPI's can not be calculated, help me find the problem and solution

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,161 questions
asked 2026-05-28T01:34:07.9833333+00:00
Fakhrudin Ahmad 0 Reputation points
commented 2026-05-28T01:38:08.9233333+00:00
Fakhrudin Ahmad 0 Reputation points
1 answer

Unable to connect anymore to SQL Server..

I used SQL last year for sometime just fine, then recently this month tried getting back to it & suddenly it doesn't work. I might have deleted some files by accident so I uninstalled everything SQL related & installed again. Still not connecting…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,743 questions
asked 2025-01-23T23:05:50.4266667+00:00
Anonymous
answered 2026-05-27T23:16:48.0533333+00:00
Deepesh Dhake 0 Reputation points
1 answer

Create Crystal report error in Programs files folder .

I have a Crystal report which is having a data source from MS SQL server. I am always getting this error when we want to show the report: Unknown Query Engine Error Error in File C:\Users\ADMINI~1\AppData\Local\Temp\Test.rpt: Unknown Query Engine…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,743 questions
asked 2025-02-10T13:13:27.78+00:00
Eduard Kenin 0 Reputation points
answered 2026-05-27T22:30:11.0366667+00:00
Deepesh Dhake 0 Reputation points
3 answers

Microsoft SQL Server 2022 - no TCP/IP connection in client protocols in SQLServer Configuration Manager

Hello, since SQL Server 2022 Standard edition I miss in "SQL Server Configuration Manager" under "client protocols" all protocols e.g. "TCP/IP", to enable client connection to the Database. Also I can not create manually a…

SQL Server Database Engine
asked 2026-05-26T06:58:27.8+00:00
Lackner, Mario 0 Reputation points
commented 2026-05-27T22:11:40.14+00:00
Senthil kumar 395 Reputation points
1 answer

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,161 questions
asked 2025-06-23T17:39:41.2266667+00:00
Gaddam Abhishek Reddy 0 Reputation points
answered 2026-05-27T18:43:14.1433333+00:00
Deepesh Dhake 0 Reputation points
2 answers

Unable install MSSQL ODBC Driver on the PPC64le

Dear Microsoft support, is there in near future planned to develop MSSQL ODBC driver for PPC64le architecture? From accessible documentation is not available/supported from your side at this moment. Thank you for response. Br, Erik

SQL Server Database Engine
asked 2026-05-27T10:13:52.5833333+00:00
Erik Tkac 0 Reputation points
answered 2026-05-27T15:31:20.5566667+00:00
Bruce (SqlWork.com) 84,061 Reputation points
1 answer

Migration feature on SSMS 22

Hi Expert, I'm running first time Migrate SQL Server feature on SSMS 22 for Database Assessment with 10TB size, this report as below: "Status": "Error", "**AssessmentRecommendations": [],** "Name":…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,743 questions
asked 2026-05-25T02:27:55.1566667+00:00
Urbel 605 Reputation points
commented 2026-05-27T07:15:27.3333333+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
1 answer

The SQL server 2019 installation failed in Windows Server 2025.

The SQL server 2019 installation failed in Windows Server 2025. From the logs, we understood that, installation fails because Microsoft Visual Studio Tools for Applications (VSTA) 2017 - a dependency of the Integration Services (SSIS) feature - crashes…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,792 questions
asked 2026-04-22T07:15:56.7+00:00
Siji, Merlin 0 Reputation points
commented 2026-05-27T06:48:57.7266667+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator