How to download Sql Server Configuration Manager
Hello, BRAND NEW to SQL Server. I was following along with a tutorial and downloaded the SSMS, however, doesn't seem like i have the configuration manager installed properly. I tried entering the credentials first prompted once SSMS was done…
SQL Server Reporting Services
SQL Server | Other
Replication ISSUE - how to prevent error MSSQL_REPL-2147199363. after it happens, recreate publish and configure all suscriptors is necessary.
HI ALL, help please. currently we have our main database and many subscriptors, when some of the subscriptors are offline form some days (maintenance or politics company pourposes doesnt matter), and getting online again, we are facing some issues…
SQL Server | Other
SQL Server saved remote password on linked server randomly becomes invalid
I have a 2019 SQL Server with a single instance on it. It has a linked server that tests out and works fine. However, the stored remote password randomly (daily to every few days) becomes invalid, and I have to reenter the password to get it to work…
SQL Server | Other

Getting this error: Msg 3609, Level 16, State 1, Line 88 The transaction ended in the trigger. The batch has been aborted.
So I'm trying an exercise Trigger Code that would send an email if someone tries to insert into the adventure database a special offer that is equal to or greater than 80%, My Code goes Like this: ----------------------- The…
Developer technologies | Transact-SQL
SQL Server | Other
Export Query Results as CSV WITH Headers
I just need to get my query results out to a CSV file WITH Headers quickly (without going through the whole SSIS process for a one-off job). I thought the option below would do the trick, but I get a CSV WITHOUT Headers. Advice?
SQL Server | Other
Do Microsoft CSP Annual and Triennial licenses include Software Assurance (SA)?
Do Microsoft CSP Annual and Triennial licenses include Software Assurance (SA)?
SQL Server | Other
Questions regarding Microsoft SQL Server and Azure Database Certifications differences and expiration
I have a few questions regarding Microsoft certifications, particularly those related to SQL Server and Azure Database administration: I understand that Microsoft periodically retires certain certifications and exams. Could you clarify what type of…
SQL Server | Other
Transfer SQL server license
Hi, I have installed SQL 2022 (elv vesrion) on a new server. I'm planning to decommission the old server. Before I do that, I need to transfer the license. So, SQL 2019 to SQL 20220 STD What is the best way I can have this done? Thanks in…
Windows for business | Windows Client for IT Pros | Devices and deployment | Licensing and activation
SQL Server | Other
SQL Server 2022 Express – “Wait on the Database Engine recovery handle failed” Even After Clean Install
Hi everyone,I'm trying to install SQL Server 2022 Express (16.0.1000.6) on my Windows machine and keep running into the same fatal error, even after multiple clean install attempts: TITLE: Microsoft SQL Server 2022 Setup The following error has…
SQL Server | Other
How to setup Azure Automation account to restore database on SQL MI ?
Hello, I have a PowerShell script (see below) that I currently run daily from a task scheduler on a VM to restore a production database (SQL Managed Instance) to a secondary instance (SQL Managed Instance). I am planning to move this process to an Azure…
Azure Automation
Windows for business | Windows Server | User experience | PowerShell
SQL Server | Other

Database Migration Assistant Related Queries
Hi There! Could you please help with below queries. Database Migration Assistant for assessment. Does it require internet connectivity on server to run the assessment effectively? I can see in 'Assessment Type' options are 'Database Engine' and…
SQL Server | Other
Many SQL 823, 824 and 3041 errors since VM migrations
Our server team migrated our SQL Server VMs (VMware) from: HPE hosts using fibre channel through brocade fabric to our Pure FlashArray to: Cisco hosts connected directly to the same Pure FlashArray, but now using iSCSI. Ever since the VM…
SQL Server | Other
SkipErrors not working in peer-to-peer replication
I have a three node peer to peer replication and have configured the distribution agent with the profile continue on consistency errors -SkipErrors 2601:2627. I get Command attempted: if @@trancount > 0 rollback tran (Transaction sequence number:…
SQL Server | Other
SQL Server 2022 Developer Edition failing install with error code -2068052310
I'm trying to install SQL Server 2022 Developer Edition and am getting an error stating that an installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found and giving me the exit code -2068052310. I've downloaded and…
SQL Server | Other
BACKUP LOG Write Fail to Azure Storage
Hello, We have a SQL VM running out of Azure with SQL Agent jobs running BACKUP LOG every x hours to Azure Blob. These jobs have been running fine for a long time until recently. We keep getting the below error and these jobs fail intermittently for…
SQL Server on Azure Virtual Machines
Azure Storage
Developer technologies | Transact-SQL
SQL Server | Other
Finding old SQL Server licenses we own
Hello, We purchased Microsoft SQL Server many years ago. This sever was decommissioned, but the license was never removed. We would like to reinstall the license on a new server, but have no record of this license number. How can we go about finding…
SQL Server | Other

Unable to install SQL Server. Exit code (Decimal): -2061893607
I get a very kindly worded error message when attempting to install SQL Server 2022, Express Edition. It states, "Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893607 Error description: Could not find the Database Engine…
SQL Server | Other
When will SQL Server Management Studio (21) support ARM64-based PCs?
I have the MS Surface ARM64-based PC with a Snapdragon CPU and need to know when there will be a release of Microsoft SQL Server Management Studio 21 or later that supports this architecture. This is the management studio and not the SQL Server.
SQL Server | Other
how to fix error import an external component threw an exception
Hi, first sorry for my english i use windows 10 and i install sql sever 2022 and sql server 18.12.1 but i have a problem to import data because a message apear "an external component threw an exception"
SQL Server | Other

Connection.close hangs for 10 minutes after executing backup procedure (ODBC Driver, MSSQL Server 2022)
I'm working on some python code to execute Ola Hallengren's Backup procedure from a Linux server. I've gotten it to work, however when calling connection.close() at the end of the script, it hangs for 10 minutes before completing. I've seen a bugfix in a…