19,780 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
4 answers One of the answers was accepted by the question author.

SQL Server 2022 Dev Edition Installation error

Hello everyone. I'm having issues trying to install SQL Server 2022 Developer Edition on my machine. This is for an assignment from school so this is the first time I'm dealing with SQL. The issue is that the Database Engine Service is not installed…

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,276 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
10,399 questions
asked 2025-01-09T01:59:26.16+00:00
Guillermo Ezequiel Chehda 0 Reputation points
commented 2025-01-11T16:11:49.4733333+00:00
Erland Sommarskog 115.1K Reputation points MVP
0 answers

SQLBindParameter/SQLExecute returns SQL_NO_DATA on second iteration

Hi, ALL, I'm trying to run the following scenario: std::wstring query = L"INSERT INTO abcattbl SELECT ?, ?, (SELECT object_id FROM sys.objects o, sys.schemas s WHERE s.schema_id = o.schema_id AND o.name = ? AND s.name = ?), '', 8, 400, 'N', 0, 0,…

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,276 questions
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,818 questions
asked 2025-01-11T07:13:46.6766667+00:00
Igor Korot 6 Reputation points
edited the question 2025-01-11T15:52:33.44+00:00
Igor Korot 6 Reputation points
2 answers

Unable to install SQL Server. Exit code (Decimal): -2147467259"

I've got the summary and i was wondering if you could help read it. i got the "Unable to install SQL Server. Exit code (Decimal): -2147467259" Detail.txt Summary.txt

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,276 questions
asked 2025-01-10T04:15:10.17+00:00
Marcos Yukihiro VIEIRA YAMASHITA 0 Reputation points
edited a comment 2025-01-11T14:48:39.5+00:00
Erland Sommarskog 115.1K Reputation points MVP
1 answer

SQL Server Stored Procedure oddity

Ok, so we have a stored procedure that has been in production for at least 3 years and working find. Last night the oddest thing happened. We have tried to normalize data about people, so we have one table that contains all ids a person may have in…

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,276 questions
asked 2025-01-10T23:31:50.3833333+00:00
Mark Gerow 0 Reputation points
answered 2025-01-11T10:34:03.7266667+00:00
Erland Sommarskog 115.1K Reputation points MVP
0 answers

error code - 1073741724

error code - 1073741724.when starting SQL server helper. That service does not start

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,276 questions
asked 2025-01-11T07:16:36.2066667+00:00
Deepa Seetharaman 0 Reputation points
commented 2025-01-11T10:02:47.3066667+00:00
Erland Sommarskog 115.1K Reputation points MVP
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,276 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.
126 questions
asked 2025-01-10T16:33:39.5933333+00:00
Sean 0 Reputation points
commented 2025-01-10T22:12:05.82+00:00
Sai Raghunadh M 1,760 Reputation points Microsoft Vendor
2 answers

SSMS Installation

I have tried multiple things but not able to install ssms

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,276 questions
asked 2025-01-10T12:25:22.86+00:00
Vishal Sharma 0 Reputation points
answered 2025-01-10T22:11:22.3866667+00:00
Erland Sommarskog 115.1K Reputation points MVP
2 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,276 questions
asked 2025-01-10T20:25:30.6466667+00:00
Voldman, Eliya 0 Reputation points
answered 2025-01-10T22:02:29.89+00:00
Erland Sommarskog 115.1K Reputation points MVP
2 answers One of the answers was accepted by the question author.

How to Verify the Signed Status of a CLR Assembly with Asymmetric Key in SQL Server

CLR Strict Security is enabled - User databases have TRUSTWORTHY as OFF  In this scenario all CLRs are treated as unsafe and will not function, unless they are added to the trusted_assemblies or have an asymmetric key.  They have seen many issues with…

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,276 questions
asked 2025-01-09T22:07:20.7666667+00:00
Vanitha Dodla (MINDTREE LIMITED) 60 Reputation points Microsoft Vendor
commented 2025-01-10T21:46:42.9766667+00:00
Erland Sommarskog 115.1K Reputation points MVP
1 answer One of the answers was accepted by the question author.

Backup certificate WITH PRIVATE KEY error create on other instance

