21,315 questions with SQL Server-related tags

Sort by: Updated
1 answer

Azure Elastic Jobs dynamic enumeration includes databases from wrong elastic pool

I'm experiencing an issue with Azure Elastic Jobs where the dynamic enumeration feature is incorrectly including databases from the wrong elastic pool. Setup: - Two elastic pools: "PoolA" and "PoolB" - Target group using…

SQL Server Database Engine
asked 2026-01-29T10:58:12.1766667+00:00
Deyvid Todorov 10 Reputation points
answered 2026-01-29T10:58:23.7566667+00:00
Q&A Assist
2 answers

Can SQL Server Developer Edition be used with real production data in Dev/Stage/PreProd?

Hi, I have two related questions about SQL Server Developer Edition licensing: Can we legally use Developer Edition in Stage or PreProd environments? Our production data (without masking/virtualization) is restored for developers in the development…

SQL Server Database Engine
asked 2026-01-21T15:34:41.5433333+00:00
Farid Zahin 0 Reputation points
commented 2026-01-29T10:30:34.5+00:00
Farid Zahin 0 Reputation points
2 answers One of the answers was accepted by the question author.

sqlcmd execute issue in SQL Server 2025

EXEC xp_cmdshell 'sqlcmd -S MYS-0101 -d SampleDatabase -U sa -P Sa123 -i "script.sql"' is not working in SQL 2025 its giving trust certificate error, how to fix this certificate error without changing the code I need the microsoft…

SQL Server Database Engine
asked 2026-01-28T16:12:11.7133333+00:00
Ganesh R 0 Reputation points
accepted 2026-01-29T10:14:27.05+00:00
Ganesh R 0 Reputation points
2 answers

i forgot my password i set for microsoft sql and even name . so can i make new id again

Forgot my Password And and entry name With which I logined so can I reset Or how can I make New ID If I don't know anything about the old account..

SQL Server | Other
asked 2026-01-02T09:36:33.4733333+00:00
ROOPREET GUPTA 0 Reputation points
commented 2026-01-29T09:57:03.81+00:00
Akhil Gajavelly 1,135 Reputation points Microsoft External Staff Moderator
2 answers

Install SQL Management Studio without Visual Studio Tools or Shell

Hi there, I am doing some pen test remediation and our SQL servers are flagging that Visual Studio tools such as Shell (isolated) and Tools for applications are vulnerable. So i've been trying to find a way to install SSMS without Visual Studio at all as…

Windows for business | Windows Server | User experience | Other
SQL Server | Other
asked 2023-11-24T14:04:03.66+00:00
TheLoops 6 Reputation points
commented 2026-01-29T09:33:30.7833333+00:00
Richard S 5 Reputation points
2 answers

How to fix the identity issue in sql server 2025 AI feature while setting up Vector features

I am currently doing POC to explore SQL Server 2025 AI Feature in which I tried to set up Vector features. I am able to create scoped credential and external model but when I do the select statement it gives an error : here is the select state : SELECT…

SQL Server Database Engine
asked 2026-01-21T11:50:19.3833333+00:00
Venugopal, Kamalakkannan 0 Reputation points
commented 2026-01-29T09:30:43.4033333+00:00
Venugopal, Kamalakkannan 0 Reputation points
1 answer

When I create in Management Studio a query in a LSO on a table in DB2, the columns with decimal won't be in the autogenerated script

When I auto-create in Management Studio a query in a LSO on a table in DB2, the columns with decimal won't be in the autogenerated script and the values are displayed different to oledb

SQL Server Database Engine
asked 2026-01-29T09:24:18.98+00:00
Brigl, Karl 40 Reputation points
answered 2026-01-29T09:24:29.07+00:00
Q&A Assist
1 answer

Birthday attacks against Transport Layer Security (TLS) ciphers with 64bit block size Vulnerability (Sweet32)

Hi Recently deployed in server this vulnerabilities. Since then the email delivery in SSRS is not working. Can someone help with this issue? This is the error message.

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,136 questions
asked 2026-01-28T10:58:37.1866667+00:00
Ann Marion Fernandez 0 Reputation points
answered 2026-01-29T09:05:47.9966667+00:00
Shruti Dhruv 800 Reputation points Microsoft External Staff Moderator
1 answer

How to install my SQL Server Express 2025

Hi, I have issues regarding the SQL Server 2025 Express and I got this error/trouble-shooting message popped up this display. Can you help me process this step by step how to resolve this? I'm using Windows 11 (I think) in this case. Thank you.

SQL Server | Other
asked 2026-01-29T05:19:45.14+00:00
Michael Le 0 Reputation points
answered 2026-01-29T09:05:29.26+00:00
Lakshmi Narayana Garikapati 675 Reputation points Microsoft External Staff Moderator
0 answers

NHS worker; using 'Waiting PTL' option via SQL

I am working by using data on the Admitted PTL (NHS). I am trying to book patients' appointments using filtered down data, by who hasn't had a pre assessment prior to surgery. The option 'Had Pre-Assessment?' is not working. I'm getting the same figures…

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,136 questions
asked 2026-01-21T13:34:44.05+00:00
JADE D 0 Reputation points
commented 2026-01-29T06:42:24.72+00:00
Lakshmi Narayana Garikapati 675 Reputation points Microsoft External Staff Moderator
2 answers

