21,170 questions with SQL Server-related tags

Sort by: Updated
3 answers

SQL Server Agent not starting after installing KB5071544

My SQL Server Agent service does not start after a reboot of the server to complete installation of KB5071544. Event logg shows ID 7000, stating timeout occured. I tried increasing the tme out to 5 mins but no change. I am running SQL server 2019…

SQL Server | Other
asked 2025-12-11T19:18:14.1566667+00:00
Abraham Libu Varghese 0 Reputation points
answered 2025-12-12T05:00:14.6033333+00:00
Abraham Varghese 0 Reputation points
0 answers

SSMS 22 Azure validation and weird email address

I installed SSMS 22 today, and when I try to connect to an Azure SQL Database and server, I get the following prompt with some weird email address. I have NO idea where it is pulling that from. I have ZERO issue with SSMS 21, but with SSMS 22 this is an…

SQL Server | Other
asked 2025-12-11T23:24:16.3466667+00:00
Scott Klein 35 Reputation points
2 answers

SQL Server licensing with SA for Distributed Availability Group

I need help in understanding how many licenses I need specific to Distributed Availability Group solution below with Software Assurance benefits and purchased licenses. Region A: 3 Replicas with 2 read-write and 1 HA replica Region B: 3 Replicas with 2…

SQL Server | Other
asked 2025-12-11T19:27:28.0333333+00:00
VYAGHRESWARUDU KOTTURI 0 Reputation points
answered 2025-12-11T21:34:29.2466667+00:00
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator
2 answers

Select most recent data per record from multiple tables

I am trying to get the latest data for a record from multiple tables. The issue I am running into is that the data on each table could have been modified at different times and each table may contain multiple rows per record. I am currently using row…

SQL Server | SQL Server Transact-SQL
asked 2025-12-10T15:59:27.8+00:00
James H 0 Reputation points
commented 2025-12-11T21:30:27.4633333+00:00
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator
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
asked 2025-12-03T23:41:08.02+00:00
Serrato, Mario 0 Reputation points
edited a comment 2025-12-11T21:06:00.9933333+00:00
Serrato, Mario 0 Reputation points
1 answer

where can I download report builder for mac or linux (arm 64)

I am looking for installation binary or the like. Even an APT or Cask command.

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,121 questions
asked 2025-12-11T17:04:32.9733333+00:00
Eric Rosenblum 0 Reputation points
answered 2025-12-11T17:04:44.3133333+00:00
Q&A Assist
1 answer One of the answers was accepted by the question author.

Readable mirror database on Database mirroring

Hi expert, is Mirror database readable on Database Mirroring concept ? if YES, how to set it? great thanks & appreciation best regards, Urbel

SQL Server Database Engine
asked 2025-12-11T06:52:13.5733333+00:00
UrBel 320 Reputation points
accepted 2025-12-11T06:53:04.75+00:00
UrBel 320 Reputation points
3 answers

Descrepancy between SalesLT.SalesOrderDetail and SalesLT.SalesOrderHeader?

I deployed a new AdventureWorks LT. When I query: select * from SalesLT.SalesOrderDetail where salesorderID = 71774 there's 2 rows: SalesOrderDetailID's 110562 and 110563. They both have a linetotal of 356.898000 so when I query: select sum(LineTotal)…

SQL Server | SQL Server Transact-SQL
asked 2025-12-10T14:31:19.0566667+00:00
Jasper Versteegh 0 Reputation points
answered 2025-12-10T21:54:48.7833333+00:00
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator
2 answers

SSMS 20.2 Import Wizard Throwing Error at Server End

I was trying to use the import wizard in SSMS and found that the destination servers was throwing the above error. The error that the server administrator has sent me is: "The EXECUTE permission was denied on the object…

SQL Server | Other
asked 2025-12-10T14:34:02.6566667+00:00
Richard Williams 15 Reputation points
answered 2025-12-10T21:42:42.21+00:00
Erland Sommarskog 128.7K Reputation points MVP Volunteer 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,121 questions
asked 2025-12-10T19:28:35.8233333+00:00
Jinal Contractor 121 Reputation points
answered 2025-12-10T21:28:21.9866667+00:00
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator
2 answers

SQL Server maintenance plans not running

None of my maintenance plans are running. They are Enabled as Recurring and scheduled to run daily or weekly, but when I select each plan and View History, they are not even attempting to run. The only History they have are the runs that I manually…

