SQL Server Database Engine

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.

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 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 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…

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…

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…

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

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 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…

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…

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):…

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…

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 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…

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 collation issue while doing replication

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…

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

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++…

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