19,749 questions with SQL Server-related tags

Sort by: Updated
0 answers

SSRS2022 Custom Header Problem

Hi Guys, I found SSRS2022 16.0.1116.12 Custom Headers…

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.
2,965 questions
asked 2025-01-07T02:59:18.05+00:00
Wilson Shen 0 Reputation points
2 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,302 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,302 questions
asked 2025-01-06T12:18:11.1333333+00:00
Pavan G 0 Reputation points
commented 2025-01-07T02:02:46.3733333+00:00
LiHongMSFT-4306 29,666 Reputation points
2 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,302 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,302 questions
asked 2025-01-06T12:18:11.1333333+00:00
Pavan G 0 Reputation points
commented 2025-01-07T02:02:46.3733333+00:00
LiHongMSFT-4306 29,666 Reputation points
1 answer

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…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
asked 2025-01-06T18:38:40.4666667+00:00
Brad Wolff 0 Reputation points
edited the question 2025-01-07T01:10:38.9133333+00:00
LiHongMSFT-4306 29,666 Reputation points
4 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
asked 2021-12-11T16:23:24.11+00:00
Wade Nederveld 21 Reputation points
commented 2025-01-07T00:56:29.77+00:00
Nick Ryan 231 Reputation points
3 answers

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…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
770 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,725 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
109 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,673 questions
Entity Framework Core Training
Entity Framework Core Training
Entity Framework Core: A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.Training: Instruction to develop new skills.
5 questions
asked 2025-01-06T17:02:27.0333333+00:00
P. G. Choudhury 81 Reputation points
edited a comment 2025-01-06T23:35:32.4633333+00:00
Bruce (SqlWork.com) 68,956 Reputation points
1 answer

how do i fix CVE-2024-0056

Microsoft.Data.SqlClient and System.Data.SqlClient SQL Data Provider Security Feature Bypass Vulnerability

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
asked 2025-01-06T21:33:25.2433333+00:00
Michael Cabezas 0 Reputation points
answered 2025-01-06T21:45:37.12+00:00
Erland Sommarskog 114.9K Reputation points MVP
2 answers

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…

Azure SQL Database
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.
543 questions
asked 2025-01-06T12:53:58.3333333+00:00
Patankar, Narottam 20 Reputation points
edited the question 2025-01-06T15:13:07.8633333+00:00
VarunTha 10,450 Reputation points Microsoft Vendor
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
asked 2024-11-26T09:17:17.1+00:00
Fallonne Rose 0 Reputation points
commented 2025-01-06T13:20:51.06+00:00
Fallonne Rose 0 Reputation points
2 answers

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…

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,517 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
asked 2025-01-02T10:43:46.2+00:00
RehamHossam-3731 0 Reputation points
commented 2025-01-06T11:11:19.14+00:00
RehamHossam-3731 0 Reputation points
4 answers

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…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,124 questions
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
1,029 questions
asked 2024-12-16T11:24:58.52+00:00
Ashraf Khan 20 Reputation points
accepted 2025-01-06T10:20:27.6266667+00:00
Ashraf Khan 20 Reputation points
0 answers

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,…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,025 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,168 questions
asked 2025-01-06T06:11:18.7833333+00:00
Vaibhav Pol 0 Reputation points
commented 2025-01-06T09:43:13.5333333+00:00
Erland Sommarskog 114.9K Reputation points MVP
1 answer

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.…

SQL Server on Azure Virtual Machines
Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,326 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
asked 2024-12-31T20:32:23.9066667+00:00
Neuro Alert 0 Reputation points
commented 2025-01-06T08:54:22.7833333+00:00
Vijayalaxmi Kattimani 825 Reputation points Microsoft Vendor
0 answers

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…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,168 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,124 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,733 questions
asked 2025-01-03T00:29:43.2+00:00
Krishna Basavaraj K S 0 Reputation points
commented 2025-01-06T08:27:20.2+00:00
NIKHILA NETHIKUNTA 4,010 Reputation points Microsoft Vendor
3 answers

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…

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,204 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
asked 2025-01-06T04:56:22.5866667+00:00
Mohana Reddy 80 Reputation points
answered 2025-01-06T07:32:51.3066667+00:00
Olaf Helper 45,381 Reputation points
1 answer

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 …

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.
2,965 questions
Windows Maps
Windows Maps
A Microsoft app that provides voice navigation and turn-by-turn driving, transit, and walking directions.
258 questions
asked 2025-01-03T12:56:17.8333333+00:00
Jayamurali Ganeshan 0 Reputation points
answered 2025-01-06T02:22:42.19+00:00
ZoeHui-MSFT 39,271 Reputation points
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
asked 2025-01-03T09:39:53.34+00:00
neil huang 0 Reputation points
edited the question 2025-01-06T02:09:08.8033333+00:00
neil huang 0 Reputation points
1 answer

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…

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
1,045 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
asked 2025-01-03T09:39:39.0366667+00:00
Banga, Sietse 11 Reputation points
answered 2025-01-06T01:57:19.9+00:00
LiHongMSFT-4306 29,666 Reputation points
1 answer

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,624 questions
asked 2025-01-03T14:05:24.3466667+00:00
D2d3d4d5 0 Reputation points
answered 2025-01-06T01:55:26.48+00:00
ZoeHui-MSFT 39,271 Reputation points
2 answers

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!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
asked 2025-01-04T09:47:17.1633333+00:00
Kai Lin 0 Reputation points
answered 2025-01-06T01:21:21.9366667+00:00
LiHongMSFT-4306 29,666 Reputation points