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.
447
questions
0
votes
0
answers
193
views
Connection String requires AttachDbFilename property
I'm trying to use SQL Server LocalDb to store the database by connection string. During first connection to the database I have an error about connecting to the database. In SSMS it is opening. To fix ...
0
votes
0
answers
149
views
Windows server localdb issue
I'm trying to deploy a database to a Windows Server machine.
The database is a SQL Server LocalDB. When I deploy it to a Windows machine, everything works correctly. When I try to deploy the same ...
- 2,267
2
votes
2
answers
10k
views
Proper Shutdown of SQL Servers in a Cluster
I was just wondering what the best approach should be for shutting down an Active/Active Cluster where both nodes need to be shutdown for disk maintenance.
I was thinking of this process:
Open ...
- 2,201
0
votes
2
answers
1k
views
SQL 2012 Availability Group issue - The core cluster resources do not move when we initiate AG fail-over
I have a Windows 2012R2 cluster with two nodes and a File Share quorum. I am running SQL 2012 SP2 and I have configured a test AG with a dummy database.
When I fail-over the AG, the Availability ...
0
votes
0
answers
74
views
Create logins for all active directories groups named ("Domain Users"), related to current Windows Authenticated user in SQL Server
I need to get all active directories locations, related to current machine, by SQL script to create logins for them. Is there a way to perform that? For now I wrote such procedure:
USE [master]
GO
...
- 16.2k
1
vote
0
answers
158
views
User Permissions for WAL files
I'm setting up replication on Postgres. (expect more questions later :-)
I'm putting the WAL files on the NAS so that both servers have access to the files.
The Postgres service is running as "...
- 111
0
votes
1
answer
1k
views
pg_restore error when using the --single-transaction: options c/--clean and -a/--data-only cannot be used together (even so the -a flag was not used)
I met a strange PostgreSQL (v.13.8) on a Windows server 2019 machine today when trying to restore a custom dump file.
The following command worked:
pg_restore -d postgres://postgres@localhost:5432/...
- 39.8k
0
votes
1
answer
4k
views
Installing SQL Server 2008 R2 Express on Server 2012 - Could not load file or assembly
I'm trying to install SQL Server 2008 R2 Express Edition SP2 on Windows 2012 server.
The error is:
Any clue?
- 2,201
0
votes
0
answers
1k
views
What can cause cyclical CPU spikes on a SQL Server precisely every 5min
Setup
Microsoft SQL Server 2008 on Windows Server 2008 (Yes I know I need to upgrade).
The server is accessed by a single Linux/Apache web server.
Problem
Starting about a week ago and slowly getting ...
- 343
0
votes
1
answer
66
views
Dell Server Raid 1 drive quick replacement with 2 exact copies
Apologies if I am posting this to the wrong place.
We are unfortunately having to handle our own server administration in-house and no one here is an expert at servers in any way! (we are web app ...
- 46.5k
0
votes
1
answer
3k
views
This operation returned because the timeout period expired - unable to add third node to existing Windows Failover Cluster
I have a Windows failover cluster up and running, with two nodes.
I'm now trying to add a third node:
Add-ClusterNode -Name node3
this unfortunately fails with the following error:
The clustered ...
- 113
1
vote
2
answers
80
views
Reinstalling server and SQL Server database
Due to some Windows issue, can't clean-up the WinSxS folder and the Disk Space process (cleanmgr.exe) makes the CPU going to 100% meaning that I am at 97% of disk usage, I am planning to reinstall the ...
- 16.2k
0
votes
0
answers
87
views
Remove requirement to specify [default] MS SQL port in vb and vbscript connection strings
I need to 'swap' an old database server (Windows Server 2008, SQL Server 2005) with a newer/better one (Windows Server 2012, SQL Server 2008) I tested this swap yesterday and everything worked on the ...
- 629
1
vote
2
answers
3k
views
Not enough server storage is available to process this command - RESTORE DATABASE is terminating abnormally
First a little description of the system that I'm seeing the problem on:
My firm has a regularly scheduled restoration of a database from backups of another, I won't go into the business reasons for ...
- 3,540
0
votes
1
answer
241
views
Software to help automate windows os patching with SQL Server high availability/failover clusters [closed]
is there a third party tool or a way to automate installing windows updates on windows clusters with sql server high availability groups installed? right now we have a manual process of installing ...
- 3,367
1
vote
2
answers
850
views
Performance of the same MySQL database is different on different servers
I have two servers:
Server A: AMD Epyc 7371 - 16c / 32t - 3.1 GHz / 3.8 GHz 256 GB ECC 2400 MHz 2 × 960 GB NVMe SSD MySql 8.0.26
Server B: Dual Intel Xeon Gold 6242R - 20c / 40t - 3.1 GHz / 4.1 GHz ...
- 84k
0
votes
0
answers
604
views
Postgresql as clustered role in Windows Failover Cluster
I am looking to implement a Highly available postgres cluster with automatic failover in a 2 node Windows cluster.
Can we configure it similar to active passive SQL Server FCI with shared storage ...
4
votes
2
answers
11k
views
Cannot install Sql Server 2019 on Windows Server 2022
On a brand new install of Windows Server 2022 standard, I am trying to install SQL Server 2019.
I downloaded the eval version, put my key in and proceeded to install the Database Engine. Default ...
- 3,145
4
votes
1
answer
1k
views
Microsoft SQL server storage best practice on Windows server vm with hybrid storage
I have a windows server VM, with a combination of HDD and SSD storage, the SSD storage capacity is limited to 50 GB, but HDD storage capacity is high.
What is the best way to share these storages to ...
- 37.5k
0
votes
0
answers
2k
views
SQL Server Launchpad Service keeps shutting down
We have a problem with the Launchpad Service shutting down and doesn't come back up. The service is has startup type "automatic", but when the server is restarted, or the sevice is stopped ...
- 101
0
votes
1
answer
166
views
SQL Server Access Database in Filesystem
We have a Windows Server 2008 which is offline. We no longer have access to the server OS, or any GUI tools, but we do have a backup of the entire C:/ of this server.
This server used to host an SQL ...
- 164
1
vote
0
answers
317
views
Windows Suspending PostgreSQL Process
Scenario:
Customer’s system
VM running Windows Server Standard 2019, 16GB RAM, Intel Xeon Gold 5122 @ 3.6GHz (2 processors 4 virtual processors)
PostgreSQL starts and runs fine for 5 minutes - 2 ...
- 121
0
votes
1
answer
1k
views
Intermittently failover of my SQL Server resources on Windows Server 2016
I have 2 Windows 2016 VM's running on Vmware ESXi VMware ESXi, 6.7.0, 17700523 with VMDK's as the SQL disks.
I have a SQL 2017 AlwaysOn Cluster running on Server 2016.
Basically everything is pointing ...
- 1,088
0
votes
0
answers
221
views
mysql takes too long to restart (Large Database)
I have a large db ( >20gb ). and since the maintenance downtime by our service provider this morning, I had tried to start the mysql but its been 7 hours. then I kill the service using task manager ...
- 1
0
votes
2
answers
458
views
Always On Failover Cluster Instances (FCI) on existing SQL Server
I have launched three EC2 Windows_Server-2019_SQL_2019_Standard instances. How can I implement Always On Failover Cluster Instances (FCI) on these existing SQL Servers. I can only find details like ...
3
votes
4
answers
13k
views
MySql service on Windows won't start after changing datadir
Tried to change the data directory for a default Windows installation of MySQL. Here's the steps I've taken.
Stopped the MySql service.
Located the data directory of MySql and moved it to another ...
0
votes
1
answer
125
views
Enabling EFS on FileStream Folders
Please help me on below:
Below is my Environment:
Windows Server 2012 R2 Standard
SQL Server 2014 SP2 GDR
Availability Groups 2014 with 3 Node (2 Sync and 1 BCP async)
I have 7 Databases with ...
- 70k
3
votes
0
answers
120
views
SQL Server should I format with ReFS to get rid of operating system error 665? [duplicate]
I have 13 production SQL Servers
Microsoft SQL Server 2016 (SP2-CU11) (KB4527378) - 13.0.5598.27 (X64) Nov 27 2019 18:09:22 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on ...
- 2,029
0
votes
1
answer
763
views
SQL server resets UDP port 1434 connections
Attempting to connect to a named instance on SQL server.
Attempt is made in port 1434 (SQL Browser)
PCap shows the connection acknowledged and reset.
SQL Browser service is running
TCP/UDP port 1434 ...
- 46.5k
1
vote
1
answer
641
views
MariaDB on Windows Server 2012 R2 - out of memory
I have two servers, one with Windows Small Business Server 2008 and the other runs Windows Server 2012 R2. The servers have running multi-master replication. Both use MariaDB 10.2.6. In the old 2008, ...
3
votes
5
answers
13k
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 ...
0
votes
0
answers
618
views
How to schedule a job using windows task scheduler to export data from potgresql eriodically into CSV file.?
I am facing an issue even after following all the steps as suggested in the answer provided by Neil Mcguigan for the question asked In the above link
I was getting an error - "psql: f_sendauth no ...
- 1
-1
votes
2
answers
4k
views
Sql Server Error 18452 The Login Is From An Untrusted Domain [closed]
I have two MS SQL databases under the same server: I connect normally to one of them using MS SQL Server Management Studio with Windows Authentication but when I try to connect to the other I get the ...
1
vote
0
answers
103
views
Testing SQL connections with UDL file
I am testing SQL connectivity between a SQL server (windows server 2000) and client PC that has no SQL tools installed (windows 2000 SP4). The client PC runs a java application that needs to connect ...
- 75
0
votes
1
answer
217
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 ...
- 2,029
0
votes
1
answer
119
views
Windows 2008 R2: Unable to upgrade MySQL 5.5.58
We have MySQL 5.5.58 sitting on a Windows 2008 R2 box.
I have downloaded the Installer from https://dev.mysql.com/downloads/mysql/ but nothing happens when I try and upgrade.
At the installer screen, ...
- 8,267
1
vote
4
answers
776
views
Does restarting Windows restart the SQL Server?
Doesn't restarting Windows also restart the SQL Server?
Long story is that I just made the change so that both SQL Server and Windows authenticated users can log in. The server needs a restart for the ...
- 23
1
vote
2
answers
36k
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 ...
- 31
0
votes
1
answer
153
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 ...
- 413
2
votes
3
answers
2k
views
Best use of RAM for multiple SQL instances?
I have a new Windows Server 2016 box with 32GB of RAM, it will be used for dev testing by one or two users max. There will be occasional use of VM/Hyper-V instances and a couple of IIS test sites ...
- 21
1
vote
1
answer
935
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 ...
- 509
0
votes
2
answers
1k
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/...
CommunityBot
- 1
2
votes
1
answer
1k
views
GSSAPI on MariaDB
I'm using Maria 10.2.13 on Windows Server 2012 and I want to use GSSAPI authentication with it so that we can continue using windows auth.
I have followed this tutorial:
https://mariadb.com/kb/en/...
CommunityBot
- 1
0
votes
1
answer
716
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 ...
- 4,450
0
votes
0
answers
221
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 ...
- 29
0
votes
1
answer
470
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) ...
CommunityBot
- 1
1
vote
0
answers
403
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 ...
- 11
5
votes
1
answer
1k
views
SQL Server 2014/2016 (Win2K12R2) and Winsock limits - how to cope?
We're experiencing a problem with connections to SQL Server and after a week of digging through I was able to pinpoint it to Winsock limits. Here's the description:
We have SQL Server 2014 (and 2016) ...
- 1,471
10
votes
4
answers
6k
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] = ...
- 7,939
12
votes
3
answers
56k
views
Moving SQL Server to different domain
What are best practices/important steps when the Windows Server machine hosting SQL Server 2008 R2 is moved to another domain? What steps definitely/might need to be done for SQL Server before and ...
- 473