18,485 questions with SQL Server-related tags

Sort by: Updated
1 answer

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

I tried to install it, and then after a few minutes i get this error: Unable to install SQL Server. Exit code (Decimal): -2147467259 and those is logs files. Summary_DESKTOP-GDTULCG_20240703_221010.txt Detail.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.
13,188 questions
asked 2024-07-03T19:36:17.05+00:00
Ali Azzam 0 Reputation points
answered 2024-07-03T19:57:02.54+00:00
Erland Sommarskog 105.1K Reputation points MVP
2 answers

MSSQL$MICROSOFT service won´t start automatically after a Win server 2022 restart

I have a client with a Win Server 2022 (10.0.20348) and a SQL server. It turns out that SQL service will not start automatically after a restart. Now, while a restart on a server does not happen every day, I would like to know if there's a way to fix…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,188 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,510 questions
asked 2024-07-02T16:21:01.23+00:00
Matias G. Keib 0 Reputation points
commented 2024-07-03T19:07:27.19+00:00
Matias G. Keib 0 Reputation points
0 answers

Unable to send message from Azure SQL to Service Bus

The goal is to send messages to Service Bus from Azure SQL Server. I have added the Managed Identity to the queue with the Azure Service Bus Data Owner permission. When I run the code to set up the credential, there is no error. OPEN MASTER KEY…

Azure Service Bus
Azure Service Bus
An Azure service that provides cloud messaging as a service and hybrid integration.
577 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.
13,188 questions
asked 2024-07-03T18:31:40.7866667+00:00
Spencer Thompson (Network) 0 Reputation points
edited the question 2024-07-03T18:37:32.7333333+00:00
Spencer Thompson (Network) 0 Reputation points
3 answers One of the answers was accepted by the question author.

Installing MSSQL on Surface Laptop 7 with Snapdragon

I know there's been questions in the past when the ARM based MacBooks launched but now that Microsoft is shipping more ARM devices with the new Surface Pro and Surface Laptop is there any updated way to install and run MSSQL? Is Docker still the best…

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,996 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.
13,188 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,769 questions
asked 2024-07-03T15:08:36.85+00:00
CandidKilsborne 0 Reputation points
commented 2024-07-03T17:14:58.47+00:00
CandidKilsborne 0 Reputation points
1 answer One of the answers was accepted by the question author.

Can I install SQL Server 2022 Express on Surface Pro 11?

After installing SQL Server 2022 Express on Surface Pro 11, the instance cannot start correctly.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,188 questions
asked 2024-07-02T09:27:48.32+00:00
zxm9501 zxm 0 Reputation points
commented 2024-07-03T16:45:43.8566667+00:00
Erland Sommarskog 105.1K Reputation points MVP
3 answers

Choose columns during migration when using SSMA

Is it possible to select specific columns when we migrate data from source to target in SSMA? Basically, I am getting error while migrating table data which contains computed columns in source side. So I was looking for either excluding the column…

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.
507 questions
asked 2021-02-09T19:57:55.623+00:00
Siddhesh Manjrekar 1 Reputation point
commented 2024-07-03T15:43:13.9766667+00:00
Pinky Rajan 0 Reputation points
3 answers One of the answers was accepted by the question author.

SQL Server command permission levels

Our COBOL IO modules use SQL Server commands to access table data. We are migrating to a new server and decided to tighten security by giving users minimum level permissions. This caused an issue because all of our IO modules use the TRUNCATE command 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.
13,188 questions
asked 2024-07-02T13:10:17.5033333+00:00
Stephen Schleyer 60 Reputation points
accepted 2024-07-03T14:50:57.3166667+00:00
Stephen Schleyer 60 Reputation points
1 answer One of the answers was accepted by the question author.

Monitor Azure Arc-enabled Server Availability

Is there a way to monitor Arc-enabled Server availability using Azure Monitor? There is no metric alert available for arc servers. We tried using resource health alert but it is not triggered when the servers are stopped manually. Tried KQL based on…

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,962 questions
Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
366 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.
13,188 questions
asked 2024-07-03T10:25:28.4233333+00:00
SujinaSJ-1789 271 Reputation points
edited a comment 2024-07-03T14:44:02.9933333+00:00
SujinaSJ-1789 271 Reputation points
4 answers

Index Rebuild

I read somewhere that in index rebuild, sql server first creates new index and then drops old on. Is it correct? OR it drops the old index and then creates new index?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,188 questions
asked 2024-07-01T15:15:18.72+00:00
Chaitanya Kiran 776 Reputation points
commented 2024-07-03T12:53:26.68+00:00
Rahul Randive 9,011 Reputation points Microsoft Employee
0 answers

Opening the SQL "database" with the given login is not possible when utilizing Windows authentication without a username and password.

