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
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
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
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
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
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 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
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 | Other
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
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
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
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
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 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
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
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
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
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
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
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