A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
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
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
Additional SQL Server features and topics not covered by specific categories
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
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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
Programming language used to interact with SQL Server databases
getting below error while installing microsoft sql server 2025
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
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
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
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
Additional SQL Server features and topics not covered by specific categories
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
Additional SQL Server features and topics not covered by specific categories
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
Core component of SQL Server for storing, processing, and securing data
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
Core component of SQL Server for storing, processing, and securing data
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
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
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
Core component of SQL Server for storing, processing, and securing data
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
Additional SQL Server features and topics not covered by specific categories
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
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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
Programming language used to interact with SQL Server databases
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
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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
Core component of SQL Server for storing, processing, and securing data
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
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
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
Core component of SQL Server for storing, processing, and securing data