Machine A and Machine B are the two machines I own. My Java-based application server is on machine A, while my SQL server is on machine B. Both computers are logged in as the same domain user, Administrator, and are part of the 'TEST' domain. Machine B…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,188 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,510 questions
asked 2024-07-03T11:40:23+00:00
Arivazhagan A 0 Reputation points
commented 2024-07-03T12:02:22.9466667+00:00
Erland Sommarskog 105.1K Reputation points MVP
0 answers

SQL Server is terminating because of fatal exception c0000005

Facing this SQL Server access violation error on SQL Server 2016 (13.0.6435.1) running on Azure VM during startup! Error: 17311, Severity: 16, State: 1. SQL Server is terminating because of fatal exception c0000005. This error may be caused by an…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,188 questions
asked 2024-07-03T08:08:08.9933333+00:00
Karthick 0 Reputation points
commented 2024-07-03T11:03:47.82+00:00
Karthick 0 Reputation points
3 answers

Trial period for SQL Server 2019 Evaluation ended, can I move the instance to express on the same server?

Trial period for SQL Server 2019 Evaluation ended, can I move the instance to express on the same server? I'm using it for just a test environment, but don't want to lose the work done already.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,188 questions
asked 2024-07-02T22:15:05.7633333+00:00
Justin Yandall 0 Reputation points
answered 2024-07-03T10:14:03.78+00:00
Erland Sommarskog 105.1K Reputation points MVP
2 answers

SQL connection: Target principal name incorrect

Our Developer want to upgrade his website .net 8.0 from .net core 3.1, and downloaded System.Data.SqlClient (04.8.6), Have fixed all issues in debug machine.   Problem occurs when published to the production website, has got the following error: …

Internet Information Services
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,816 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.
13,188 questions
asked 2024-07-02T07:13:14.3266667+00:00
Tommy Lau 0 Reputation points
answered 2024-07-03T09:14:17.4966667+00:00
ZoeHui-MSFT 34,836 Reputation points
6 answers

SQL Server Reporting Service Web Service URL not working

I have installed SQL Server 2019 Developer edition on my Windows 11 PC. And I installed Reporting Services also. I got the report server to say it is "Report Service Status: Started". When I try to access the Web Service URL I get an HTTP…

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,854 questions
asked 2022-11-02T02:26:26.907+00:00
Fred Schmid 6 Reputation points
commented 2024-07-03T06:47:11.4833333+00:00
Sonali Kurdekar 0 Reputation points
0 answers

System Database Backups for Azure SQL Managed Instance

I don't see the ability to backup system databases for Azure SQL Managed Instance. If the server was lost I would lose server logins, backup information. Is there any documentation regarding why we don't have to backup these databases, and the steps we…

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.
13,188 questions
asked 2024-06-21T20:35:16.1766667+00:00
Chancellor, Joe 0 Reputation points
commented 2024-07-03T05:41:20.5+00:00
ShaktiSingh-MSFT 14,201 Reputation points Microsoft Employee
2 answers

MSSQL REPLICATION CONFIGURATION ISSUE

I have two sql instaces one is AWS SQL 2022 version and another on premises sql 2017 version. AWS SQL we have to keep it as subriber with distributor means pull replication On premices we have to keep it as a publisher . Both are different domains we…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,188 questions
asked 2024-06-26T10:22:18.5533333+00:00
jestadi bala 0 Reputation points
commented 2024-07-03T05:36:30.7466667+00:00
MikeyQiaoMSFT-0444 1,505 Reputation points
3 answers

Why can't I install SQL server 2022 express edition?

I am using VMware fusion pro on my m2 macbook in order to run windows so I can use the windows version of visual studio 2022 for a school project. I need to use winforms and connect it to a database. When I try and download SQL server 2022 express…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,188 questions
asked 2024-06-28T23:11:53.34+00:00
Angelos Pappas 0 Reputation points
commented 2024-07-03T05:36:00.8633333+00:00
MikeyQiaoMSFT-0444 1,505 Reputation points
1 answer

How to add article back to a replication, the destination table is already existing and has data. I think it is previously on the replication but was untagged only from the publication but did not drop the article properly on te subscriber how to sync it

How to add article back to a replication but the destination table is already existing and has data. I think it is previously on the replication but was untagged from the publication and was not drop the article on the subscriber. How to properly sync…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,188 questions
asked 2024-07-02T21:13:18.8333333+00:00
Michelle Urbano 20 Reputation points
answered 2024-07-03T05:34:46.9666667+00:00
LucyChenMSFT-4874 2,825 Reputation points
1 answer

How to import images from folder to SQL server.

How to import images from folder to SQL server.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,188 questions
asked 2024-07-03T04:37:15.3466667+00:00
nn 0 Reputation points
answered 2024-07-03T04:53:33.4566667+00:00
Olaf Helper 42,761 Reputation points
7 answers One of the answers was accepted by the question author.

Microsoft SQL Server Studio - Dark Mode

Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?

Azure SQL Database
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,816 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.
13,188 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,591 questions
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR 125 Reputation points
commented 2024-07-03T04:42:42.13+00:00
Harsh Sugandhi 0 Reputation points