Questions tagged [windows-server]

All versions of Windows Server. Please also add a version-specific tag like windows-server-2012 if that is relevant to the question.

Filter by
Sorted by
Tagged with
0
votes
1answer
18 views

Upgrading Operating System only. OS 2016 - 2019

Currently we have a number of Servers that are using Windows 2016 with SQL Server 2017. The support team want to do an in-place upgrade of the OS to 2019 due to 2016 Mainstream support ending in Jan ...
0
votes
1answer
26 views

The Windows Server Failover Clustering (WSFC) resource control API returned error code 19

What is root cause of this error. I couldn't find any related information. There are two nodes on Availability Group and if you reboot second node, database wont up.
0
votes
1answer
11 views

MySQL on Windows Refuses to Start as a Service

I am trying to install MySQL 5.7.33 onto a windows 2012 server. A process I have done many many times. I have copied the Zip file onto the server and expanded it into G:/mysql57/ (the same zip file I ...
0
votes
0answers
14 views

Reporting & Logging Failing on SQL Server Job

System Info: SQL Server 2014 Enterprise, Windows Server 2012 R2, running on a VM I have a Maintenance Plan set up to perform a log backup of a database every 17 minutes. The job normally runs fine ...
1
vote
1answer
50 views

SQL Server Cluster and Windows Server Storage Replication

I am currently investigating on how to setup a SQL Server stretch cluster in combination with storage replication for which I want to use Windows Server Storage Replication. However, I am no sure on ...
0
votes
1answer
42 views

SQL Server License Migration [closed]

We need to move our SQL Server 2016 standard License. Our plan is to install SQL Server on the new box with the same license key , test the application / databases and then delete the old SQL server ...
0
votes
0answers
24 views

Oracle 12cR2 - Upgrade Catalog Command Taking Too Much Time

I patched my database (Windows database bundle patch 12.2.0.1.201020 (31654782)). There are 6 instances on the server. After the patch, the UPGRADE CATALOG command I ran on RMAN for the first 5 ...
0
votes
1answer
80 views

High Latch Wait time with Logon trigger enabled while full backups are running

I have 14 production servers with SQL 2016 standard version, 128 gb of RAM, 16 CPU and SSD drives. Microsoft SQL Server 2016 (SP2-CU15-GDR) (KB4583461) - 13.0.5865.1 (X64) Oct 31 2020 02:43:57 ...
1
vote
0answers
60 views

What are the available automatic failover solutions for MariaDB Master-Slave replication on Windows Server?

I am setting up a Master-Slave or Master-Master setup in MariaDB on two seperate servers running Windows Server. I also need to configure an automatic failover solution where client read requests gets ...
0
votes
1answer
47 views

local administrator does not have permissions to create database in db2

I have a fresh standard installation of DB2 11.5 on Windows server 2016. According to documentation, i need the to have SYSADM or SYSCTRL to create a new Database. The documentation for "...
0
votes
3answers
66 views

How can I make queries secret?

I have a project whose activity I need to keep private, and I'm not the server administrator. If my app updates a value for the user with id 1, it would probably say something like UPDATE 'users' SET '...
4
votes
3answers
700 views

SQL Server - Benefits of splitting databases across different logical drives

We're about to start a project to migrate a large DWH to new physical servers in a new data centre. The current server spec is SQL Server Enterprise 2016 SP2 running on Windows 2012 R2. The new ...
0
votes
0answers
32 views

Yet Another error 10054 after disabling TLS 1.0

We've got: SQL Server 2012 SP4-OD 11.0.7469.6 running on Windows server 2012 R2 Build 9600 with .NET Framework 3.5.30729.4926 installed, while SPN registers perfectly at SQL Server startup. That ...
6
votes
2answers
261 views

Intermittent SQL Delegated Authentication Errors

Here is an odd issue that is causing me to lose all my hair. Every few days or so our delegated authentication from one SQL server to another fails with the error: Login failed for user 'NT AUTHORITY\...
0
votes
0answers
21 views

SQL Server HA Design (FCI) - Windows Storage Replication - Test-SRTopology - Physical Memory Error - AWS EC2

I'm trying to set up AlwaysOn Failover Cluster Instance (Not Availability Groups) on 2 VMs(each on different AWS Availability Zone) in AWS-EC2 instances. To make this happen, I've to set up Windows ...
0
votes
1answer
198 views

Can we enable tls 1.0 on MSSQL Server 2019 on database level? if yes then how?

i am running sql server 2019 on Linux box and trying to connect using a Windows server 2016 client, how can we enable TLS 1.0 for SQL Server 2019 on the Database/instance level. TIA.
0
votes
1answer
44 views

SQL Server 2017 Always-ON

I have configured Distributed AG from DC1 to DC2 (SQL 2017 Ent edition with CU22 version) DC1- DB1, DB2 and DC2-DB3, DB4 I have restarted DC1-DB1 SQL services, after restart DC1-DB2 should be primary....
0
votes
0answers
50 views

Postgresql Performance Diagnostic

I am trying to activate Performance Diagnostic on a Postgresql 12 advanced server from PEM on a windows 10 machine. I am trying to install EDB Wait States module by changing the postresql.conf and ...
0
votes
0answers
40 views

Changing domain, can't connect [duplicate]

I have a server that hosts a SQL Server 2017 Entreprise Edition database. I changed domain on the server (e.g. attds.mg in fdsqq.mg). The problem is that I can't connect my application to the database....
0
votes
2answers
388 views

Error 0xc000007b with Oracle 19c

As our (32-bit) application uses the Oracle client for communication with the Oracle server I have set up a test environment on a Microsoft Windows Server 2019 Datacenter. I have installed the Oracle ...
1
vote
0answers
910 views

“The client and server cannot communicate, because they do not possess a common algorithm” error

The full error message is: System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: ...
4
votes
1answer
353 views

How do I prevent my Windows Server from being automatically rebooted by SQL Server updates?

Some SQL Server updates have happened outside the maintenance window, which have caused the server to be rebooted. How can I stop this from happening again in future? Below is what I can see when ...
-1
votes
1answer
35 views

SQL alwayson AG Disaster Recovery

Need advise on below: I have 2 node alwayson AG on Primary Sync mode in the current configuration and fsw is in Primary DC only Actually during Switchover the entire DC 2 node and fsw will be down ...
4
votes
1answer
54 views

Active Directory Name Change

Our Active directory will change the accounts name for example John Doe Jdoe@abcd.com to John.Doe@abcd.com. My question is do I need to change all the SQL Logins individually or the person can login ...
0
votes
0answers
13 views

How to create hs oracle to SQLSERVER with rac scan

hi i am trying to create an hs for oracle rac for a course but i am unable to configure the hs How to configure the listener with scan_listener? hs example: odbc windows64 bits system dns: ...
1
vote
2answers
48 views

Diagnose slow script executions on specific server

I work with an unmanaged server in a remote datacenter to host web based applications. When we run the SQL scripts to create and populate an application database the whole process is painfully slow. A ...
0
votes
0answers
76 views

Removing a Windows Server Cluster Node and Then Adding Back - Do I need to remove the Availability Group replica?

We had a secondary server bite the dust... we were remarkably able to resurrect it. Everything is great and intact... except for the windows server cluster configuration. We basically need to evict it ...
0
votes
0answers
30 views

How to troubleshoot slow connection issues from SSMS? [duplicate]

I right click on a server in the Registered Servers pane and select New Query. Sometimes (like 1 out of 3), it will just hang for 5-15 seconds with the Connect dialog (below). Other times, it ...
0
votes
0answers
23 views

MSSQL Mirai Botnet, cleaned but connects again using ANOYNMOUS LOGON

well this problem is making me go nuts my server was hacked with the Mirai Botnet, we cleaned the system, Disabled the Server Agent completely and the system is stable and clean BUT... if i re-open ...
0
votes
1answer
37 views

Backup up database to compressed local folder - what will be the performance implication?

I have sql server 2016 web edition on Windows 2016 server VM. I want to backup the database, to a folder on a local drive (SSD) - please don't ask why, long story. Due to the size of the DBs, and ...
0
votes
2answers
116 views

How do you configure a 4-node AlwaysOn cluster to have two listeners?

Looking to build a 4-node (servers A, B, C & D) AlwaysOn Windows 2016 failover cluster with 2 nodes in the primary datacenter for HA, and 2 other replica nodes in the DR datacenter for disaster/...
0
votes
1answer
58 views

Distributed Always-On without Domain

We have a requirement to configure a distributed availability group from Data center1 to Data Center2 using SQL Server 2017 Enterprise Edition. DC1 (two nodes WSFC setup): SQLDB1, SQLDB2 DC2 (two ...
0
votes
0answers
51 views

How to remediate the TLS_RSA_WITH_SEED_CBC_SHA on Debian and TLS_RSA_WITH_3DES_EDE_CBC_SHA (SWEET32) on Windows?

I'm in a class right now and we're given two servers to setup and secure. We are supposed to use Greenbone Vulnerability scanner and report/fix what it finds. My windows server is vulnerable to ...
0
votes
0answers
93 views

PostgreSQL errors and big database

Let's start from point that I have been introduced to PostgreSQL only a couple days ago after I received alert from monitoring system that one of local discs on one of VMs if almost full. After ...
0
votes
1answer
102 views

Query on Linked Server in SQL Active-Passive

We have plan to implement Active-Passive SQL server cluster with shared storage with SQL 2014 version. A-P: There will be two DB servers (DB1 and DB2) and one will be working (DB1) and the other (DB2) ...
0
votes
0answers
25 views

How does sql server FCI respond to failure?

Taking windows role default settings - (n-1) failovers ok within 6 hrs , where n=# of nodes, if nodes = 2, 1 failover within 6 hrs is allowed. Taking resource default settings - Within 15mins period, ...
0
votes
1answer
417 views

SQL Server 2017 password complexity rule

SQL and Windows version: Microsoft SQL Server 2017 (RTM-CU19) (KB4535007) - 14.0.3281.6 (X64) Jan 23 2020 21:00:04 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows ...
0
votes
0answers
89 views

How can I mount vss snapshots and why we have to do that to take backup in window server backup?

"Windows Server Backup cannot guarantee Volume Shadow Copy (VSS) snapshots are retained. In certain situations, after restoring to a new volume, the VSS snapshots may no longer be recognized and ...
1
vote
0answers
279 views

SQL server availability group cannot access database after disabling sql service

I've completed this setup: OS: Windows server 2016 Database: SQL Server 2017 2 node availability group configured with automatic failover on both nodes. Fileshare witness configured, both nodes ...
0
votes
1answer
5k views

Windows Cluster can't update DNS record

Setup: Windows server 2016 standard edition. SQL server 2016 standard edition. 2 nodes configured in a cluster without witness quorum. all member of the same Active Directory domain. 1 Availability ...
1
vote
2answers
303 views

Sql Server 2017 - Cannot shrink transaction log file, blocked by LOG_BACKUP status

Last week my sql server 2017 instance (running on windows server 2016) ran out of space, filling the disk completely up with a 190GB transaction log file. Luckily this was on a cloud instance, so I ...
0
votes
0answers
422 views

Destroy cluster windows server 2012 r2

I want know how to delete a Windows Server Failover Cluster. My case is a bit special. I encountered some problems while creating a failover cluster, and I stopped the cluster services then I did "...
2
votes
0answers
585 views

Access Denied while installing SQL server 2016 [duplicate]

I am getting the below error while installing SQL Server, when I've selected the domain account for SQL server engine startup account and press next. (11) 2020-02-16 14:58:48 Slp: Sco: Attempting to ...
0
votes
1answer
21 views

“Could not find login” failures for remote LocalSystem that exists

I imagine security changed in some way for Windows 2016, but I'm unable to determine what exactly. For context: We have a variety of remote clients that handle data processing within a (non-SQL) data ...
10
votes
4answers
3k views

Increased memory to server, but do I need to change page-file size?

I'm running SQL Server 2017 on Windows Server 2012 R2 and have increased the memory from 256 GB to 512 GB. I've noticed the following configuration for Virtual Memory: C: [OS] = 2 GB G: [DATA] = ...
0
votes
1answer
187 views

Can I use LetsEncrypt to secure SQL Server?

I am running SQL Server 2014, and use LetsEncrypt to encrypt some websites on the server. I want to remain PCI compliant, which requires an encrypted connection to the database, if accessing from ...
2
votes
2answers
475 views

PowerShell command 'New-Item' fails when invoked through SQL Server Agent job

I have the following PowerShell script to create a folder at a share location. The share has full control permissions for everyone. I have granted all permissions for testing. The problem is the ...
0
votes
1answer
36 views

MySQL DB Causing Spike-up on Windows Server CPU

This is a Magento application connected to MySQL Db. When I ran show engine innodb status\GI get a list of TRANSACTIONSand it looks like some of them are pending and others are in a DEADLOCKand it ...
1
vote
0answers
1k views

What are the risks if you rename a server that hosts a named instance of SQL Server (2005) and skip updating the system metadata?

My apologies as this is the last SQL 2005 instance we have and it's pretty urgent or I wouldn't go through all this trouble asking. Questions What is the risk to leave things as they currently are, ...
2
votes
2answers
2k views

How can I create a Windows Firewall rule to allow only one IP address to connect MS SQL 2017 Express database in Windows 2016 server?

I use MS SQL 2017 Express database in Windows 2016 server, now my MS SQL 2017 express server is being attacked. I hope to set a Windows Firewall rule to allow only one IP address (such as 45.23.56.12)...

1
2 3 4 5
9