17,980 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

SQL connection to server error

After i installed Microsoft SQL server i face this problem while trying to connect ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
asked 2024-05-03T11:36:23.5666667+00:00
Mohamed El Sayed Mohamed 20 Reputation points
commented 2024-05-03T21:55:16.3066667+00:00
Mohamed El Sayed Mohamed 20 Reputation points
0 answers

Error creating SQL user accounts from external provider with Azure Arc

When trying to create user accounts that use Azure login in Azure Arc, we receive the error shown in the user's image. How can we resolve this issue?

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
325 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.
12,755 questions
asked 2024-05-03T12:16:54.9066667+00:00
AJ Copeland 0 Reputation points
commented 2024-05-03T21:36:15.92+00:00
Erland Sommarskog 101.4K Reputation points MVP
0 answers

How do I transfer an on-premises license from one corporate user to another?

I need to transfer an on-premise license, but I'm having trouble finding materials explaining the step-by-step process, as well as which instrument should be used for the transfer. Can You help me?

Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,770 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.
12,755 questions
asked 2024-05-03T12:29:56.53+00:00
Takeo Contao Abe TERNIUM BR 0 Reputation points
commented 2024-05-03T21:35:32.0933333+00:00
Erland Sommarskog 101.4K Reputation points MVP
0 answers

Is there any way to connect Hadoop to SSMS other than ODBC Driver.

We have jobs in SSMS. We are experiencing ODBC Error constantly when the job fails. but we could see other job which are running with same ODBC Driver its succeeding. To avoid this issue, we want to know is there any other way that we can connect Hadoop…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
asked 2024-05-03T13:12:37.4933333+00:00
KANCHI BIANCA (CRGL-THIRDPARTY.COM) 5 Reputation points
commented 2024-05-03T21:33:54.8833333+00:00
Erland Sommarskog 101.4K Reputation points MVP
3 answers

how troubleshoot SqlDumpExceptionHandler: Process 113 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process

We use Cumulative Update 21 for SQL Server 2019, Always on with 1 Primary plus 2 secondary replicas. Recently we noticed our SQL Server had some dumps, like below. Can anyone pls help advise how troubleshoot it? Thanks SqlDumpExceptionHandler: Process…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
asked 2024-05-02T02:52:39.4733333+00:00
Ted Yin 0 Reputation points
commented 2024-05-03T21:23:43.5233333+00:00
Erland Sommarskog 101.4K Reputation points MVP
2 answers

Named Pipes Provider: Could not open a connection to SQL Server

Hi, Named Pipes Provider: Could not open a connection to SQL Server error (53) from public facing Server to Local SQL Server but Local to DMC Server possible Please any one can you advice to me Kind Regards R.Raja

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
asked 2024-05-02T05:30:16.5+00:00
Raja Raju 0 Reputation points
commented 2024-05-03T21:19:36.4333333+00:00
Erland Sommarskog 101.4K Reputation points MVP
2 answers

How to fix NT AUTHORITY\ANONYMOUS LOGON login failure during MS SQL Server installation

Hi - I'm trying to install MS SQL Server on Microsoft Windows Server 2022 Standard 10.0.20348 Build 20348. I've tried installing both MS SQL Server 2019 and 2022. The installation fails with: Detailed results: Feature: 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.
12,755 questions
asked 2024-05-02T14:35:00.5566667+00:00
Lemons, Terry 1 Reputation point
answered 2024-05-03T21:13:26.81+00:00
Erland Sommarskog 101.4K Reputation points MVP
2 answers One of the answers was accepted by the question author.

Unable to add a index hint to a simple query

I have a table with milions of records CREATE TABLE documents ( id bigint primary key, external_system nvarchar(50), external_docid nvarchar(50)) and non clustered filtered unique index CREATE UNIQUE INDEX documents_ix19 ON…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,554 questions
asked 2024-05-02T07:44:45.3166667+00:00
Jan Vávra 251 Reputation points
commented 2024-05-03T20:56:33.33+00:00
Erland Sommarskog 101.4K Reputation points MVP
0 answers

Do ODBC Linked Servers (MariaDB) support XA Transactions?

My setup involves 3 servers, 2 MariaDB servers -- one under my control, the other not -- and an MSSQL server. I have the two MariaDB servers linked via the Spider Engine and I have my internal MariaDB server set up as a linked server in Sql Server 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.
12,755 questions
asked 2024-05-03T20:31:26.51+00:00
Evan Howlett 0 Reputation points
5 answers

How to fix, Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.

We have setup the domain controller. Two machines (Windows Server 2019 Standard, 10.0.17763) are added to the same domain(Mac1 and Mac2). From Mac1, we are trying to connect remotely to SQL Server 2019 installed on Mac2. We are using Mix mode…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
asked 2023-05-12T07:33:52.4566667+00:00
Manjusha Shinde 0 Reputation points
answered 2024-05-03T20:17:00.09+00:00
Bruce (SqlWork.com) 56,686 Reputation points
1 answer

