SQL Server

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…

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…

SQL “untrusted domain” error over VPN for one device only (Windows Auth)

I’m looking for some advice on an issue affecting a single user/device when connecting to SQL Server over VPN. The user receives the following error when launching an application that connects to SQL Server using Windows Authentication: “Login failed.…

RedHat Linux 9.7 SQL Server 2025 CU2 Fails to write database backup to Linux NFS Share

Hello, I have a VMWare VM running RedHat Linux 9.7 and SQL Server 2022 CU 23. SQL Server 2022 can successfully write database backups and the mssql agent job text log file to the Linux NFS share. I successfully upgraded the VM to SQL Server 2025 CU2.…

Reinstallation doubt regarding Microsoft Visual C++ 2017 distributable package error

can we resolve this SQL Server 2019 install warning - Microsoft Visual C++ 2017 distributable package error, by re-installing the Microsoft Visual C++ 2017 distributable package, if the current windows version already got end of support?

I'm trying to restore sql instance that is about 100gb and there is this issue of limited

I'm not export, I know basics how to do in via SQL Management Studio and I get this message: Microsoft.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of…

Does UPDATE WITH (ROWLOCK) guarantee row-level locking, or can SQL Server still acquire page/table locks and perform lock escalation?

Hi Team, I would like clarification on SQL Server locking behavior for an UPDATE statement when the ROWLOCK table hint is explicitly specified. Example: From Microsoft documentation, I understand that: ROWLOCK is a table hint that requests row-level…

maxdop of a query will fallback to serial or not.

if a query has maxdop 2 : in this case can microsoft decided in this situation to not to use parallelism and use all cores/or execute a query serially, as if parllelism is switched off

Microsoft SQL Server 2022 - no TCP/IP connection in client protocols in SQLServer Configuration Manager

Hello, since SQL Server 2022 Standard edition I miss in "SQL Server Configuration Manager" under "client protocols" all protocols e.g. "TCP/IP", to enable client connection to the Database. Also I can not create manually a…

SQL Snapshot Replication Fails with BCP EOF / NULL Errors (Works in Transactional Replication)

Issue: We have Snapshot Replication on a production server that was working fine but recently started failing with the below error: Agent message code 20037. The process could not bulk copy into table "XXX". Message: End of file…

SQL Server 2022 Oops... Error decompressing SQL Server media

Hello, I am trying to install SQL Server 2022 for the first time, but it gives me this error. I spent about 10 days to find the main cause of this problem and try to solve it, but it seems that is a new one. I tried to: remove .exe installation file…