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
31 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
22 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
35 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
12 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
43 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
20 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
24 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
104 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
22 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
58 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
0answers
43 views

Preferred owner failover change in FCI

I've inherited a few Windows servers with SQL Server installed. Some of them are in failover cluster which is perfect in case of outages. However I do not have much experience with SQL Server ...
0
votes
0answers
24 views

PostgreSQL 10 not archiving some WAL files

I have a strange case in some PostgreSQL that I monitor. First the software versions and setup: Windows Server 2012 Foundation PostgreSQL 10.10 x64 archive_command = 'copy %p "D:\\backup\\wal\\%f" /y'...
0
votes
1answer
536 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 ...
0
votes
2answers
71 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
58 views

Microsoft Data Migration Assistant Failing

I am using the Microsoft DMA to migrate data from a Microsoft SQL Server 2012 instance into a Microsoft SQL Server 2017 instance. I get all the way to the final step of selecting logins, start the ...
0
votes
0answers
17 views

Fixed Orphaned Users on 2nd Node, but 1st Node Users Permissions Changed [duplicate]

For context: My environment consists of two Windows Server '19 boxes with SQL 2017 running in an AlwaysOn High Availability & WSFC configuration. I have run into an issue where several login ...
0
votes
0answers
86 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 "...
1
vote
0answers
154 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 ...
0
votes
0answers
11 views

Error when creating cluster for Domain Always On setup

Below are the details of the setup: 2 nodes on the same domain, same network (subnet) Firewalls are off. Windows Server 2012 R2 I have been encountering error which I am not familiar. I cannot see a ...
9
votes
4answers
2k 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
61 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 ...
0
votes
0answers
36 views

Is It Possible Backing Up Postgres Backups To Windows Backup Server With PgBackRest

I want to take my postgres backups to our backup backup server which works on windows server, with pgbackrest. My postgres databases are on CentOS/7 OS. I can take those backups to my local but i want ...
2
votes
2answers
134 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
30 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
522 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, ...
1
vote
2answers
420 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)...
0
votes
0answers
24 views

SQL Server Service has stopped, but process still appears in TaskMgr

A customer has the strangest situation. Windows Server 2016 with SQL Server 2016. There is only one SQL instance on the machine (the default). Service name: MSSQLSERVER. The service take a very long ...
2
votes
0answers
71 views

SQL Browser Service Stops After One Minute

I am encountering an issue with the SQL Browser service where the service will start, run for around 60-90 seconds and then stop. No error is logged, the event logs show three informational entries: ...
-2
votes
2answers
125 views

Unable to install SQL Server Express 2014 on Windows Server 2008 R2

I'm trying to install SQL Server Express 2014 on Windows Server 2008 R2. But the setup routine is giving me the warning message: System doesn't meet the minimum requirement for installing SQL ...
0
votes
0answers
8 views

Windows 2016 server with .NET version 3.5 having issue with connecting to mongo 3.0 replicaSet

We have a mongo server version 3.0 and driver version 1.11.0.92 and windows server 2016. I see other posts related to this but our code works well in Windows 2008 server with mongo version 3.0 and ...
1
vote
4answers
2k views

Windows Logs Application is full of “Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: ****]”

I have Windows Server 2016, with SQL Server 2017, and found Windows Log Application is full of Login failed messages (as follows) : Login failed for user 'sa'. Reason: Password did not match that ...
1
vote
1answer
768 views

MySQL Workbench, Windows Server 2019, MySQL not showing Performance, Information of MySQL Schemas!

This evening I installed MySQL on a new clean install of Windows 2019 server. When the install finished, the installer offered the possibility of opening Workbench so I said yes. Then I noticed that ...
0
votes
1answer
66 views

Windows Server and SQL Server updates and patching - and how to rollback (revert) if necessary

Say we have a server as SQL Server 2017 on Windows Server 2016, both have some pending updates recently Below few questions: What's the correct order of installing updates - first Windows, and then ...
-1
votes
1answer
11 views

Postgresql Error

