21,098 questions with SQL Server-related tags

Sort by: Updated
0 answers

SSRS issue

I have faced mentioned issue while configure the database using ssrs (2022) version Please provide the correct way to fix it ASAP.

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,113 questions
asked 2025-11-22T11:55:47.98+00:00
Anandhswarupp 205 Reputation points
1 answer

download sql 2022 media

where can i download the media for sql2022? Thank You, Brian

SQL Server | Other
asked 2025-11-21T19:15:30.2366667+00:00
Brian Coder 0 Reputation points
commented 2025-11-22T07:16:50.3133333+00:00
Erland Sommarskog 128.4K Reputation points MVP Volunteer Moderator
4 answers

Best practice with sp_syspolicy_events_reader and ##MS_PolicyEventProcessingLogin##

The SQL Server logs on our primary replica (Microsoft SQL Server 2022 with Always On) has been filling up with this repeated message: The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'SQLAG1_msdb.dbo.syspolicy_event_queue'…

SQL Server Database Engine
asked 2025-08-05T14:53:19.4333333+00:00
anna@tec 0 Reputation points
commented 2025-11-22T01:51:43.63+00:00
Thumu Sai Pranay 0 Reputation points
3 answers

Unable to acquire authorization token (ConnectionDlg.AadInteractiveAuthProvider) with "Azure Active Directoy - Universal with MFA" to Azure SQL server when SSMS is run as my privileged account

This works fine from another system, or if I log on to the laptop directly with my privileged account. I need to run SSMS as my privileged account, because that's the only account that has been authorized to connect to our Azure SQL servers &…

Microsoft Security | Microsoft Entra | Microsoft Entra ID
Microsoft Security | Microsoft Authenticator
SQL Server | Other
asked 2024-10-07T14:33:49.44+00:00
Dom-Su BoChum 55 Reputation points
commented 2025-11-21T21:32:49.29+00:00
Derrick Van Hoeter 0 Reputation points
0 answers

Scientific Notation Bug Same as Excel

I have an 18 digit number as a row identifier, it is unique to 18 digits. SSAS insists there are duplicates. This is because it converts "long" numbers to scientific notation, but when you request it as whole number only the first 15 digits…

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,362 questions
asked 2025-07-28T19:18:49.21+00:00
Longoria Joseph 80 Reputation points
commented 2025-11-21T17:48:25.4566667+00:00
Longoria Joseph 80 Reputation points
1 answer

Unable to install SQL Server. Exit code (Decimal): -2147467259

I am trying to install SQL Server Express 2022 I tried to install it, and sot this error: Unable to install SQL Server. Exit code (Decimal): -2147467259 Have attached the log as attcahent Any help is much appreciated.

SQL Server | Other
asked 2025-07-28T09:49:53.5933333+00:00
Antony Vasanth 0 Reputation points
commented 2025-11-21T14:54:46.2+00:00
Singam shetty Sri ganesh 80 Reputation points Microsoft External Staff Moderator
1 answer

How can i add MSSQL 2019 into Microsoft admin center

HI, I just purchased SQL 2019, I would like to know how can i add MSSQL 2019 into Microsoft admin center? Thank You

SQL Server | Other
asked 2025-07-28T03:53:25.1633333+00:00
Muhammad Khairun Hafiz Zainudin 0 Reputation points
commented 2025-11-21T14:53:26.2533333+00:00
Singam shetty Sri ganesh 80 Reputation points Microsoft External Staff Moderator
3 answers

Unable to connect to SSAS 2025 via SSMS

I have installed SSAS 2025 in MOLAP mode. I installed SQL 2025 Developer Standard. The service is up and running. Port is open. My user is SSAS administrator. Using SSMS 22, 21 and even 20 I get the following error: "Invalid connection…

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,362 questions
asked 2025-11-19T18:25:25.3566667+00:00
Chris Mara 0 Reputation points
answered 2025-11-21T14:31:21.84+00:00
Yitzhak Khabinsky 27,016 Reputation points
3 answers One of the answers was accepted by the question author.

Request for high CPU machine with 48 and 96 GB RAM for production DB load on Linux

Our organization requires a high CPU machine with an AMD64 processor to install MSSQL on Ubuntu 20.04. We are considering two options, D48ls_v5 and D48pls_v5, and need to know if these machines use AMD64 and which one is the best fit. Any other…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
9,620 questions
SQL Server | Other
asked 2024-05-09T09:17:37.9833333+00:00
Anonymous
answered 2025-11-21T14:05:29.31+00:00
Steven Lam 20 Reputation points
1 answer

SQL Server 2022 import wizard missing MS Excel option

SQL Server 2022 import wizard missing MS Excel option

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,756 questions
asked 2025-11-21T13:01:40.7333333+00:00
Shahidullah All Mahmod 0 Reputation points
answered 2025-11-21T13:02:01.2933333+00:00
Q&A Assist
1 answer

Preciso de apoio para comprar uma licença do sql server 2022 ideal para meu servidor, que atenda os requisitos do mesmo