Hi, I'm having trouble performing a backup of a certificate and subsequently restoring it on another server. I'll share the entire syntax. It's not clear to me whether I need to open the MASTER KEY on the source server. I created a share at C:\TDE where…

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,276 questions
asked 2025-01-09T22:46:07.7033333+00:00
Alen Cappelletti 1,017 Reputation points
commented 2025-01-10T21:34:05.06+00:00
Erland Sommarskog 115.1K Reputation points MVP
1 answer

How to Register 2 Iaas Sql Server Instances in an Always On Availability Group configuration to recovery services vault

I have 2 Azure VM's and installed SQL Server on both and create an Instance on in an Always On Availability Group. The 2 vm's are not clustered that it there is no WSFC so the failover process is a manual. I am configuring this Instance to backup to a…

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,334 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,276 questions
asked 2025-01-07T14:32:53.7533333+00:00
Asare, Kwabena (ZA) 0 Reputation points
commented 2025-01-10T17:10:06.9333333+00:00
Oury Ba-MSFT 19,991 Reputation points Microsoft Employee
0 answers

SQL Server on mac

Is there a way to use a SQL Server on Mac? I tried using Docker and Azure Data Studio but I'm blocked at the last step by a error message. Many seems to have faced the same issue.

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,276 questions
asked 2025-01-10T16:56:17.62+00:00
Vincent Demers 0 Reputation points
0 answers

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,276 questions
asked 2025-01-10T13:05:06.25+00:00
GP 16 Reputation points
commented 2025-01-10T15:58:24.1866667+00:00
GP 16 Reputation points
3 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,276 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,184 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,141 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,801 questions
asked 2025-01-03T00:29:43.2+00:00
Krishna Basavaraj K S 0 Reputation points
answered 2025-01-10T15:55:04.94+00:00
NIKHILA NETHIKUNTA 4,010 Reputation points Microsoft Vendor
3 answers

SSMS Import of MS Access accdb external component has thrown an exception (System.Data)

I've been using SQL Server Management Studio for some time to import tables from MS Access into SQL Server. Now I get an error External component has thrown an exception. (System.Data) when I choose an Access database to import from. This worked only 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,276 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
424 questions
asked 2024-12-10T09:58:07.5066667+00:00
Richard Williams 10 Reputation points
answered 2025-01-10T12:20:15.0066667+00:00
Richard Williams 10 Reputation points
1 answer

SQL Server timeout exception azure hyrbrid connection

We have a Web application with Azure functions, a web app and an API manager. SQL database is located on an on-premise SQL database server. Functions apps connecting on-premise database via Azure hybrid connection. Suddenly we got the following 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,276 questions
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
1,036 questions
asked 2025-01-08T09:03:51.95+00:00
Amal Edirisinghe 0 Reputation points
edited an answer 2025-01-10T11:35:40.52+00:00
Shree Hima Bindu Maganti 1,620 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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,626 questions
asked 2025-01-03T14:05:24.3466667+00:00
D2d3d4d5 20 Reputation points
commented 2025-01-10T11:18:51.2533333+00:00
D2d3d4d5 20 Reputation points
3 answers

Unable to acquire authorization token (ConnectionDlg.AadInteractiveAuthProvider) with "Azure Active Directoy - Universal with MFA" to Azure SQL server when SSMS is run as my privileged account

This works fine from another system, or if I log on to the laptop directly with my privileged account. I need to run SSMS as my privileged account, because that's the only account that has been authorized to connect to our Azure SQL servers &…

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
7,677 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,276 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,801 questions
asked 2024-10-07T14:33:49.44+00:00
Dom-Su BoChum 20 Reputation points
answered 2025-01-10T11:02:21.05+00:00
Eric Nwaogwugwu 0 Reputation points
0 answers

Subscription

Hi all, I hv a question about SSRS subscription under mssql 2022 STD, I saw when i subscript to a report, it will create a job under SSMS jobs. I would like to manage the report subscription not run on the specified date store in some table in the…

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,967 questions
asked 2025-01-10T09:50:11.9933333+00:00
Joey Tsui 0 Reputation points
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,220 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,276 questions
asked 2025-01-06T04:56:22.5866667+00:00
Mohana Reddy 80 Reputation points
commented 2025-01-10T08:48:42.06+00:00
Vijayalaxmi Kattimani 905 Reputation points Microsoft Vendor