Enterprise Report Server not showing Data Driven Subscriptions

We have updgraded from Standard to Enterprise reporting services. We were expecting to have the option to create data-driven subscriptions but the option is not available. All the articles found during our web search say 'Data-driven subscriptions' will…

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,806 questions
asked 2024-04-29T21:26:46.1566667+00:00
Linda 1 Reputation point
commented 2024-05-03T19:04:52.9266667+00:00
Linda 1 Reputation point
9 answers

How to verify if a backup "*.bak" is encrypted?

Is there a way to verify if the sql server backup file is encrypted or not? I have a script to turn off encryption before backup; however, I like to verify the backup file *.bak is in fact NOT encrypted before I send out to vendor.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
asked 2021-08-18T13:54:49.39+00:00
CharlieLor 551 Reputation points
commented 2024-05-03T15:29:26.2566667+00:00
Jaime Smith 0 Reputation points
1 answer One of the answers was accepted by the question author.

Problem with FINDSTRING in SSIS Expression

Best regards. I have a problem when I am trying to use the FINDSTRING function in SSIS of Visual Studio 2022. It gives me the following error, even when I try to use the reference examples from the Microsoft page…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,455 questions
asked 2024-05-02T21:57:47.1666667+00:00
Jorge Hernán Ramírez Jaramillo 20 Reputation points
commented 2024-05-03T15:00:17.74+00:00
Jorge Hernán Ramírez Jaramillo 20 Reputation points
2 answers

Using SSDT on a build server

I need to use SSDT on my build server. What exactly do need to install to get it working? I have a docker image that does the builds. It's based on mcr.microsoft.com/dotnet/framework/sdk:4.8-20230110-windowsservercore-ltsc2019Ideally, it would be nice…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
970 questions
asked 2024-04-24T19:26:26.72+00:00
Mark DeMichele 0 Reputation points
answered 2024-05-03T12:26:48.4933333+00:00
Mark DeMichele 0 Reputation points
2 answers One of the answers was accepted by the question author.

Unable to install Microsoft SQL server 2022

Hi, Recently, I was trying to install Microsoft SQL Server, but the installation stops and this problem appeared I found a summery.txt file in this direction [C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log] and that's what was on it: …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
asked 2024-04-29T22:50:10.5966667+00:00
Mohamed El Sayed Mohamed 20 Reputation points
accepted 2024-05-03T11:30:34.9566667+00:00
Mohamed El Sayed Mohamed 20 Reputation points
1 answer

Scripting out 'Create Merge Replication' does not include 'processing_order'

We use Merge Replication and have defined a specific 'processing_order' for the Articles in the Publication. When we want to setup or refresh a test environment, we will script out the 'Create Replication' script from our production environment, such…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
asked 2024-05-03T03:20:20.6466667+00:00
Greg Youdale 5 Reputation points
answered 2024-05-03T08:56:00.9833333+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
2 answers

Connect to Linked Server Database using Azure Data Factory

Hi! I have a database that is a linked server of another. I can connect and copy data of the main database in ADF. But is it possible to also copy data from the linked server database? If yes, how would I do this?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,599 questions
asked 2024-05-02T09:28:02.6766667+00:00
Keren Osler 40 Reputation points
answered 2024-05-03T06:33:44.53+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
2 answers

SQL Licensing for SQL Always ON Availability group

Hello Guys, I need to understand how many licenses i need to buy for SQL always on availability group, below is my requirement. As per my understanding only active cores should be licensed SQL always on cluster    Primary site:   Server 1 : Active copy  …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
asked 2024-05-02T06:33:28.6+00:00
mohammed arifuddin 25 Reputation points
answered 2024-05-03T01:56:27.6566667+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
1 answer

sql query where with condition

Hi, I have a query same but only one of the where clauses differ. If (@accountID = 100) Begin select field1, field2 FROM table1 left outer join table 2 where status = 'x' and ISNULL(accountid, @accountID) = @accountID END Else select field1,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 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.
43 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,554 questions
asked 2024-05-02T22:32:38.0266667+00:00
Spunny 326 Reputation points
edited the question 2024-05-03T01:35:39.6133333+00:00
CosmogHong-MSFT 23,321 Reputation points Microsoft Vendor
3 answers

How to set title of pdf in report builder

We have an issue with PDF files generated by SSRS for reports created in Report Builder. The files have weird looking names/titles when opened with the built-in PDF viewer in Chrome etc. Some searching returned a thread saying that Chrome displays 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,806 questions
asked 2022-03-10T13:44:14.387+00:00
Anonymous
answered 2024-05-02T22:28:17.48+00:00
MargieLC 1 Reputation point