I found below errors in logs , Transaction stop logging in my database 2019-11-19 15:48:25 UTCERROR: could not open file "base/16384/16464.3" (target block 858400): No such file or directory 2019-...
2
votes
0answers
169 views

ODBC Driver Manager Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303) - Windows Server 2012 R2

I have a problem with adding MySQL server via linked server to my SQL Server Database Following this instruction unfortunately just does not work out for me. I added four data sources, 2 using 64-...
3
votes
2answers
167 views

SSMS cannot connect remote server by IP through Windows authentication

I'm trying to connect a remote server by IP,port via Windows authentication. It will end out with the following error Connection Timeout Expired. The timeout period elapsed while attempting to ...
1
vote
0answers
226 views

Is it possible to reset SA password without stopping SQL Server Service?

I lost a password for sa account. Now I want to reset SA password and at the same time not to restart SQL Server Service or going into single-user mode. I would like to mention that I am windows ...
0
votes
1answer
28 views

Why does a fresh SQL Server instance with the same details as the original think that my DB backup is in the original location?

So I'm working on a server application for a large government body and need to setup a development environment to test on. For this I'm using a Vagrant-controlled VM with Windows Server 2019 installed ...
0
votes
1answer
223 views

SQL server agent unable to establish connection [closed]

I have recently installed sql server 2014 enterprise version on windows 2016 server. For some reason sql server agent is not starting but sql server service is up and running. I am not really sure ...
0
votes
2answers
128 views

SQL Server 2016: Granting security to do everything but read / write data

We have an offshore support team coming online to support our servers as DBAs for 24x7 support. However, there are several instances that have a limitation due to contracts that limit offshore access ...
2
votes
2answers
88 views

SQL Server on Windows Server (VMware) - online storage swap

I have a VM cluster designed to store multiple SQL Server instances. We use variety of storage providers (i.e. 3PAR, XIV) which have to be changed now (not relevant to what brand). On Oracle on Linux ...
3
votes
0answers
58 views

Moving from dynamic disk allocation to direct space disk via storage pool in SQL server

Pardon me if I am not clear in asking the question since I have very less understanding from storage terms used or how it's used with Sql server. Currently our storage team is testing to move disk ...
0
votes
0answers
10 views

Can two or more versions of MongoDB run concurrently as Windows services?

I'm working on two .Net projects which use different versions of MongoDB (3.4 and 4.0). By using separate data and log directories (as per this article) I can run both versions concurrently on demand ...
1
vote
1answer
11 views

Impact of changing server machines names with SQL Server 2016 Standard in mirror state

It's an enterprise network domain. Two existing Windows server 2016 machines, one each for SQL Server 2016 Standard edition and other is also SQL Server 2016 Standard edition in a passive mirror ...
0
votes
0answers
195 views

Not able to add a node into windows failover cluster

I had two node cluster but due to disk corruption one node was removed. After maintenance when second node came back we tried to add it into the cluster but getting exception. I checked the even log ...
1
vote
0answers
210 views

Win 2019 + SQL Server 2014 slowly locks up the server

We have a 2019 + 2014 sql server box that was running fine for a few days after we first stood it up on Ec2. After a week I removed a temp drive (EBS) that we had initially used to load up the ...
0
votes
0answers
19 views

PostgreSQL Active Directory authentication logins contain a period

PostgreSQL newbie here. I am trying to set up a PostgreSQL server to integrate our active directory credentials. I can edit the pg_hba.conf file to allow users with an internal IP to connect with OS ...
0
votes
1answer
257 views

High CPU usage on fresh new install of MongoDB

I read a lot of post about high CPU usage of Mongo but almost all relates to queries. I just did a fresh install of MongoDB 4. I have no other databases than the default one. As soon as I start the ...
0
votes
0answers
11 views

Backup size keeps growing more then data is added

A schema grows daily, more then data is added. According to table sizes the data in the tables is 2750. The tables spaces are as follows: In storage management is see: Name#Size#Available#...

1
2 3 4 5
8