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
1 vote
2 answers
154 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 ...
user avatar
0 votes
0 answers
30 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 ...
user avatar
4 votes
1 answer
185 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 ...
user avatar
  • 251
0 votes
0 answers
160 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 ...
user avatar
  • 101
0 votes
1 answer
46 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 ...
user avatar
0 votes
0 answers
141 views

ORA-12152: TNS: unable to send break message - Only LISTENER restart works

i have a strange problem with our Oracle 12.1.0.1.0 on our VM Windows Server 2016. I create a daily batch script whichs creates a dump file (via EXP) and execute some sql statements (via SQLPlus). ...
user avatar
  • 11
1 vote
0 answers
51 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 ...
user avatar
0 votes
0 answers
28 views

Oracle - one port for native network encryption traffic and one for non-encrypted

I need to expose my oracle database to a remote server, and want to require encrypted traffic for that machine (while not affecting my existing connections.) My thought is to use one port for ...
user avatar
  • 236
1 vote
1 answer
159 views

SQL Server 2017 AlwaysOn Failover Cluster issue

I have 2 Windows 2012R2 VM's running on Vmware ESXi 7 with VMDK's as the SQL disks. I have a SQL 2017 AlwaysOn Cluster running on Server 2012R2. there is no any running backup (SNAPSHOT) PROD : 10....
user avatar
  • 1,048
0 votes
1 answer
289 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 ...
user avatar
  • 1,048
0 votes
0 answers
48 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 ...
user avatar
4 votes
2 answers
3k 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 ...
user avatar
  • 41
0 votes
2 answers
90 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 ...
user avatar
3 votes
0 answers
108 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 ...
user avatar
0 votes
1 answer
148 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 ...
user avatar
  • 1
0 votes
1 answer
81 views

SSRS migration with Same Name and Moving of Reporting Files

This is will be my first SSRS migration and please bear with me if some points don’t make any sense. I need to migrate the Reporting server but need to keep the same name so that the reporting URL don’...
user avatar
  • 1,007
0 votes
0 answers
117 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 ...
user avatar
  • 1
0 votes
1 answer
154 views

How to create SQL Server backup from Windows Server to Linux Client with SQLCMD?

I've got sqlcmd installed on an Ubuntu LTS instance and I'm able to connect successfully to Windows SQL Server and do queries and such. sqlcmd -S 192.168.0.100 -U SA -P secret I need to be able to ...
user avatar
  • 101
1 vote
0 answers
26 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 ...
user avatar
  • 75
0 votes
1 answer
36 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, ...
user avatar
  • 194
1 vote
4 answers
154 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 ...
user avatar
1 vote
1 answer
99 views

DBCC Check DB fails due to operating system error 665

We have a SQL Server 2017 Standard version where recently the CHECKDB is failing with the operating system error 665. The fragmentation level of the disk drive is 0% as it is automatically ...
user avatar
  • 1,007
0 votes
1 answer
25 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 ...
user avatar
0 votes
1 answer
126 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.
user avatar
0 votes
1 answer
65 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 ...
user avatar
  • 1,920
1 vote
1 answer
337 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 ...
user avatar
0 votes
1 answer
106 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 ...
user avatar
  • 1,007
0 votes
0 answers
68 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 ...
user avatar
0 votes
1 answer
127 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 ...
user avatar
1 vote
0 answers
226 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 ...
user avatar
0 votes
1 answer
343 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 "...
user avatar
0 votes
3 answers
69 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 '...
user avatar
  • 111
4 votes
3 answers
1k 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 ...
user avatar
  • 326
6 votes
2 answers
720 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\...
user avatar
  • 61
1 vote
1 answer
5k 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.
user avatar
0 votes
1 answer
45 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....
user avatar
0 votes
0 answers
43 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....
user avatar
0 votes
2 answers
2k 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 ...
user avatar
  • 101
1 vote
0 answers
2k 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: ...
user avatar
  • 397
4 votes
1 answer
692 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 ...
user avatar
  • 403
-1 votes
1 answer
36 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 ...
user avatar
  • 11
4 votes
1 answer
93 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 ...
user avatar
  • 1,007
1 vote
2 answers
50 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 ...
user avatar
0 votes
0 answers
186 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 ...
user avatar
0 votes
0 answers
32 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 ...
user avatar
  • 1,881
0 votes
1 answer
47 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 ...
user avatar
  • 1,005
0 votes
2 answers
459 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/...
user avatar
0 votes
1 answer
117 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 ...
user avatar
0 votes
0 answers
187 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 ...
user avatar
0 votes
1 answer
250 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) ...
user avatar

1
2 3 4 5
9