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.
436
questions
0
votes
1
answer
508
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 ...
- 1,021
0
votes
0
answers
192
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
193
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,999
1
vote
0
answers
367
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
0
votes
1
answer
798
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 "...
- 312
0
votes
3
answers
75
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 '...
- 111
4
votes
3
answers
3k
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 ...
- 326
6
votes
2
answers
1k
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\...
- 61
1
vote
1
answer
8k
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.
Rafay Pervaiz
0
votes
1
answer
48
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....
- 65
0
votes
0
answers
45
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
2
answers
3k
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 ...
- 101
1
vote
0
answers
5k
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: ...
- 427
4
votes
1
answer
1k
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 ...
- 423
-1
votes
1
answer
39
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
...
- 11
4
votes
1
answer
342
views
Active Directory Name Change
Our Active directory will change the accounts name for example John Doe [email protected] to [email protected].
My question is do I need to change all the SQL Logins individually or the person can login ...
- 1,021
1
vote
2
answers
60
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 ...
- 1,059
0
votes
1
answer
691
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 ...
- 31
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 ...
- 1,929
0
votes
1
answer
48
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 ...
- 1,005
0
votes
2
answers
978
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/...
- 611
0
votes
1
answer
255
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 ...
- 65
0
votes
0
answers
264
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
1
answer
429
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) ...
- 65
0
votes
0
answers
44
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, ...
- 21
0
votes
1
answer
3k
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 ...
- 65
0
votes
0
answers
249
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 ...
- 11
1
vote
0
answers
860
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 ...
- 11
1
vote
2
answers
33k
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 ...
2
votes
2
answers
2k
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 ...
- 123
0
votes
0
answers
1k
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
0
answers
1k
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
1
answer
25
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 ...
- 1
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] = ...
- 131
0
votes
1
answer
625
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 ...
dudeinco
2
votes
2
answers
1k
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 ...
- 522
0
votes
1
answer
73
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 ...
- 101
1
vote
0
answers
3k
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, ...
- 41
3
votes
2
answers
9k
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)...
- 129
0
votes
0
answers
336
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 ...
- 157
2
votes
0
answers
510
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:
...
- 9,842
-2
votes
2
answers
577
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 ...
Mujtaba Rizvi
3
votes
5
answers
11k
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 ...
- 185
1
vote
1
answer
1k
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 ...
- 13
0
votes
1
answer
1k
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 ...
- 5,302
-1
votes
1
answer
172
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
0
answers
667
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-...
- 21
3
votes
2
answers
917
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 ...
- 435
1
vote
0
answers
835
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 ...
- 1,243
0
votes
1
answer
178
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 ...
- 101