45 questions with SQL Server Database Engine tags

Sort by: Updated
0 answers

Not able to see database roles above image while am tring add roles like db reader

Not able to see database roles above image while am tring to add roles like db reader.

SQL Server Database Engine
asked 2025-03-20T10:41:25.5566667+00:00
Anandhswarupp 125 Reputation points
2 answers One of the answers was accepted by the question author.

After upgrading to Windows 11, the Sql Server crashes.

I had originally a Sql Server 2019 version. After upgrade, it didn't start. I uninstalled it and installed Sql Server version 2022. But this version is also unable to start. I tried to run it in a single user mode without any success. One weird…

SQL Server Database Engine
asked 2025-03-19T15:27:08.08+00:00
Jan Vávra 386 Reputation points
edited a comment 2025-03-20T08:21:23.9466667+00:00
Jan Vávra 386 Reputation points
0 answers

SQL Server 2022 Oops... Error decompressing SQL Server media

Hello, I am trying to install SQL Server 2022 for the first time, but it gives me this error. I spent about 10 days to find the main cause of this problem and try to solve it, but it seems that is a new one. I tried to: remove .exe installation file…

SQL Server Database Engine
asked 2025-03-19T05:34:13.0433333+00:00
Mahmoud Khaled 0 Reputation points
commented 2025-03-20T05:07:52.5433333+00:00
Mahmoud Khaled 0 Reputation points
1 answer

SQL Server 2022 CU18 Crashing with EXCEPTION_ACCESS_VIOLATION

SQL Server 2022 CU18 is experiencing crashes approximately 1-2 times a month since installation. The error log shows the following message: 2025-03-18 08:20:04.77 spid70 SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005…

SQL Server Database Engine
asked 2025-03-18T23:00:19.1266667+00:00
Anonymous
commented 2025-03-20T03:21:12.9366667+00:00
Anonymous
0 answers

How do I connect to the AOAG secondary via the AG Listener through the SSH tunnel from the internet?

Hi all, I have configured a multi subnet AOAG SQL Servers with a AG Listener on Azure. Within the local internal network, I can connect via the AG Listener and it properly route me to the primary or secondary server based on my ApplicationIntent…

SQL Server Database Engine
asked 2025-03-19T19:09:57.53+00:00
Link 5 Reputation points
commented 2025-03-20T00:03:00.6033333+00:00
Link 5 Reputation points
3 answers

Clarification on SQL Server Developer and Standard Licenses

Hello everyone, I need some clarification regarding SQL Server licenses. I am currently using SQL Server Developer for development and testing. I was told that I can only use this version once for system testing, otherwise, I need to switch to the normal…

SQL Server Database Engine
asked 2025-03-19T10:42:42.94+00:00
Anonymous
answered 2025-03-19T22:52:08.76+00:00
Erland Sommarskog 119.8K Reputation points MVP
3 answers

How to upload a file to Azure support?

I am trying to connect to a SQL Managed Instance from my desktop using SSMS. See the attached screenshot. ssms-screenshot.pdf

SQL Server Database Engine
asked 2025-03-12T20:07:21.7466667+00:00
Mike Yother 0 Reputation points
commented 2025-03-19T22:42:07.8966667+00:00
Oury Ba-MSFT 20,526 Reputation points Microsoft Employee
1 answer

How do you update replication secrets in a database?

I have a Dev server running SQL Server 2019 Enterprise configured for replication. I patched the server from SQL 2019 CU 27 to CU 32. After restoring the database being used for replication, I ran a script to re-establish the replication. When I ran…

SQL Server Database Engine
asked 2025-03-19T20:35:00.4833333+00:00
Kevin Feit 0 Reputation points
answered 2025-03-19T22:34:14.77+00:00
Erland Sommarskog 119.8K Reputation points MVP
1 answer

[SQL Server 2019 Standard]Order history now shows, but missing download link and product key

Hello, I'm still experiencing issues with a recent purchase from the Microsoft Store. Initially, I mentioned that I hadn't received a confirmation email and the order wasn't appearing in my order history. I can now see the order in my purchase history on…

SQL Server Database Engine
asked 2025-03-18T10:59:51.46+00:00
kataoka 0 Reputation points
answered 2025-03-19T22:27:55.9133333+00:00
Erland Sommarskog 119.8K Reputation points MVP
0 answers

SSMS Object Explorer Details context menu scarcely populating

In SSMS object explorer details, when I view object explorer details and click on the headers row, the context menu shows only name and Policy Health status. Most of my tables only have a couple of columns (I'm only just starting on SQL), but said…

SQL Server Database Engine
asked 2025-03-18T03:33:52.9633333+00:00
JP_BW 40 Reputation points
commented 2025-03-18T22:54:56.4466667+00:00
Erland Sommarskog 119.8K Reputation points MVP
1 answer

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

Hello< I have been trying to dowload SQL server 2022 developer version but there is this error all the time. I tried different things to fix it but did not work, can you help? Unable to install SQL Server (setup.exe). Exit code (Decimal):…

SQL Server Database Engine
asked 2025-03-18T03:05:32.63+00:00
Don Nando 0 Reputation points
answered 2025-03-18T22:51:24.8333333+00:00
Erland Sommarskog 119.8K Reputation points MVP
1 answer

Issues with converting existing data Column Collation Using ALTER TABLE and Copy-Replace Methods in SQL Server

Hi All, I'm encountering issues while attempting to change the collation of a column in SQL Server using the methods described in Microsoft's documentation but it is changing the existing data. Specifically, I've tried both the in-place conversion and…

SQL Server Database Engine
asked 2025-03-18T06:42:11.7666667+00:00
Mathan Kumar 0 Reputation points
commented 2025-03-18T22:45:19.8066667+00:00
Erland Sommarskog 119.8K Reputation points MVP
1 answer

Using SSMS SQLCMD to connect to Azure SQLDB via Entra Auth

I am struggling to find a way to connect to an Azure SQL SB, via SSMS: SQL Server Management Studio 20.1.10.0 I have used: :connect <Servername> -G The response is: A fatal scripting error occurred. Incorrect syntax was encountered…

SQL Server Database Engine
asked 2025-03-18T14:42:34.2366667+00:00
Salah Mahmood 0 Reputation points
answered 2025-03-18T22:08:05.9766667+00:00
Erland Sommarskog 119.8K Reputation points MVP
1 answer

SQL server question

Trying to help a small business with their server and SQL server after their IT person retired. I have some advanced knowledge of IT but am learning as I go as well. Before I did anything with the server, they were not able to sign into the OS of the…

SQL Server Database Engine
asked 2025-03-18T18:29:04.22+00:00
Pointerguy 0 Reputation points
answered 2025-03-18T21:59:31.1666667+00:00
Erland Sommarskog 119.8K Reputation points MVP
2 answers

error sql installation

Good afternoon. I have a problem about the installation of the program. I have tried to install the program more than 20 times and i have not been able to. I´ve been getting multiple errors where some components couldn´t be installed correctly. I´ve…

SQL Server Database Engine
asked 2025-03-17T22:23:41.7966667+00:00
Ara 0 Reputation points
commented 2025-03-18T21:47:10.83+00:00
Erland Sommarskog 119.8K Reputation points MVP
3 answers One of the answers was accepted by the question author.

SQL server collation issue while doing replication

SQL Server Database Engine
asked 2025-03-12T19:23:34.1766667+00:00
Saikiran Avanigadda (INFOSYS LIMITED) 20 Reputation points Microsoft External Staff
commented 2025-03-18T21:02:46.8066667+00:00
Erland Sommarskog 119.8K Reputation points MVP
1 answer One of the answers was accepted by the question author.

Transactional Replication in AlwaysOn - Update SQL from 2019 to 2022 for a distributor

Hello. Question about the correct order of updating MS SQL Server which acts as a distributor for transactional replication. The scheme looks like this, there is an availability group AlwaysOn which consists of two nodes, for some databases in…

SQL Server Database Engine
asked 2025-03-17T16:11:27.1333333+00:00
edited a comment 2025-03-18T12:00:30.7266667+00:00
0 answers

Number of databases in availability groups in enterprise sql server 2022 / 2025

I have in production for a SaaS company, 4 vm with sql server enterprise in failover cluster. In each server I have 600/700 databases. Can I migrate to an scenario with availability groups? Thanks

SQL Server Database Engine
asked 2025-03-18T08:09:06.4666667+00:00
Andres Blanco 0 Reputation points
0 answers

Why does this statement take so much longer on a faster machine?

I am using VS2022 and Basic. I am finding that when the compiled EXE is run on an old APP Server with old Visual C++ Redistributables that this statement runs acceptably fast, but if I run the same EXE on a new APP Server with current Visual C++…

SQL Server Database Engine
asked 2025-02-28T15:36:23.58+00:00
Torquinian 1 Reputation point
edited the question 2025-03-18T01:11:16.6266667+00:00
Jiachen Li-MSFT 33,946 Reputation points Microsoft External Staff
1 answer

Linked server is accessing system databases temp and master

Hi, I have created a linked server for two user databases, but the linked server is accessing the system databases also. is there way to restrict the linked server not to access system databases. Thank you

SQL Server Database Engine
asked 2025-03-17T19:44:24.1166667+00:00
Newtojob 66 Reputation points
answered 2025-03-17T22:35:32.8066667+00:00
Erland Sommarskog 119.8K Reputation points MVP