Desejo comprar licença do Sql server 2022, necessito que o suporte da microsoft, se possível acesse meu servidor para verificar quais requisitos se adequam ao mesmo.

SQL Server Database Engine
asked 2025-11-21T12:24:46.45+00:00
UDI MURAKAMI 0 Reputation points
answered 2025-11-21T12:25:28.0266667+00:00
Q&A Assist
2 answers

Concurrent user Access causes CPU max out on SSAS Tabular

Hi all, we've build a medium sized tabular modell with ~10 GB of data. This runs on SSAS 2022 Enterprise Edition, the VM running the Instance has 16 vCores and 512 GB of memory (the host has got 64 pCores and 2048 GB of memory). We see great performance…

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,362 questions
asked 2025-08-22T06:26:32.5366667+00:00
Birkenheuer, Stefan 5 Reputation points
answered 2025-11-21T12:23:26.0966667+00:00
Birkenheuer, Stefan 5 Reputation points
1 answer

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

Hello everyone, I am currently preparing for the DP-900: Microsoft Azure Data Fundamentals exam and would like to get an expert's clarification on a specific question. The question is as follows: Which T-SQL statement or clause should be used to…

SQL Server | SQL Server Transact-SQL
asked 2025-08-19T14:21:02.75+00:00
Anabella Noemi Santillan 0 Reputation points
commented 2025-11-21T12:14:50.85+00:00
Thumu Sai Pranay 0 Reputation points
1 answer

My company already has access to a third-party SQL server that we currently access via ODBC. How much will it cost to use SMSS and SSRS to access the same server?

My company already has access to a third-party SQL server that we currently access via ODBC. How much will it cost to use SMSS and SSRS to access the same server?

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,113 questions
asked 2025-08-04T15:08:51.5733333+00:00
D H 0 Reputation points
commented 2025-11-21T12:13:53.9466667+00:00
Thumu Sai Pranay 0 Reputation points
2 answers

Data Synchronization - Syncing Two Databases in SQL Server

I'm needing to take one database and have it on two separate sql servers (in two different physical locations) and have it stay in sync. Is there a way that I can do this? I've looked into SQL Server Replication ie:…

SQL Server Database Engine
asked 2025-08-05T19:47:19.7333333+00:00
Brad 0 Reputation points
commented 2025-11-21T12:10:51.3566667+00:00
Thumu Sai Pranay 0 Reputation points
1 answer

SQL Server 2022 installation fails with error code 1639

I've been trying to install SQL Server 2022 on Windows 10 Enterprise. Each time I try, the installer fails with error code 1639. Each time I attempt to reinstall I Uninstall all SQL Server related items in the control panel Remove SQL Server…

SQL Server | Other
asked 2025-07-21T22:13:54.97+00:00
Cullen Sharp 0 Reputation points
answered 2025-11-21T11:57:42.2+00:00
Thumu Sai Pranay 0 Reputation points
0 answers

Inquiry About Performance Impact of PBIRS Scale-Out on Scheduled Data Refresh

Hi, We currently have a large number of Power BI reports published on our on-premises Power BI Report Server. We've observed that many of these reports take a long time to refresh their data during scheduled refreshes triggered from the report server…

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,113 questions
asked 2025-07-23T10:40:21.2+00:00
Omar Basheer Omar Kamal 0 Reputation points
commented 2025-11-21T11:50:26.3333333+00:00
Thumu Sai Pranay 0 Reputation points
3 answers

Which licenses would you recommend for our scenario?

We are a company with 100 employees. We would like to have 5 virtual SQL servers running on one node. In total, all SQL servers have 24 virtual cores. We have 100 users who need data from the SQL servers. In the event of a failover, the VMs are moved to…

SQL Server | Other
asked 2025-11-18T08:27:47.8033333+00:00
Andreas 0 Reputation points
edited an answer 2025-11-21T11:08:08.4333333+00:00
Andreas 0 Reputation points
1 answer

High CPU usage when using the automatic tuning feature

I noticed a few times since the automatic tuning has been enabled on different databases (two different SQL Server instances) that CPU consumption has hit 100%. The first occurrence ended up with lots of errors "A time out occurred while waiting to…

SQL Server Database Engine
asked 2025-11-19T14:29:33.5533333+00:00
Marcin Dolinski 0 Reputation points
edited a comment 2025-11-21T10:59:33.55+00:00
Shruti Dhruv 250 Reputation points Microsoft External Staff Moderator
2 answers

Microsoft® SQL Server® 2022 Express with SnapDragon Prozessors!?

Hello, I have problems with installation SQL Server Express and now I was told that the reason shoul be that Microsoft® SQL Server® 2022 Express does not work with Snap dragon Prozessors!? That make no sense to me. Please help. Thank you.

SQL Server | Other
asked 2025-11-20T09:29:03.6766667+00:00
AlNi 0 Reputation points
answered 2025-11-21T10:35:44.9766667+00:00
Shruti Dhruv 250 Reputation points Microsoft External Staff Moderator