258 questions
1 answer
Can I retrieve my MCDBA certificate I received in 2006 on my current profile?
I have lost my MCDBA certificate and would like to retrieve it
SQL Server | SQL Server Transact-SQL
asked 2026-01-06T03:02:02.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(179.20000000000002, 30%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELQ%3C/text%3E%3C/svg%3E)
LONG QUOC DU
0
Reputation points
answered 2026-01-06T03:02:08.82+00:00
Q&A Assist
2 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,763 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
edited an answer 2026-01-06T02:10:42.9566667+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, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
27,091
Reputation points
2 answers
Failed to create backup file in SQL Server
Hello, I'm having trouble with SQL Server backups and have a question. I translated this from Japanese, so the wording might be a bit awkward. [Environment] SQL Server 2019 running on a Hyper-V virtual environment on Windows Server 2016 [Issue] During…
SQL Server | SQL Server Transact-SQL
258 questions
![](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(268.8, 18%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
How do I change the font size in the 'Connect to Server' dialog box?
My 'Connect to Server' dialog box is almost unreadable due to small font size. While it's straight forward to change fonts elsewhere in SSMS through Tools->Options->Environment->Fonts and Colors, there doesn't seem to be a way to change the…
SQL Server | Other
14,631 questions
asked 2026-01-05T15:56:39.62+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, 43%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Vaughn, Daniel R
0
Reputation points
answered 2026-01-05T20:27:38.47+00:00
Erland Sommarskog
130.5K
Reputation points MVP
Volunteer Moderator
2 answers
SQL Server Express 2025 installation issue on hp omnibook 7
I have got new HP Omnibook 7 flip ultra 7. I am trying to install sql server express 2025 but every time it failed. The exit code is -2061893606 (Error description: Wait on the Database engine recovery handle. Check sql server error log for potential…
SQL Server Database Engine
562 questions
asked 2025-12-16T00:07:22.9033333+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, 79%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Amanullah Dar
0
Reputation points
commented 2026-01-05T20:07:48.13+00:00
Erland Sommarskog
130.5K
Reputation points MVP
Volunteer Moderator
3 answers
Cannot transfer my Access tables using the new SSMA 10.4 version
I would like to get SSMA 10.3 (Access → SQL Server edition) since I cannot use the current version which gives me the "Error Bad parameters for connection” regression in 10.4." I am running SQL Server Express, SSMA and VStudio 2022 Express so I…
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.
590 questions
asked 2025-12-27T19:33:44.8766667+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(249.60000000000002, 23%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
James Johnson
5
Reputation points
commented 2026-01-05T20:03:46.7333333+00:00
Erland Sommarskog
130.5K
Reputation points MVP
Volunteer Moderator
3 answers
Sql Server License
Hi, Can I use the Pay-as-you-go pricing model for a SQL server on a local virtual machine? Or does it need its own dedicated machine? Thank you
SQL Server | Other
14,631 questions
asked 2025-12-01T16:34:41.38+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(208, 41%, 30%)' 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 Malvey
0
Reputation points
edited an answer 2026-01-05T19:37:23.8566667+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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
82,311
Reputation points
Volunteer Moderator
4 answers
One of the answers was accepted by the question author.
SSRS Going Away?
I was informed by my IT department that the next upgrade they are making to upgrade our SQL server will not be supporting SSRS. I couldn't find any information to back-up their claim from Microsoft's website, other than that in SQL Server 2022,…
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
SQL Server | Other
14,631 questions
asked 2024-04-19T19:31:42.4666667+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(217.60000000000002, 18%, 31%)' 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)
Colin Sachs
40
Reputation points
answered 2026-01-05T12:34:30.5433333+00:00
Greg Low
2,005
Reputation points Microsoft Regional Director
2 answers
Missing Client Protocols in SQL Server Configuration Manager
I installed SQL Server 2025, but when I try to enable TCP/IP from SQL Server Configuration Manager, the Client Protocols field is empty. I've tried everything: uninstalling, reinstalling, checking ports, using snap-ins—I'm at a loss. I have the correct…
SQL Server Database Engine
562 questions
asked 2025-12-03T23:41:08.02+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(70.4, 10%, 16%)' 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)
Serrato, Mario
0
Reputation points
commented 2026-01-05T10:25:46.6533333+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,110
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
SQL Service not started even SQL installed successfully
Issue Summary for HP Support – SQL Server Stack Overflow on HP EliteBook 👤 User: Laptop: HP EliteBook 640 G11 Notebook PC OS: Windows 10 Enterprise x64, Build 26100 System: Physical machine, no virtualization Memory: 16 GB RAM Disk: Sufficient…
SQL Server Database Engine
562 questions
asked 2025-07-25T04:16:26.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(185.6, 84%, 27%)' 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)
Senthil Murugan
20
Reputation points
commented 2026-01-05T10:22:10.06+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(294.40000000000003, 83%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Marc Roussel
41
Reputation points
2 answers
SQL 2019 AlwaysOn instance - TempDB files out of balance
Hello. I have a 3-node SQL 2019 AlwaysOn cluster which host multiple instance. One instance on primary node has TempDB files wildly out of balance. There are 8 files. TempDev = 14,285 MB. Temp2 - Temp8 = 8 MB each. On the secondary nodes, TempDB…
SQL Server Database Engine
562 questions
asked 2025-12-06T17:45:17.5333333+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
commented 2026-01-05T09:38:17.8766667+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
1 answer
Can SQL Server 2022 Standard License Be Downgraded to SQL Server 2016 Standard?
Hello, We have purchased SQL Server 2022 Standard through an authorized distributor. Our current environment is running SQL Server 2016 Express, and we need to upgrade this instance from Express to Standard edition. Since the SQL Server 2022 Standard…
SQL Server | Other
14,631 questions
asked 2025-12-09T09:09:29.9466667+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(92.8, 0%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
JINA SIM
0
Reputation points
commented 2026-01-05T09:17:59.38+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
2 answers
SSRS 2022 is working on https but not on http (503)
Hi Team, I have ssrs installed on standalone aws instance, i have https working for /Reports and /ReportServer both but http doesnt work, it starts working but then it stops i didnt change anything. EC2 instance is a standalone server with no…
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
![](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, 30%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
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
562 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
answered 2026-01-05T09:11:46.87+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
2 answers
Microsoft SQL Server 2025 availability on CSP
When will Microsoft SQL Server 2025 be available on CSP and does it come with PBIRS Functionalities and Software Assurance
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,763 questions
asked 2025-12-09T16:01:41.5366667+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, 7.000000000000001%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nurudeen Adeboye
21
Reputation points
edited a comment 2026-01-05T08:50:13.8133333+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
2 answers
Is there any better disaster recovery than Transactional Replication?
I am trying to implement Transactional replication on SQL Server 2016 from Prod server to Report server. But it is not carried lot of tables that doesn't have Primary keys and those tables are important too. Is there different disaster recovery tools…
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-10T19:28:35.8233333+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(83.2, 72%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jinal Contractor
121
Reputation points
edited a comment 2026-01-05T08:31:27.8566667+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
3 answers
Choosing Between SQL Server/SSIS 2022 and 2026 — Which Version Is More Stable for Enterprise Use?
Hello, We are a DWH team running our ETL processes using SSIS packages. Our ETL packages are executed on SQL Server via SQL Server Agent jobs, and all ETL development is done in Visual Studio. Our current environment consists of: Windows Server 2019 …
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,763 questions
asked 2025-12-23T21:31:26.1866667+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(310.4, 97%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOB%3C/text%3E%3C/svg%3E)
Oktay Bozdemir
41
Reputation points
commented 2026-01-05T07:54:34.35+00:00
Oktay Bozdemir
41
Reputation points
1 answer
Link https://go.microsoft.com/fwlink/?linkid=2216019 changed installer?
Hi, For years whe have used a script to download and install SQL 2022 EXPRESS. The link we used to download the SQL 2022 installer is https://go.microsoft.com/fwlink/?linkid=2216019 But recently the link suddenly points to a SQL 2025 Express…
SQL Server | Other
14,631 questions
asked 2025-12-12T12:56:07.7066667+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(259.20000000000005, 84%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jens Schumacher
0
Reputation points
commented 2026-01-05T07:31:07.1766667+00:00
Jens Schumacher
0
Reputation points
1 answer
Ag listener fail to offline in 2 node always on without AD
Let me describe my env first: Two nodes always on without domain (with witness share file) Both node is sql server 2022 and windows server 2022 Both nodes are in the same subnet Set DNS server for these two nodes Didn’t register A record in DNS …
SQL Server Database Engine
562 questions
asked 2025-12-13T12:33:30.07+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(259.20000000000005, 7.000000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKY%3C/text%3E%3C/svg%3E)
Kelvin Yu
0
Reputation points
commented 2026-01-05T06:27:09.2133333+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
2 answers
Can we downgrade MS SQL SERVER 2022 STD to MS SQL SERVER 2012 R2 STD?
If I purchase a license for SQL Server 2022 Standard Edition but need to downgrade to SQL Server 2012 Standard Edition because my current application only supports the 2012 version, what steps should I take? Specifically, could you please advise on where…
SQL Server | Other
14,631 questions
asked 2025-12-15T07:36:48.44+00:00
Wuttinun Phusawang
0
Reputation points
commented 2026-01-05T06:19:58.94+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator