19,788 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
3 answers

Usage of SQL Server Schema Compare v1.21.0 extention

Hello, I am using ADS: Version: 1.50.0 (system setup) Commit: 49c73a84388731fec941dac8d938345ac16bd470 Date: 2024-11-17T22:41:05.327Z VS Code: 1.82.0 Electron: 30.5.1 Chromium: 124.0.6367.243 Node.js: 20.16.0 V8: 12.4.254.20-electron.0 OS: Windows_NT x64…

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,283 questions
asked 2025-01-10T20:25:30.6466667+00:00
Voldman, Eliya 0 Reputation points
commented 2025-01-13T21:57:51.2633333+00:00
Erland Sommarskog 115.3K Reputation points MVP
2 answers One of the answers was accepted by the question author.

Can the MSSQL JDBC driver connect to a SQL SERVER using a GMSA account?

Is it possible for the MSSQL JDBC driver to connect to a SQL SERVER using a GMSA account? If it is, what should the connection string look like? Can the connection URL include the GMSA account name, such 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,283 questions
asked 2023-10-20T09:20:34.7466667+00:00
Chiru 25 Reputation points
commented 2025-01-13T21:51:37.3266667+00:00
Erland Sommarskog 115.3K Reputation points MVP
0 answers

Measure grand total

Hi community, I work with report builder, I trying to calculate grand total, but I don't make a correct calculation. The Source is actually semantic model in power bi service, I have on semantic model this dimensions: Country, City and measures : stock,…

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,283 questions
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,969 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,283 questions
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,969 questions
asked 2025-01-13T20:35:23.1966667+00:00
Pedro Quiroz 0 Reputation points
0 answers

Measure grand total

Hi community, I work with report builder, I trying to calculate grand total, but I don't make a correct calculation. The Source is actually semantic model in power bi service, I have on semantic model this dimensions: Country, City and measures : stock,…

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,283 questions
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,969 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,283 questions
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,969 questions
asked 2025-01-13T20:35:23.1966667+00:00
Pedro Quiroz 0 Reputation points
1 answer One of the answers was accepted by the question author.

An invalid tabular data stream (TDS) collation was encountered (Not linked Server)

We just upgraded one of our sites for SQL Server 2019 and since then our software cannot write to any of the blob fields in the database. We get the following error: "An invalid tabular data stream (TDS) collation was encountered." We…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,870 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,283 questions
asked 2021-03-03T22:36:28.72+00:00
Christopher Burke 96 Reputation points
commented 2025-01-13T19:29:08.99+00:00
Jérémy Belloir 0 Reputation points
1 answer

MSSQL 2022 - SSISDB ETL returning "...failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. "

Full error from the Integration Catalog in question: SQL Load Queue List into Object:Error: Executing the query "EXEC [My PROC name]" failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to…

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,283 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,627 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,283 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,627 questions
asked 2024-12-26T16:44:24.62+00:00
Fred Bartley 0 Reputation points
answered 2025-01-13T18:10:51.1733333+00:00
Fred Bartley 0 Reputation points
1 answer

MSSQL 2022 - SSISDB ETL returning "...failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. "

Full error from the Integration Catalog in question: SQL Load Queue List into Object:Error: Executing the query "EXEC [My PROC name]" failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to…

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,283 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,627 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,283 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,627 questions
asked 2024-12-26T16:44:24.62+00:00
Fred Bartley 0 Reputation points
answered 2025-01-13T18:10:51.1733333+00:00
Fred Bartley 0 Reputation points
1 answer

Timeline for Release of NEXT GEN Feature for Managed Service in Azure

What is the timeline for the release of the NEXT GEN feature for managed service in Azure? It has been in testing since March 2024. When will it be out of preview mode for general use?

Azure SQL Database
Azure Managed Applications
Azure Managed Applications
An Azure service that enables managed service providers, independent software vendors, and enterprise IT teams to deliver turnkey solutions through the Azure Marketplace or service catalog.
157 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,283 questions
asked 2025-01-07T15:40:00.9233333+00:00
Anonymous
commented 2025-01-13T16:42:23.0033333+00:00
Mahesh Kurva 1,700 Reputation points Microsoft Vendor
0 answers

BLOB ERROR

When I run the refresh one of my tables is not mirroring its counterpart in the production database. The comment is BLOB error. What is a BLOB error. the dependent tables are fine but the parent table won't generate data.

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,283 questions
asked 2025-01-13T16:15:49.25+00:00
D.Z. McClintock 0 Reputation points
2 answers One of the answers was accepted by the question author.

Upgrading SQL server 2019 enterprise evaluation edition to SQL Server 2022 Standard

HI All, I am planning to Upgrading SQL server 2019 enterprise evaluation edition to SQL Server 2022 Standard. when I run SQL server 2022 standard installation setup upgrade edition step it is missing select instance name step and there is no option to…

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,283 questions
asked 2025-01-09T02:18:19.2966667+00:00
Newtojob 66 Reputation points
accepted 2025-01-13T15:59:46.26+00:00
Newtojob 66 Reputation points
0 answers