SQL Server | Other
asked 2022-11-17T17:47:14.533+00:00
Scott Fischer 6 Reputation points
commented 2025-12-10T16:03:52.55+00:00
Jacob Pitsch 0 Reputation points
1 answer

HOW TO FIX SQL SERVER(Local Instance MYSQL80)

MY SQL SERVER IS NOT RUNNING AND IT IS NOT CONNECED

SQL Server Database Engine
asked 2025-12-03T07:13:45.21+00:00
Isha Jangid 0 Reputation points
commented 2025-12-10T11:58:35.86+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
2 answers

MAX_DISPATCH_LATENCY in extended event , is not clearly explained in msdn.

hi, hi,   i have checked reducing it increasing it but could not get any thing, pls explain what exactly it means. DROP EVENT SESSION [CaptureSlowQueries] ON SERVER go CREATE EVENT SESSION [CaptureSlowQueries] ON SERVER ADD EVENT…

SQL Server Database Engine
asked 2025-12-10T10:50:27.08+00:00
rajesh yadav 291 Reputation points
commented 2025-12-10T11:32:53.88+00:00
Lakshmi Narayana Garikapati 650 Reputation points Microsoft External Staff Moderator
2 answers

how fix the error that occurs when I try to install SQL Server 2019

The following is the error message that I keep getting each time I tried to install SQL Server 2019: Unable to install SQL server (setup.exe). Exit code (Decimal): -2061893606 Error description: Wait on the Database Engine recovery handle failed. Check…

SQL Server Database Engine
asked 2025-12-02T13:56:13.8866667+00:00
CJAY Nwadinobi 0 Reputation points
commented 2025-12-10T10:46:45.8833333+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
3 answers

License Verification for SQL Server Express Commercial Use on AWS EC2

We are planning to install SQL Server Express Edition on an AWS EC2 instance running Windows Server and use it for commercial purposes. We would like to confirm whether this usage complies with the licensing terms. Environment details: Cloud platform:…

SQL Server | Other
asked 2025-11-26T08:24:28.0666667+00:00
Seiji Yoshida (吉田 誠司) 0 Reputation points
commented 2025-12-10T10:40:10.3966667+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
1 answer

SQL 2022 SSIS with ACE 12 32bit error unexpected Termination

Hi We had a set of SSIS package on SQL 2016 writing the output to Excel with different tabs. In the old server we have ACE 2010 version 14 32bit. We had to upgrade our servers to Windows 2022 SQL 2022 we installed ACE 16 32bit but when running the SSIS…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,760 questions
asked 2025-09-14T08:49:48.7566667+00:00
Katayoun Sarab 0 Reputation points
answered 2025-12-10T09:57:44.7233333+00:00
Lakshmi Narayana Garikapati 650 Reputation points Microsoft External Staff Moderator
0 answers

How can I get my Server and SQL authorization back?

I can provide the authorization number and usage right number. How can I retrieve the product registration account and authorization?

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.
586 questions
asked 2025-12-01T09:37:18.8166667+00:00
楊振福 0 Reputation points
edited a comment 2025-12-10T09:53:28.4266667+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
2 answers

REQUEST FOR SQL DATABASE

I am currently on the get data module on power bi, I have been learning how to import data and then I have gotten to SQL relational database. for better understanding it would be good to have a SQL database to practices with. Is it possible to download…

SQL Server | Other
asked 2025-12-01T08:51:10.78+00:00
osatohanmwen odia 0 Reputation points
commented 2025-12-10T09:01:23.09+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
2 answers

I can't connect to the Analytical services when using the SSMS

Hello , I can't connect to the analytical services using SSMS , it's shown as a disabled select option I have already added the SSAS feature to the exisiting installation and It is already existant in services (msc) What can I do to enable the…

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,365 questions
asked 2025-11-27T15:34:10.5333333+00:00
oussema_guerriche 0 Reputation points
commented 2025-12-10T08:50:03.43+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
3 answers

Setting Up Microsoft SQL Server on New Device

Hello, I recently set up MS SQL Server on a new computer. On my old machine, the server name was OLDCOMPUTER#\SQLEXPRESS and it used Windows Authentication with the username OLDCOMPUTER#\atsuser. On the new computer, the username is based on the new…

SQL Server Database Engine
asked 2025-11-25T20:52:04.0366667+00:00
Dana Slepyan 0 Reputation points
commented 2025-12-10T07:57:17.6866667+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator