21,598 questions with SQL Server-related tags

Sort by: Updated
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
2 answers

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
answered 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
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-27T22:16:29.9166667+00:00
Mantini, Ronald M 6 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
1 answer

Oracle source and destination missing in visual studio 2022 after installing Microsoft Connector for Oracle v1.2/1.3

We are running SSIS packages originally developed for SQL Server 2016 on servers that have been upgraded to SQL Server 2022 (both OS and database engine). The packages use the Attunity Oracle connectors. After the upgrade we attempted to open the…

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-20T20:13:59.91+00:00
vamsi krishna 0 Reputation points
commented 2026-05-27T06:46:07.35+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
2 answers

What is SQL error ID 8179 and how to fix it?

The customer often found NAV Server error at Event Viewer (Application log), Event ID 216, MicrosoftDynamicsNavServer$MBKNAV.  It was NavSqlException, SQL error ID 8179 (“Could not find prepared statement with handle …”).  This issue often occurs when…

SQL Server | SQL Server Transact-SQL
asked 2026-02-18T02:58:30.2366667+00:00
Chirayu Traihirun 0 Reputation points
commented 2026-05-27T06:05:30.05+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
1 answer

sql server migration assistance oracle - accidently select always "words" while creating report. Need a report in HTML

accidently select always "words" while creating report. I need to create report in HTML How to reset this feature

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.

606 questions
asked 2026-05-02T17:40:15.46+00:00
Hussain, Baqir 0 Reputation points
commented 2026-05-27T05:34:18.0466667+00:00
Lakshmi Narayana Garikapati 1,315 Reputation points Microsoft External Staff Moderator
1 answer

SQL Server Cluster Sync Issue After Windows Patch KB5091157

I have an issue related to patching Windows Server 2025. After installing patch KB5091157, our Microsoft SQL Server cluster cannot sync. Details: What happened: The SQL cluster worked fine before the patch. After patching, the cluster will not sync. …

SQL Server Database Engine
asked 2026-05-22T02:04:04.07+00:00
ITD-Sreng Channy 0 Reputation points
commented 2026-05-27T05:28:21.2366667+00:00
Lakshmi Narayana Garikapati 1,315 Reputation points Microsoft External Staff Moderator
1 answer

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,161 questions
asked 2025-06-26T05:23:56.6233333+00:00
SAi 10 Reputation points
commented 2026-05-27T05:16:24.9933333+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
1 answer

SQL DB not Found

Hi, I have created SQL Server with multiple SQL Database in it, but when I try to click the Database in the Azure Portal, it says Resource Not Found, I can connect to the same database in the SQL Server Management Studio, I have also tried getting the…

SQL Server Database Engine
asked 2025-04-28T08:46:47.8233333+00:00
Shabir jan 21 Reputation points
commented 2026-05-27T05:06:40.04+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator