SQL Server

Using DAC (Dedicated Admin Connection) with a SQL Server Managed Instance

Hi, Azure SQL Managed instances Is it possible to use DAC with a SQL Managed instance? If so how? Does it need to be on a vm that is within the same vnet as the managed instance? Is it possible to use the DAC from my remote laptop which connects to our…

How to dynamically connect to PostgreSQL, Oracle, and MySQL inside an SSIS Script Task using credentials from a SQL table to use these connection to perform rest of ETL Operations?

Greetings, I am developing an ETL process using SSIS (SQL Server 2019) and Visual Studio 2022. My Goal I need to connect to three external databases (PostgreSQL, Oracle, and MySQL) inside an SSIS Script Task (C#). The Requirement To keep the package…

Error viewing custom reports on Dynamics 365 9.1 on-premise

We cannot run a custom report created in the report wizard. The standard reports seems to be working. We have the same solution running on TEST and Develop servers, where we dont get error. System infos: CRM server: Windows Server 2019 Standard…

How do filter Action column on SQL Database Audit Specification?

Hi Expert, How to exclude Column [Action ID] with record 'SELECT','EXECUTE' & 'VIEW' action? I've filtered [Action ID] using conversion to INT type to getting ID of the action(Select,Execute,View) but it still not worked .. any suggestion? great…

Running total for grouped data

Given input data similar to: Month Region Store Sales Jan R1 S1 10.00 Jan R1 S1 15.00 Jan R1 S1 30.00 Jan R1 S2 5.00 Jan R1 S2 1.00 Jan R2 S3 17.00 Jan R2 S3 …

How to install SQL Server Management Studio for Personal Use

Hello, I would like to download the latest SQL Server Management Studio locally on my machine for personal use and training. I have been unemployed since Nov-2025 and I would like to maintain and increase my SQL skills. I would also like some basic…

auto send a report daily

how to have a report auto generate to a pdf and emailed to me and the other advisers, every morning. report in question is the "Service Adviser Performance" report for store 2115, Mercedes Benz of North Orlando.

Quiero descargar SMSS

¿Cómo descargo SSMS, estuve intentando y no me deja, además no me aparece la opción de: "Descarga de SMSS"?

SQL Server connections slow after in-place upgrading to 2025 from 2022

We are experiencing slow connections to SQL 2025 after doing in-place upgrade from 2022. Connections taking ~ 900ms SQL authentication (not Windows auth). Tried to add -T4671 startup parameter as found in another topic but no effect.

relocation of files in databases belonging to AG

relocation of files in datAbases belonging to Availability Group

Problem upload .pbix file in power bi "There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file."

Problem upload .pbix file in power bi "There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file." Problem upload .pbix file in power bi "There was…

Upgrading SQL 2019 to 2025 - Fulltext index issue

When doing a SQL server upgrade from 2019 to 2025, im running into an issue when it is trying to finalize the Fulltext index part of the upgrade. It seems like the upgrade locks itself out of the upgrade, by putting permissions on the Filterdatafolder,…

Power BI Desktop "Cannot establish connection" - msmdsrv.exe listening but connection timeout

Hello, I'm experiencing a persistent issue with Power BI Desktop failing to start. The error message is: "Cannot establish connection. Please verify that the server is running." Environment OS: Windows 11 Pro (10.0.26200) Hardware: Intel…

how to fix sql installation problem in windows11

unable to install sql application since I have bought new laptop with windows 11. tried reaching out to hp support but still no use.facing the below error tried multiple times fixing but still the same.

getting below error while installing microsoft sql server 2025

Migration feature on SSMS 22

Hi Expert, I'm running first time Migrate SQL Server feature on SSMS 22 for Database Assessment with 10TB size, this report as below: "Status": "Error", "**AssessmentRecommendations": [],** "Name":…

The error was while running the store procedure runs xp_cmdshell to run a batch file

The stored procedure SP_CreateClientDatabase internally uses xp_cmdshell to execute a batch file located at: F:\ECLOUD_DB_Script\CreateDB.bat However, the execution is currently failing with the below error:An error occurred during the execution of…

Table constraint design to avoid a cycle

In the minimal reproducible example below, table C is invalid as it results in a cycle. I understand I can simplify C by removing the constraints, however the number of triggers required after goes up significantly if I want to preserve the cascading…

Sudden "Data source access error" with On-Premises Gateway and SSAS Tabular 2016

Hi everyone, We are experiencing a critical issue with a Power BI Report (Premium Capacity) connected to an on-premises SSAS Tabular instance (v13.0.6300.2) via On-premises data gateway (v3000.314.5). Everything has been working perfectly for years, but…

BULK INSERT cannot access UNC path, error code 5 (Access is denied) using gMSA unless locally triggered

Running a stored procedure to bulk insert from a UNC path works locally via SSMS and via SQL agent job but if run remotely I receive Operating system error code 5 (access is denied). Please help as this workaround is not suitable for our…