548 questions
1 answer
How to fix this error with rxInstallPackages
I have installed the Machine Learning services on Microsoft SQL Server 2022 (RTM-GDR) (KB5068407) - 16.0.1160.1 (X64) Oct 3 2025 18:06:58 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build…
SQL Server Database Engine
asked 2025-12-16T09:18:18.59+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 42%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Stephen Hayes
0
Reputation points
commented 2025-12-19T22:44:50.6133333+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
1 answer
SQL Server 2025 Installation Error
SQL Server 2025 Enterprise Developer Edition Oops... Unable to install SQL Server (setup.exe). Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.
SQL Server Database Engine
548 questions
asked 2025-12-19T13:15:23.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 63%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVT%3C/text%3E%3C/svg%3E)
Vijoy T Abraham
0
Reputation points
commented 2025-12-19T21:55:07.6333333+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
2 answers
SQL server 2022 remote query timeout
Scenario: HP DL 380 G11 Server Windows Server 2025 Std DC SQL 2022 Std Workstations integrated into the domain with Windows 11 Pro. ODBC Version 18. On the workstations, runs an application that works with a database existing in the single SQL…
SQL Server Database Engine
548 questions
asked 2025-12-19T17:07:33.1433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 64%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MadUrantia
65
Reputation points
answered 2025-12-19T21:53:30.6366667+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
0 answers
The SQL Server Management studio no longer shows running SSIS packages
Hi everyone, I run a bunch of SSIS packages in a SQL Server Agent job. The packages are deployed as files in the file system. They are executed as SQL Server Agent Service Account. I used to be able to see them under Running Packages. Today, they weren't…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,760 questions
asked 2025-12-19T21:51:23.88+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 92%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIG%3C/text%3E%3C/svg%3E)
Igor Gelin
0
Reputation points
asked 2025-12-19T21:51:23.88+00:00
Igor Gelin
0
Reputation points
2 answers
DBCC CHECKDB on Secondary Replica
I have an AlwaysOn AG. The secondary replica is set as readable. But, when i run DBCC CHECKDB on secondary replica, it is throwing below error: DBCC CHECK cannot proceed on database because it is a secondary replica and snapshot creation failed.…
SQL Server Database Engine
548 questions
asked 2025-12-18T12:47:25.15+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
821
Reputation points
commented 2025-12-19T21:44:56.1966667+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
2 answers
My SQL Server Services getting stopped automatically
Dear Community, As I have experienced that one of my client system SQL services getting stopped automatically. After rebooting the windows that service not getting started, I have to start the SQL server services manually. Can you guys please suggest me…
SQL Server | Other
14,627 questions
asked 2025-12-18T09:33:08.6266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 44%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vishal Sharma-IT
0
Reputation points
commented 2025-12-19T21:22:44.3333333+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
11 answers
SQL Server Management Studio 18 remember password not working?
With one of the latest updates of SSMS 18 (I'm now on 18.6), the remember password feature does not seem to work anymore. Am I missing something? Cheers, Galletto
SQL Server | Other
14,627 questions
asked 2020-09-22T14:20:52.377+00:00
galletto
251
Reputation points
commented 2025-12-19T09:52:51.2133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 6%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Scott Craig
1
Reputation point
5 answers
Unable to connect to SSAS 2025 via SSMS
I have installed SSAS 2025 in MOLAP mode. I installed SQL 2025 Developer Standard. The service is up and running. Port is open. My user is SSAS administrator. Using SSMS 22, 21 and even 20 I get the following error: "Invalid connection…
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,365 questions
asked 2025-11-19T18:25:25.3566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 82%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Chris Mara
5
Reputation points
edited an answer 2025-12-19T07:13:54.54+00:00
Franz Ladurner
0
Reputation points
2 answers
Record deletion order of operations
Hi. I need a reminder of order of operations for the following scenario: I have a database of 605 GB in size. The data file is approx 423 GB with 68% available free space. The tran log file is approx 182 GB with 99% available free space. I need to…
SQL Server Database Engine
548 questions
asked 2025-12-18T03:13:41.3+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 56.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Cooper, David A. [ISS] (Contractor)
111
Reputation points
answered 2025-12-18T22:17:50.94+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
1 answer
Connection pool error I am getting
Error: operation timed out for an unknown reason at /node_modules/tarn/dist/PendingOperation.js:14:27 This is the error I am getting when I login to my applicaiton. In very next attempt I am able to login properly. What could be the possible reason…
SQL Server Database Engine
548 questions
asked 2025-12-18T03:44:01.12+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 27%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Dvebrat Tripathi
0
Reputation points
commented 2025-12-18T22:09:02.8166667+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
0 answers
Connection was denied because Deny Public Network Access is set to Yes.
Hi, Was facing the following issue when connecting to Microsoft Dataflow using SQL server An exception occurred: DataSource.Error: Microsoft SQL: Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was…
SQL Server Database Engine
548 questions
asked 2025-12-18T04:40:33.8733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 20%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Chun Hanssen
135
Reputation points
commented 2025-12-18T22:02:13.5133333+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
1 answer
The login is from an untrusted domain and cannot be used with integrated authentication
Hi, After Windows patches on Dec 10th, all my SQL and Report servers login is failing with the error: "The login is from an untrusted domain and cannot be used with Integrated Authentication". The report server would be able to comunicate with…
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,122 questions
asked 2025-12-18T13:43:13.5833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
Inga Minciuna
0
Reputation points
commented 2025-12-18T21:43:31.72+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
What are some database design best practices or strategies for dealing with instrument time series data from a SCADA system?
I am interested in learning some of the best practices for database design for dealing with the copious amount of data which can come from a SCADA system for lab/research machinery where several instruments could be logged at a high frequency. I have…
SQL Server | Other
14,627 questions
asked 2025-12-15T15:57:43.48+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 85%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
Stephen Young
40
Reputation points
commented 2025-12-18T21:23:01.4133333+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
1 answer
I am unable to save my SSMA for DB2 project. I think the metadata queries have syntax errors.
I am trying to migrate from DB2 running on an IBM i server and migrate to Sql Server 2017 running on Windows 2016. When I try to save my SSMA for DB2 project, I select my Schema and press save. The process begins and I see errors in the output window.…
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.
588 questions
asked 2025-12-18T16:35:28.8166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 1%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGW%3C/text%3E%3C/svg%3E)
Greg Witsken
0
Reputation points
answered 2025-12-18T16:35:39.2333333+00:00
Q&A Assist
1 answer
One of the answers was accepted by the question author.
Windows server 2016 - KB5071543 - MSMQ issue - Insufficient resources to perform operation
The software I support is using MSMQ to insert data in the MSSQL DB. My customer has a Windows server 2016. And the KB5071543 has been installed. and having the known issu Insufficient resources to perform operation”…
SQL Server | Other
14,627 questions
asked 2025-12-18T10:05:20.8933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 94%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Halleguen Kareen
20
Reputation points
accepted 2025-12-18T10:42:01.1133333+00:00
Halleguen Kareen
20
Reputation points
2 answers
Unable to open script task in VS 2019 SSIS
HI Team , I am unable to edit script task in SSIS for Visual studio 2019. I have tried the following steps re-install VS Re-install SSIS extension Repair SSIS extension another recommendation was given to repair Visual studio Tools for…
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.
588 questions
asked 2025-12-15T05:00:15.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 56.00000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kumarjit Chakraborty
0
Reputation points
edited an answer 2025-12-18T09:08:54.4866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 66%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
1 answer
SCOM - Alert Parameter Replacement Failure on monitor in Microsoft SQL Server on Windows (Monitoring) MP
I am seeing Alert Parameter Replacement Failure alerts on the Memory-Optimized Data Stale Checkpoint File Pairs Ratio monitor. This is in the Microsoft SQL Server on Windows (Monitoring) management pack authored by Microsoft. I have disabled the monitor…
SQL Server | Other
14,627 questions
asked 2025-12-17T21:41:34.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 5%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
West, Chelsea A
0
Reputation points
answered 2025-12-18T01:53:58.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 71%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shoga Daini
5
Reputation points
2 answers
One of the answers was accepted by the question author.
Question about "BACKUP Database" statement
This question is very closely related to my previous post, but I am posting here again because this is little bit time sensitive. Currently, I have pipeline completed where I use T-SQL statement as below to create a BAK file daily in Prem SQL: BACKUP…
SQL Server | SQL Server Transact-SQL
256 questions
asked 2025-12-17T21:34:49.2933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Justin Doh
920
Reputation points
commented 2025-12-17T22:40:14.5233333+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
1 answer
Does SQL server retain the setting for IDENTITY_INSERT after a session closes
I have set IDENTITY_INSERT ON for a table, does that setting remain after the session ends?
SQL Server Database Engine
548 questions
asked 2025-12-17T08:48:50.45+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM4%3C/text%3E%3C/svg%3E)
MichaelHorwell-4553
0
Reputation points
commented 2025-12-17T22:17:30.09+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
1 answer
PL-300-Microsoft-Power-BI-Data-Analyst
l am in the lab for the PL-300-Microsoft-Power-BI-Data-Analyst study. l am stuck on step 4, l do not have the okay option, below are the options l have. Please help
SQL Server | Other
14,627 questions
asked 2025-12-17T20:50:40.7766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 1%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFN%3C/text%3E%3C/svg%3E)
Francis Nyasha Mubika
0
Reputation points
answered 2025-12-17T22:12:48.0466667+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator