SQL Server

Integration with SSO login on-premises (non-fabric and non-cloud) PowerBI Reporting Server

Hi, We need to understand the standard integration process of integration SSO login (with PowerBI Reporting Server) wherein the flow is following : FSSO login happens and a SAML token is generated by the service provider. Using above SAML token, we…

error 26 trying to connect to my local server

Cannot connect to xxx.xxx.xxx.xxx\SQLEXPRESS. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is…

How to identify different compressions

Hi, ALL, This - https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-partitions-transact-sql?view=sql-server-ver17 indicates that there is only 1 record for both XML and regular partition compression. My question would be -…

SQL Server Object Explorer closes immediately in Visual Studio – Error 0x8007007B and SQL Server Express installation fails

Details: I am experiencing an issue with Visual Studio where I cannot create or manage databases. When I open Visual Studio and go to View → SQL Server Object Explorer, a popup window briefly appears and then immediately closes again. This keeps…

How to reset Local Database

My computer is saying local data base must be reset

Best, Most Efficient DATETIME filtering

I have seen many discussions regarding doing filtering against a DATETIME Data Type. Some suggest to use a true DATTETIME format. WHERE <DATETIME_Column_Name> >= '2026-02-17 00:00:00.000' Others suggest to use just a quoted Date... WHERE…

SQL Server 2025 LocalDb installation is missing components

According to https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2025 - "SQL Server Express LocalDB is a lightweight version of Express edition that has all its programmability features" Therefore I would…

TSQL query to dynamically extract data from a json object using OPENJSON in SQL

Hi everyone. I need help with writing a TSQL query that will dynamically extract data from a JSON object using OPENJSON. I need the query to be able to work on both simple and nested json object. Thanks in advance.

Please provide KB2000257

I would like to read the KB2000257 article. SQL Server Express 2022 is failing per the 3 local security policies error BUT the 3 policies are all set correctly! The failure is immediate and NO LOGS are produced yet.

SQL Agent Job failing with Error 8152 (String or binary data would be truncated) during Replication/Distribution

Hi everyone, I am encountering a persistent failure in a SQL Server Agent Job that appears to be related to a Replication Distribution Agent. The Error: The job fails at Step 1 (Distribution Agent startup) or Step 3 (Detect nonlogged agent shutdown) with…

How to create initial full backup followed by transaction logs daily?

This is related to work. I have been sending out a full-back up of a database in BAK file format (using SQL Server 2022) for a client, but now the client is asking for an initial full backup followed by transaction logs daily. How do I go about doing it…

SSAS 2019 - Tabular Process Hanging / Deadlocking

Hello everyone, We have a SSAS 2019 CU16 hosting a very small tabular model, about 20-25 tables and only a couple MB in size. As expected the processing time is fairly short, only 2-3 seconds so we currently have an SQL Agent job (on a remote…

Enabling RCSI and ADR on SSISDB and ReportServer

We're considering enabling two database-level settings on SSISDB and ReportServer: READ_COMMITTED_SNAPSHOT (is_read_committed_snapshot_on = 1) — reduces blocking by using row versioning instead of shared locks ACCELERATED_DATABASE_RECOVERY…

When following SSIS Tutorial on microsoft learn I receive a data type error

I have following the Microsoft Learn SSIS tutorial and am currently on https://learn.microsoft.com/en-us/sql/integration-services/lesson-1-6-adding-and-configuring-the-lookup-transformations?view=sql-server-ver16 , trying to follow the below step: My…

Sequel server licensing

My distributer is telling me that SQL Server Standard 2022 - 2 Core License Pack - 3 yearSQL Server Standard 2022 - 2 Core License Pack - 3 year billed annually is a perpetual license? I have query with this as it has a termed subscription time?…

ACE.OLEDB.12.0 provider is not registered on the local machine

Hello, We have a client that tried to import an excel using the import and export wizard and he recceived the following error:     The operation could not be completed. Additional information:      The 'Microsoft.ACE.OLEDB.12.0' provider is not…

I have deleted this item and removed the registry entry, but the error persists.

How to fix SQL Server installation error and run successfully

I have repeatedly install Microsoft SQL 2025, though it show that the server is running but I have been unable to connect as I keep having error message; see below - TITLE: Error The client was unable to establish a connection because of an error during…

Can a SQLServer 2016 AG with one database be setup with two separate Managed Instance Links?

I’m planning a migration of a SQL Server 2016 Always On AG with a single 4TB database to Azure SQL Managed Instance. We already have one MI acting as a read‑replica for reporting and analytics. As part of the migration, I’m considering deploying a second…

Install Component Package on Visual Studio Installer 22

Hi expert, I need install SSMS 22 by offline with input this command vs_SSMS.exe --layout C:\SSMS_Layout --all.. but this command install ALL PACKAGES Component I only need component package of Management Studio 22 anyone know the Packages Component…