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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Microsoft ACE.OLEDB.12.0 is not registered while import excel file
Microsoft ACE.OLEDB.12.0 is not registered -
SQL Server Database Engine
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
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
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
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…