SSRS2022 Custom Header Problem
Hi Guys, I found SSRS2022 16.0.1116.12 Custom Headers…
Can we enclose column name with double quotes in queries like select query
Hey Team, I'm dealing with multiple teams applications sql server database every day. I'm getting different types and combinations of column names with space, special characters etc. So that's why my query uses square brackets to enclose column names as…
Can we enclose column name with double quotes in queries like select query
Hey Team, I'm dealing with multiple teams applications sql server database every day. I'm getting different types and combinations of column names with space, special characters etc. So that's why my query uses square brackets to enclose column names as…
Can I replicate a failover SQL cluster to Azure VMs?
I have a client who has 2 SQL Server VMs running as a failover cluster for SQL. We are looking for a way to continuously replicate this to Azure VMs. I read through this…
Small Dialog boxes in SQL Server Management Studio (SSMS) 18.9.2
After installing SSMS 18.9.2 on SQL 2016 server (Windows Server 2016) all dialogs of SSMS contain very small fonts...in some cases the fonts are so small that the slider bar covers up all text (i.e. Help-->About). Is there a way to have the dialogs…
Invalid output when trying to invoke stored-procedure returning output from entityframework core -
Hi gents, can you sort out the following for me. Let me explain the scenario in detail. I have a MSSQL stored procedure that returns me output value. The output value is of int type. Stored Procedure: CREATE procedure…
how do i fix CVE-2024-0056
Microsoft.Data.SqlClient and System.Data.SqlClient SQL Data Provider Security Feature Bypass Vulnerability
On-prem MS SQL server 2016 migration to Azure SQL Server Managed database Instances path
Hi Team, We are currently planning to migrate our On-prem MS SQL Server 2016 to Azure SQL Server Managed Database Instances. The source will be our On-prem MS SQL Server 2016, and the target is the Azure SQL Server Managed Database Instances. I have a…
Unable to Connect to Database on SSRS Report Manager | Issue only occurs on one Citrix Account
As per my screenshot, the following error message keeps appearing when I try to connect to a data base of SSRS report. "Unable to connect to data source 'DataSource1'". This error message only seems to appear on my citrix account. This error…
SCOM 2019 Installation Setup Failure
Hello Everyone, I need help to completing the SCOM 2019 installation. I am setting up a SCOM lab and have tried installing it with SQL Server 2019 using CU12 and CU29, as well as SQL Server 2017 and SQL Server 2016 with the latest updates, but the…
I have migrated my SQL database and web app to azure database and web app services successfully while running the domain the login page shows proper but when i am inserting data and clicking on submit it give error : Named Pipes Provider, error: 40
I have migrated my SQL database and web app to azure database and web app services successfully while running the domain the login page shows proper but when i am inserting data and clicking on submit it give Error: A network-related or instance-specific…
Facing issues for the mismatch definitions of some methods from SQLEditors.dll used in SSMS 21
I am trying to consume the SQLEditors.dll from SSMS 21 and SSMS20 in my C# code however getting the compilation issue due to incorrect format of library as error : D:\BuildAgentB\work\fb305f1670873990\VersionSpecific.CommonFiles\NewQueryWriter.cs(83,…
Backup SQL VM, Cancel/Delete SQL VM resources and reservation
I am in the process of archiving an SQL VM and I would like to take backup of that resource and download it outside of the environment. After the backup is completed I would like to delete the VM and all of its associated resources and reservations.…
How to fix code throwing exception : Microsoft.Data.SqlClient.SqlException: 'Login failed for user '<token-identified principal>'. The server is not currently configured to accept this token.'
Hi All, I'm encountering an issue while trying to connect to an Azure SQL Database using Microsoft Entra Authentication (formerly Azure AD). I am using DefaultAzureCredential in my .NET application to authenticate and retrieve the access token, but…
Retrieving Admin Credentials for SQL Server Database Backup
Connecting to a database from SQL Server Management Studio with normal authentication is not allowing backup operations. An ex-employee who was the admin did not provide any credentials. As a result, backup cannot be taken, and attempts to assign roles…
SSRS Bing Maps Error: "The underlying connection was closed"
The SSRS report's map visual displays an error message. Although the Point Layer data region is showing correctly, Bing Maps encounters an error. Details: Report Server Version: 15.0.1102.675 TLS 1.2 Server: Enabled TLS 1.2 Client: Enabled …
Restore SQL Server Database From Snapshot Backup
I am attempting some experiments related to restoring a database from a snapshot backup. I backup metadata by T-SQL (BACKUP DATABASE with METADATA_ONLY) , and database mdf, ldf file by snapshot which involve SQL Server VSS Writer. In the begining, i…
DPM2022 SQL Backup: Class not registered
We have a DPM 2022 server with RU2 installed. Recently we had to perform a backup of an SQL server. We are getting this error when trying to backup the SQL database in DPM: ID 104 Class not Registered Error: 0x80040154 In the eventlog EventID 3114 is…
How to modify SSIS "Flexible File Source" character limit
Hello everyone, I use SSIS to pour CSV data into a database. I use the "Flexible File Source" package to get data from Azure Blob Storage. When trying to do that with a rather big CSV file, I got one of my values that got truncated. I did a bit…
How to fix error: 26 - Error Locating Server/Instance Specified
How to fix it, this is my own computer. When I first open it, it works. But when I re-open it, it didn't with the same setting!