I have installed SSMS 2022 but unable to login.

Hello Team, I have installed SSMS 2022 on my local laptop. But I am unable to connect to the connection string. My laptop server name is ASHISH and instance name is MSSQLSERVER. I am entering ASHISH\MSSQLSERVER as Server Name but it is showing error code…

SQL Server Database Engine
asked 2026-01-19T09:20:08.8366667+00:00
Ashish Karnavat 0 Reputation points
commented 2026-01-29T06:38:18.2966667+00:00
Lakshmi Narayana Garikapati 675 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Reinitializing the replication caused the deletion of database

I’m running a pull subscription using transactional replication between two databases, where the Publisher and Distributor are the same server. We removed the permissions for the account originally used for the replication job and replaced it with a new…

SQL Server | SQL Server Transact-SQL
asked 2026-01-26T11:52:11.7366667+00:00
Shreyams Kumar 20 Reputation points
accepted 2026-01-29T06:16:07.97+00:00
Shreyams Kumar 20 Reputation points
1 answer

How to recover from and MSDB database in “suspect” mode

Dear community, My SQL server MSDB DB is in suspect mode and i have no backup, i have tried to repair it to no avail, i have also run a full SQL repair which completeted successfully but i still have the error. Please advise on how i can repair…

SQL Server Database Engine
asked 2026-01-29T06:07:27.2133333+00:00
Rab Processors 0 Reputation points
answered 2026-01-29T06:07:37.6766667+00:00
Q&A Assist
1 answer

SQL Server 2022 Express installation fails on Windows 11 using web installer

Hello, I’m trying to install SQL Server 2022 Express on a Windows 11 laptop, but the installation fails when using the web installer. Environment: Windows 11 (64-bit) Laptop (not a server) SQL Server 2022 Express (Web installer) SQL Server Management…

SQL Server Database Engine
asked 2026-01-28T01:26:17.6066667+00:00
PEDRO DAVID RAMIREZ BECERRA 0 Reputation points
commented 2026-01-29T06:07:33.91+00:00
Akhil Gajavelly 1,135 Reputation points Microsoft External Staff Moderator
0 answers

SQL DB message queue migration to Datalakehouse

Audit events to Datalakehouse migration related operational test cases, failover and chaos testing scenarios

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
592 questions
asked 2025-12-29T09:17:17.2233333+00:00
Pallavi A Nanjundegowda 0 Reputation points
commented 2026-01-29T05:53:38.98+00:00
Lakshmi Narayana Garikapati 675 Reputation points Microsoft External Staff Moderator
1 answer

Microsoft ACE.OLEDB.12.0 is not registered while import excel file

Microsoft ACE.OLEDB.12.0 is not registered -

SQL Server Database Engine
asked 2026-01-27T08:59:23.8633333+00:00
Noseda, Enzo 0 Reputation points
commented 2026-01-29T05:26:20.99+00:00
Akhil Gajavelly 1,135 Reputation points Microsoft External Staff Moderator
1 answer

SQL error -An expression of non-boolean type specified in a context where a condition is expected

Thanks in advance for any help folks can offer. I've been pulling my hair our all day yesterday trying to figure out how to fix this. I received the error below after I added 3 new lines (line 60, 61 and 62). The original code without these 3 new lines…

SQL Server | SQL Server Transact-SQL
asked 2026-01-26T18:29:09.99+00:00
DW 0 Reputation points
commented 2026-01-29T05:14:35.2766667+00:00
Akhil Gajavelly 1,135 Reputation points Microsoft External Staff Moderator
3 answers

Why does Optimized Locking (LAQ) rely on RCSI/tempdb row versions instead of ADR row versions?

I have a question regarding the new Optimized Locking feature (specifically the Lock After Qualification (LAQ) ) in SQL Server 2025. Database already has Accelerated Database Recovery (ADR) enabled, which maintains its own set of row versions as part of…

SQL Server Database Engine
asked 2026-01-24T04:55:01.96+00:00
Steven Lam 20 Reputation points
commented 2026-01-29T04:58:26.42+00:00
Akhil Gajavelly 1,135 Reputation points Microsoft External Staff Moderator
2 answers

Running group MSA for agent service account won't let me back up to a NAS target

I'm running SQL Server 2022 in a clustered/AG environment, using a gMSA for the database engine and agent services. Even though I've granted full access to the NAS backup share, it cannot see it. We're using the Ola Hallengren maintenance solution. I've…

SQL Server Database Engine
asked 2026-01-23T20:34:15.87+00:00
DataMatt43 0 Reputation points
commented 2026-01-29T04:21:04.87+00:00
Akhil Gajavelly 1,135 Reputation points Microsoft External Staff Moderator
2 answers

Failed to upload Power BI report "PBIX" file to the Power BI Report Server

Failed to upload Power BI report "PBIX" file to the Power BI Report Server while using Power BI Desktop (May 2025) version. Server version: Power BI Report Server: 1.23.9274.14406 (May 2025) Desktop version: Power BI Desktop: 2.143.954.0 (May…

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,136 questions
asked 2026-01-23T04:32:43.0533333+00:00
Cherie Chu 0 Reputation points
commented 2026-01-29T04:12:45.62+00:00
Akhil Gajavelly 1,135 Reputation points Microsoft External Staff Moderator