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
download sql 2022 media
where can i download the media for sql2022? Thank You, Brian
SQL Server | Other
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
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
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
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
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
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
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
SQL Server | Other
SQL Server 2022 import wizard missing MS Excel option
SQL Server 2022 import wizard missing MS Excel option
SQL Server Integration Services
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
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
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
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
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
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
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
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
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
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.