SQL Express Installation Issues on Windows 11 Enterprise v10.0.22631

Experiencing installation failures with SQL Express 2022 on Windows 11 Enterprise. The installation appears to work until nearly the end, where it encounters issues related to x_cpu64 type files. The installation completes but reports a failure with a…

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,283 questions
asked 2025-01-13T15:24:52.2533333+00:00
Laidlaw, Jason [EMR/MSOL/ABDN] 0 Reputation points
1 answer

I can't set up a connection to the database when installing VMM

Hello! When installing VMM on the first host, I cannot connect to the database if I specify the MS SQL cluster name. As indicated in paragraph number 8 of this…

System Center Virtual Machine Manager
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,283 questions
asked 2025-01-13T11:52:52.1733333+00:00
Maxtor007 20 Reputation points
answered 2025-01-13T13:45:51.9733333+00:00
Javier Villegas 900 Reputation points MVP
1 answer

Warning: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

This is the error message I receive when I run a SSIS package. Only one particular server is causing this issue other servers are connecting and package is getting executed. Warning: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. …

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 2024-06-19T02:01:51.49+00:00
Noopura Jaiswal 0 Reputation points
answered 2025-01-13T10:25:07.8166667+00:00
Christian Giangrande 0 Reputation points
1 answer

Issue with Creating Linked Server from Azure SQL Managed Instance to On-Premises SQL Server

Hi, Interestingly, I was able to create a linked server in the reverse direction—from the on-premises SQL Server to my Azure SQL MI—using a remote login and password for authentication. However, when I attempt to establish the link from Azure SQL MI to…

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,283 questions
asked 2025-01-10T13:05:06.25+00:00
GP 16 Reputation points
commented 2025-01-13T09:16:07.0033333+00:00
Vijayalaxmi Kattimani 905 Reputation points Microsoft Vendor
0 answers

Dynamic editing using foreach loop "Variable does not contain valid data object" and a dynamic query data flow error

Hi! I'm currently trying to create an SSIS package that dynamically acquire columns from an azure SQL database and transform it. This is my current setup: Populate column list has the following query: SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,627 questions
asked 2025-01-13T08:42:33.5466667+00:00
Blazer22 0 Reputation points
3 answers

How to merge multiple SSRS instance into one new single SSRS instance?

I'm migrating and consolidating two SQL instances into one new SQL Server 2022 instance. For user databases these are fine as I can just backup and restore them to new instance. But how about the SSRS currently running on both source instance? Each of…

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,283 questions
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,969 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,283 questions
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,969 questions
asked 2025-01-12T10:31:02.86+00:00
Marcus Wong Theen Nam 1,141 Reputation points
answered 2025-01-13T08:42:14.41+00:00
Olaf Helper 45,391 Reputation points
3 answers

How to merge multiple SSRS instance into one new single SSRS instance?

I'm migrating and consolidating two SQL instances into one new SQL Server 2022 instance. For user databases these are fine as I can just backup and restore them to new instance. But how about the SSRS currently running on both source instance? Each of…

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,283 questions
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,969 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,283 questions
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,969 questions
asked 2025-01-12T10:31:02.86+00:00
Marcus Wong Theen Nam 1,141 Reputation points
answered 2025-01-13T08:42:14.41+00:00
Olaf Helper 45,391 Reputation points
1 answer One of the answers was accepted by the question author.

How to query mssql to get weekly time interval from the first day the data was created for a period of 1 year

Hello, I am trying to write sql query to to get weekly time interval from the first day the data was created for a period of 1 year to select number of week of the current date for a particular user Id. Below is my mssql query. WITH WeeklyIntervals 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,283 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,189 questions
asked 2025-01-09T09:38:28.99+00:00
Emeka Okoye 126 Reputation points
accepted 2025-01-13T07:39:30.0866667+00:00
Emeka Okoye 126 Reputation points
1 answer

Azure Data Studio failed local connection to MSSQLSERVER Developer Edition

Hello Microsoft community members. I am having a very simple issue connecting ADS to MSSQLSERVER Developer Edition. Upon establishing the connection, I am entering the correct server and instance name (having verified through SQL Server Configuration…

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,283 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
127 questions
asked 2025-01-10T16:33:39.5933333+00:00
Sean 0 Reputation points
commented 2025-01-13T06:24:48.52+00:00
Sai Raghunadh M 1,760 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

How to fix code throwing exception : Microsoft.Data.SqlClient.SqlException: 'Login failed for user '

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,283 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,189 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,151 questions
asked 2025-01-03T00:29:43.2+00:00
Krishna Basavaraj K S 20 Reputation points
edited the question 2025-01-13T06:03:32.1033333+00:00
Raja Pothuraju 10,760 Reputation points Microsoft Vendor