14,503 questions with SQL Server | Other tags

Sort by: Updated
6 answers

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 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,066 questions
SQL Server | Other
asked 2022-09-25T07:02:10.793+00:00
Zach Hadjah 26 Reputation points
commented 2025-07-10T09:38:56.26+00:00
Fábio Nobre 0 Reputation points
1 answer One of the answers was accepted by the question author.

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
asked 2023-04-19T21:14:32.78+00:00
Oscar Carrillo Razón 20 Reputation points
accepted 2025-07-10T03:09:02.8433333+00:00
Oscar Carrillo Razón 20 Reputation points
1 answer

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
asked 2025-07-09T13:38:31.0166667+00:00
bukkybu 366 Reputation points
answered 2025-07-09T21:57:09.96+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

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
asked 2021-12-11T12:01:56.03+00:00
salma dodin 96 Reputation points
commented 2025-07-09T16:47:40.3333333+00:00
Niarchos Ioannis 0 Reputation points
3 answers One of the answers was accepted by the question author.

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
asked 2023-03-28T21:32:41.3666667+00:00
Dom 941 Reputation points
commented 2025-07-09T16:00:10.55+00:00
Doug Anderson 0 Reputation points
2 answers

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
asked 2025-07-04T03:06:34.8+00:00
Kannika_W Warunyaporn 0 Reputation points
answered 2025-07-09T15:22:01.4533333+00:00
Bruce (SqlWork.com) 78,161 Reputation points Volunteer Moderator
0 answers

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
asked 2025-07-09T12:00:36.5+00:00
Kamilia Fominova | Noewe Legal 0 Reputation points
4 answers

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
asked 2024-04-22T04:26:53.8533333+00:00
Alvish Chand 0 Reputation points
edited an answer 2025-07-08T15:13:34.32+00:00
Bruce (SqlWork.com) 78,161 Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

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
asked 2025-07-07T06:47:55.37+00:00
Yusuf Bedri Bitiren 20 Reputation points
commented 2025-07-07T08:23:29.1066667+00:00
Yusuf Bedri Bitiren 20 Reputation points
1 answer

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
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,369 questions
Windows for business | Windows Server | User experience | PowerShell
SQL Server | Other
asked 2024-07-23T20:11:08.8833333+00:00
Anoop Noel Nakkala 0 Reputation points
answered 2025-07-06T21:20:44.43+00:00
Amira Bedhiafi 34,336 Reputation points Volunteer Moderator
2 answers One of the answers was accepted by the question author.

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
asked 2025-07-06T06:11:54.2533333+00:00
Chirag Sachdeva 301 Reputation points
commented 2025-07-06T11:59:37.9966667+00:00
Chirag Sachdeva 301 Reputation points
1 answer

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
asked 2022-05-31T16:57:01.86+00:00
Mike Liening 6 Reputation points
edited a comment 2025-07-04T06:00:28.8+00:00
Biswajit Sinha 0 Reputation points
1 answer

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
asked 2025-07-02T18:56:58.1766667+00:00
Peter Ericsson 0 Reputation points
commented 2025-07-03T08:20:44.9833333+00:00
Peter Ericsson 0 Reputation points
3 answers

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
asked 2023-11-12T03:58:22.8866667+00:00
Angel Van de Feniks 11 Reputation points
answered 2025-07-02T21:23:48.5233333+00:00
Darren 1 Reputation point
2 answers

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
Azure Storage
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,542 questions
Developer technologies | Transact-SQL
SQL Server | Other
asked 2022-06-13T18:07:29.267+00:00
sidney l 21 Reputation points
answered 2025-07-02T21:20:53.65+00:00
Andy Soushek 0 Reputation points
2 answers

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
asked 2025-07-01T16:26:08.7866667+00:00
Ken Wanek 0 Reputation points
commented 2025-07-02T21:12:35.49+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

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
asked 2025-07-02T02:04:10.06+00:00
Mike Banes 20 Reputation points
accepted 2025-07-02T16:03:45.9566667+00:00
Mike Banes 20 Reputation points
1 answer One of the answers was accepted by the question author.

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
asked 2025-06-28T01:27:15.1533333+00:00
psdehr 40 Reputation points
accepted 2025-07-02T02:15:41.8933333+00:00
psdehr 40 Reputation points
0 answers

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
asked 2025-06-30T23:43:47.83+00:00
OWEN 0 Reputation points
commented 2025-07-01T07:35:07.71+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

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…

SQL Server | Other
asked 2025-06-27T11:49:36.5033333+00:00
GerryG 20 Reputation points
accepted 2025-06-30T14:01:39.2633333+00:00
GerryG 20 Reputation points