All Questions
Tagged with windows-server-2019 sql-server
15
questions
2
votes
1
answer
93
views
SQL Server 2019, SQL Server Agent service doesn't auto-load - error 776, token supplied to function is invalid
I noticed after a recent update to Windows 2019, our lone server running Active Directory, that several related SQL Server services were no longer starting.
After researching each of those errors, I ...
-1
votes
1
answer
571
views
How to get an IP address for MS SQL Cluster network configuration?
I just started a new internship and have been tasked to set up a SQL failover cluster. They gave me 3 virtual machines to use and when I started I knew nothing. I've been doing a lot of research the ...
0
votes
1
answer
345
views
Windows defender ransomware protection and SQL Server
Our small company has organized several levels of virus protection for Windows servers, but there are always fears that this is not enough.
Is it correct to configure Windows Defender Ransomware ...
1
vote
2
answers
2k
views
Veeam SQL Server Database Publishing Fail with unexpected error code 3
So we have been experimenting with Veeam Backup & Replication for a while now. We setup a dedicated VM for Veeam Backup Server which performs daily backups of all our infrastructure components. We ...
3
votes
2
answers
12k
views
Free up memory in Windows Server 2019 for SQL Server instance?
We have Windows Server 2019 Standard (x64) with 64GB memory.
The screenshot below shows the memory usage at 96% with the SQL Server Windows NT running and using 344.5 MB.
This is the Task Manager ...
2
votes
1
answer
422
views
SSH using public key losing Authentication on windows server
I want to SSH from my laptop (A) to Windows Server (B) and run commands against SQL Server (C) from powershell. All three in one windows domain. I'm running built-in openssh server and client for ...
0
votes
1
answer
1k
views
"Access Denied" when running SQL Server Installation Center Tools
With MS SQL Server 2019 on Windows Server 2019, I am attempting to do something pretty simple: Run the "Installed SQL Server Features Discovery Report" tool that comes in the SQL Server ...
2
votes
1
answer
722
views
Windows Failover Cluster With SQL Server
We are moving away from using VMWare over to Windows Failover Cluster (version 2019) to host our company services. I have successfully configured WFC and have a few Virtual-Machine roles running along ...
0
votes
1
answer
4k
views
Considerations for Server OS Upgrade (Win2012R2 to 2019) hosting SQL Server?
I am not a DBA so I am not well versed on the intricacies, considerations, potential issues with in-place upgrading just the OS of an existing SQL Server.
A client has several stand-alone SQL Server ...
2
votes
1
answer
12k
views
How can I check if SQL Server 2019 Standard is activated on Server Core? [duplicate]
I installed SQL Server 2019 Standard on Windows Server 2019 Core from an ISO that I downloaded from our MSDN. It specifically stated that there is "No product key required" when I downloaded ...
1
vote
0
answers
421
views
Grant database access through GPO
I have a domain in which I have couple servers with dedicated SQL Server databases. I also have couple external companies that need access to this servers and databases on different permission level (...
0
votes
1
answer
66
views
Ideal Server Deployment for Windows Server 2019 Active Directory, File Server, and SQL Server
So, we have new compliance regulations we're being required to meet and our current infrastructure isn't quite good enough to handle it.
What we need is:
2 x Active Directory Domain Controllers, DNS, ...
0
votes
1
answer
855
views
WSFC DNN Listener Resolving to secondary in Availability Group
I have an Azure AO AG which consists of three servers (all WS-2019 & SQL-2019CU3):
A - Subnet 1 - Principal Server (Sync)
B - Subnet 1 - Secondary Server (Sync)
C - Subnet 2 - Secondary Server (...
1
vote
0
answers
457
views
Best practices for updating a Windows Failover cluster / SQL Server Availability Group without using Cluster-Aware Updating
I have set up an SQL Server 2016 Availability Group inside a Domainless Windows Server 2019 Failover Cluster.
Everything runs fine at the moment, but now I am wondering what might happen if cluster ...
3
votes
1
answer
10k
views
Blue question mark on SQL server and SQL server agent?
I just installed MS SQL server 2017 on MS Server 2019. All installation process were fine. Using SSMS 18 access SQL server locally was fine, no issue at all.
But when I use SSMS 18 connecting SQL ...