264 questions
1 answer
sqlcmd to backup on one server and write to another
I have a sql agent job that runs a CmdExec step on server 'Destination'. It executes a full backup on server 'Source' and needs to write the backup to server 'Destination'. This works perfectly when the server names are hard coded. However, both the…
SQL Server | SQL Server Transact-SQL
asked 2026-02-04T23:00:41.0833333+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, 95%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bukkybu
386
Reputation points
answered 2026-02-04T23:00:50.94+00:00
Q&A Assist
3 answers
default password of NT SERVICE/MSSSQLSERVER account
i want default password of NT SERVICE ACCOUNT of MSSQL SERVER
SQL Server | Other
14,658 questions
asked 2021-07-29T09:28:55.323+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(291.2, 2%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
palani sam
1
Reputation point
edited a comment 2026-02-04T22:58:11.9+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, 81%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Shih, Michael
20
Reputation points
1 answer
How can I enforce and manage transparent data encryption on SQL Databases involved in replication and Always On AGs?
1.. How can I easily manage TDE -particularly where Database restores to lower environments and between servers is required frequently? 2.How can I manage TDE on Source and Target databases where transactional replication is currently setup?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
615 questions
asked 2026-02-04T22:53:22.44+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(185.6, 43%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOL%3C/text%3E%3C/svg%3E)
Ogunyemi, Lola
0
Reputation points
answered 2026-02-04T22:53:31.7733333+00:00
Q&A Assist
1 answer
How to upgrade/activate MS SQL 2022 server
Hello Can someone please assist. I recently bought 2 MS SQL 2022 standard Global keys and wanted to activate the SQL 2022 application but every time I try and upgrade, it says that the key is invalid. I installed the SQL 2022-SSEI-Eval but when…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
615 questions
asked 2026-02-04T08:20:52.7933333+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(32, 51%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jason Bothe
0
Reputation points
commented 2026-02-04T21:53:32.3266667+00:00
Erland Sommarskog
132K
Reputation points MVP
Volunteer Moderator
1 answer
Informatica to MS SQL Connections hold locks and block
Informatica to MS SQL Connections hold locks and block
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
615 questions
asked 2026-02-04T10:41:26.6166667+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(160, 40%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Garner, Michael (IT/UK)
0
Reputation points
commented 2026-02-04T21:45:52.9633333+00:00
Erland Sommarskog
132K
Reputation points MVP
Volunteer Moderator
6 answers
SSMS18.6: microsoft.sqlserver.management.iregistrationservice not found
service 'microsoft.sqlserver.management.iregistrationservice' not found (microsoft.sqlserver.management.sdk.sqlstudio) I found the error above when I try to connect database engine with SQL Server Authentication. It shows the error but everything seems…
SQL Server | Other
14,658 questions
asked 2020-09-10T16:23:05.517+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, 47%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
charin
16
Reputation points
edited a comment 2026-02-04T20:54:43.57+00:00
shahab farahani
0
Reputation points
1 answer
Is SQL volume licensing able to downgrade to 2016 version?
Hi team, since SQL 2022 has been EOS, and SQL 2025 is not able downgrade to 2016 version. Can anyone advice if purchase with SQL volume licensing, is that possible to downgrade the version to 2016?
SQL Server | Other
14,658 questions
asked 2026-02-04T09:01:03.4333333+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(96, 79%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chia Sin Chong
0
Reputation points
edited the question 2026-02-04T11:11:53.0133333+00:00
Gérard Oomens
117.6K
Reputation points
Volunteer Moderator
4 answers
One of the answers was accepted by the question author.
Microsoft SQL Management Studio for Mac
Hi, Is there any Mac version for Microsoft SQL Management Studio? Where can I get it from? Thanks, Jassim
SQL Server | Other
14,658 questions
asked 2023-04-27T10:10:32.4133333+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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
answered 2026-02-04T10:39:14.42+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, 26%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Alek Kowalczyk
0
Reputation points
1 answer
SSIS package works in Visual Studio 2022 but not from command line?
I have a snippet of a workload that involves importing data from a CSV file into a MySQL database via ODBC. When I run it within Visual Studio it works just fine but when I run it via DTexec.exe (64-bit) it fails with the following errors: Description:…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,772 questions
asked 2025-08-13T20:37:02.52+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, 74%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
Greg Troyan
0
Reputation points
commented 2026-02-04T09:38:49.1233333+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
875
Reputation points Microsoft External Staff
Moderator
7 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,368 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
25
Reputation points
answered 2026-02-04T08:34:30.7033333+00:00
Christopher Hähnel
21
Reputation points
1 answer
Replication Monitor could not open the Detail Window.
Hi, SQL Server + Alwayson + Replication , when distributor database is on separated instance. when I log into the server with the administrator user, on Replication Monitor, selected a publication and right click in subscription + "view…
SQL Server | Other
14,658 questions
asked 2025-01-16T17:04:28.0766667+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(28.799999999999997, 68%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
Douglas Fernandes
5
Reputation points
edited a comment 2026-02-04T06:52:42.9433333+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(179.20000000000002, 96%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rekha
0
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server 2025 Standard Key not working for Power BI Report Server
I am attempting to convert my evaluation edition of Power BI Report Server to a fully activated. I have read in both of the articles linked below that the exact same key used to activate SQL Server 2025 Standard (17.x) is what you should use to activate…
SQL Server | Other
14,658 questions
asked 2026-01-30T15:38:53.39+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, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kyle Minard
0
Reputation points
commented 2026-02-04T06:47:29.1333333+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(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,155
Reputation points Microsoft External Staff
Moderator
2 answers
SQL server generating different query_id for same query_text_id after mirroring failover
I am facing a strange problem with one of my SQL Server 2017 Clusters. I faced a query regression in the past and forced a known good plan for that query_id in query store. When the planned database failover happens every month for OS patching from HostA…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
615 questions
asked 2026-01-30T13:50:19.4766667+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(134.4, 13%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUD%3C/text%3E%3C/svg%3E)
udhayan d
181
Reputation points
commented 2026-02-04T06:18:30.8933333+00:00
Akhil Gajavelly
1,155
Reputation points Microsoft External Staff
Moderator
3 answers
One of the answers was accepted by the question author.
External Image for PowerBI Report Server
Good day! I am experiencing an issue with my report: the image I added is visible in the design view of Report Builder, but it does not display when I run the report in Power BI Report Server (PBIRS). The external image is stored in an Azure Blob…
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,136 questions
asked 2026-01-26T01:57:07.7033333+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(3.2, 60%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Power Pulse
20
Reputation points
accepted 2026-02-04T03:34:32.4066667+00:00
Power Pulse
20
Reputation points
2 answers
DBF Table named Order in VFP
DBF Table named Order in VFP i think you can't have a tlb named order can anyone help with this problem. Update ORDER ; SET ORDER.GROUP = 'Apples' ; WHERE ORDER.GROUP == 'Apple'
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
615 questions
asked 2026-02-03T00:46:31.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(224.00000000000003, 12%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPW%3C/text%3E%3C/svg%3E)
Paul Waldner
0
Reputation points
answered 2026-02-03T22:24:04.14+00:00
Erland Sommarskog
132K
Reputation points MVP
Volunteer Moderator
1 answer
reserved keywords field name in VFP
Update _ORDER; SET group = 'Apples' ; WHERE group = 'Apple' Moderator: Moved from SQL Server | Other
SQL Server | Other
14,658 questions
asked 2026-02-03T02:48:40.0933333+00:00
Paul Waldner
0
Reputation points
edited the question 2026-02-03T22:17:58.2533333+00:00
Erland Sommarskog
132K
Reputation points MVP
Volunteer Moderator
3 answers
Message=A severe error occurred on the current command. The results, if any, should be discarded.
Hi, There is an Failure in my Azure Datafacttory for a particular table with the below error message. Failure happened on 'Source' side.…
SQL Server | Other
14,658 questions
asked 2026-02-03T06:06:13.4133333+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(246.4, 91%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sudhakar Paraniselvan
0
Reputation points
answered 2026-02-03T22:15:54.5+00:00
Erland Sommarskog
132K
Reputation points MVP
Volunteer Moderator
1 answer
sql server management system studio 20 crashes everytime i try to save a quers using ctrl +s or save as
I've had this issue for a couple of days now and i tried deleting the shell folder and uninstalling ssms but it doesn't seem to work, maybe there are folders that haven't been deleted when i uninstalled it? but it's driving me mad not to know how to fix…
SQL Server | Other
14,658 questions
asked 2026-02-01T16:19:09.2+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, 64%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENO%3C/text%3E%3C/svg%3E)
Nada Osama
30
Reputation points
commented 2026-02-03T21:38:03.53+00:00
Erland Sommarskog
132K
Reputation points MVP
Volunteer Moderator
1 answer
SQL Server 2025 LocalDb installation is missing components
According to https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2025 - "SQL Server Express LocalDB is a lightweight version of Express edition that has all its programmability features" Therefore I would…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
615 questions
asked 2025-12-09T15:15:18.17+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(236.8, 60%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Duncan Smart
0
Reputation points
commented 2026-02-03T21:35:22.2533333+00:00
Erland Sommarskog
132K
Reputation points MVP
Volunteer Moderator
3 answers
How do I fix an SQL Server issue
I recently transferred from one computer to another and forgot that one of the programs needed installed from scratch or it caused issues and would not open the program even after re-installation. The issue I am having involves SQL server. Windows cannot…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
615 questions
asked 2026-01-11T19:35:52.46+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(176, 37%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
Kevin Johnson
0
Reputation points
edited an answer 2026-02-03T11:44:19.85+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(80, 36%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Carl Walker
0
Reputation points