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.
440
questions
0
votes
1
answer
348
views
error writing input to commandERROR: Invalid username and/or password
This is the error I have been getting on my RMAN notifcations on my backup jobs for the last day or so. The title is exactly how the message is formatted.
~~~End Step Output/Error Log~~~
Error Log:...
CommunityBot
- 1
0
votes
1
answer
65
views
Windows Power Plans for SQL Server
Is the High Performance power plan in Windows Server still relevant in SQL Server setups on modern hardware/virtualization? Searching for articles from my usual trusted sources brought up nothing more ...
- 38.8k
0
votes
1
answer
598
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.
CommunityBot
- 1
0
votes
1
answer
80
views
[ODBC SQL Server Driver][DBNETLIB] SSL Security Error - Windows 2003 App Server to Remote SQL Server 2022 Connection
We have migrated the application databases from an old SQL Server 2000 instance running on Windows 2003 to a new SQL Server 2022 instance running on Windows 2022. The application tier has a number of ...
- 652
0
votes
1
answer
745
views
Two physical servers with sql server on same network
IS there a way I can remotely access sql server DB having two different servers in the same network/public IP?
The first Server is configured to listen to 1433 port but we make the connections using ...
CommunityBot
- 1
2
votes
1
answer
408
views
Cosmos DB ODBC driver installation problem
We are trying to install Cosmos DB ODBC Driver following the instructions provided in this Microsoft Azure resource and are running into the following error:
The setup routines for Microsoft ...
CommunityBot
- 1
2
votes
1
answer
280
views
SSRS ReportServer_XXX.log is giving incorrect CPU count
I am currently investigating an issue wherein sometimes the SSRS just suddenly stops accepting requests until we do an IISRESET command. This happens after we added an additional processor on the ...
CommunityBot
- 1
0
votes
1
answer
49
views
Joining SQL 2016 to a one-node cluster that has SQL 2014 installed
I have currently 1-node (it's a lab) Windows 2012R2 cluster with SQL server 2014 installed (patched to the last patch based on sqlserverupdates.com). The goal is to upgrade the cluster
to something ...
- 30k
3
votes
1
answer
477
views
MySQL Create Table with Partition Very Slow on server machine
Following create table statement with Partition
runs in 10 Second on My Development Machine windows 7, i5 , 8GBRam, single disk
runs in 16 Second on Virtual Machine windows server 2012 , xeon 2GHz , ...
CommunityBot
- 1
-2
votes
1
answer
1k
views
What is the difference between CU-GDR and GDR?
There are 2 paths to patching SQL server. Either the SQL CU (cumulative) upgrade or GDR (critical) upgrade.
CU includes functionality fixes and security fixes (https://support.microsoft.com/en-us/...
- 3,430
0
votes
2
answers
3k
views
MySQL restrict specific login to single ip address
i am trying to setup a mysql server with some logins that can be accessed from anywhere, and another login ( effectively root access ) from a single machine with a static ip. both machines have a ...
CommunityBot
- 1
0
votes
2
answers
113
views
Adding a Windows Server 2016 computer to a Windows Server 2022 Failover cluster
Is it possible to join a Windows Server 2016 computer to an existing Windows Server 2022 2-node Failover cluster? The cluster is domain-independent.
Hypothetical setup:
Node 1 (windows server 2022 + ...
- 30k
1
vote
1
answer
895
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....
CommunityBot
- 1
0
votes
1
answer
1k
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).
...
CommunityBot
- 1
7
votes
2
answers
369
views
SQL Server 2012 - SA account probe
On one of my servers (Win 2012 R2), SQL Server 2012 is constantly under attack with the SA account being hit like 10 times per second with different passwords. I don't have an SA account but still I ...
- 2,201
2
votes
1
answer
90
views
MariaDB 11.0 to 11.1 GA fails with ERROR 1210 (HY000) at line 32: Incorrect arguments to DATA DIRECTORY
I upgraded to MariaDB 11 some time ago, and all has been working well for a long time. I saw there was a newer GA release, 11.1, so decided to update to that, but the upgrade fails. This is on Windows ...
- 41
0
votes
1
answer
3k
views
Why does max_connections in my.ini not match concurrent connections in Mysql instance config wizard?
MySQL 5.1.x | Windows Server 2003
Can someone please clarify why max_connections in my.ini is much larger than the manual value I specify in the Concurrent Connections Dialogue?
For example, if I ...
CommunityBot
- 1
0
votes
1
answer
1k
views
Why do I keep getting ORA-01033: ORACLE initialization or shutdown in progress when my database is open? (12c)
I'm running Oracle on a Windows server (maybe that is why it is so buggy?). It was working fine for a bit, but lately I've been having an issue. I keep getting the ORA-01033: ORACLE initialization or ...
CommunityBot
- 1
0
votes
0
answers
9
views
Oracle 10.2.0.4 instance won't load after system reboot on Windows 2012 R2 server
I know it's prehistoric software but I have some legacy apps that require it.
When installing Oracle database 10.2.0.4 on a Windows 2012 R2 server 64 bit system everything works perfectly until I ...
- 1
0
votes
1
answer
846
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 ...
CommunityBot
- 1
1
vote
1
answer
402
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 ...
CommunityBot
- 1
0
votes
1
answer
216
views
No connection possible after TrustServerCertificate=True => The certificate chain was issued by an authority that is not trusted
I have a machine which could connect to an MS SQL Server in the past. I have SSMS installed and the connection was possible when I activated TrustServerCertificate checkbox in SSMS. I could connect ...
- 4,260
0
votes
1
answer
18
views
On which node must the failover manager for the AG be?
I have an availability group for Windows SQL Server. It is so that instances hosting replicas must be in a Windows failover cluster. However, if the node where the failover manager is on fails, what ...
- 393
1
vote
2
answers
16k
views
Why have SQL Server services disappeared from services.msc?
I'm running an Always On Availability Group with 2 SQL Server 2014 database servers in an AD domain. Updates are supplied to all domain servers via WSUS. Also have a third MS Reporting Services server ...
0
votes
1
answer
309
views
WSFC Dynamic Quorum not removing votes
Environment is Windows Server 2019 in Azure
I have a 3 node multi-region cluster.
Server 1 & 2 are in the same region while server 3 is in a remote region.
Server 3 does not have a vote in the ...
CommunityBot
- 1
0
votes
2
answers
254
views
Postgres file increment size
I'm COPY-ing 300 tables / 400G to PG10@win2016server using a few threads to speed things up, but because the table files are incremented in 64-kb units (or something there-about) they get fragmented ...
CommunityBot
- 1
0
votes
1
answer
55
views
Tune SQL Server 2019 for receive many small queries
I am using SQL Server SE 2019, on a Windows Server 2019 (with SSD drive) that run IIS 10. On top of IIS 10 run an ASP.Net application, that has to be considered AS IS (I can't modify it).
Lately tourn ...
- 32k
0
votes
1
answer
36
views
How to monitor mysql master - slave replication in windows os and failover in event of failure of master
I have a master and 3 slave all on windows OS.
I need a tool I can use to monitor replication and failover to a slave incase the master is goes down. What tool do you recommend.
I prefer open source ...
- 55
0
votes
1
answer
274
views
MongoDB cannot be started after moving the server
I had a happy MongoDB 3.0.5 installed on a VM on a Windows 2012R2 Server, for light use. I moved the VM to a new physical server without any major changes, and to my surprise it cannot be started; and ...
CommunityBot
- 1
0
votes
0
answers
11
views
When postgreSQL Copy command execute [duplicate]
After creating a csv file in the program because a large amount of data needs to be inserted I am trying to insert into a table using the postgreSQL copy command.
However, if I put the CSV file in the ...
- 1
0
votes
0
answers
148
views
SQL Database not working after OS upgrade
Let me begin by saying I’m a noob with anything SQL.
So I was tasked to upgrade the OS on a VM running Server 2012 R2 with SQL Server 2014 Services running on it. Mainly, there is an internal website ...
- 35.1k
1
vote
2
answers
413
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 ...
- 1,170
3
votes
1
answer
304
views
Upgrading out of support Microsoft SQL instance multiple questions?
I just got a new job as an analyst but I’m being tasked with an administrator task and just looking for insight.
We have a Windows server 2003 (32bit) that has Microsoft SQL Server 2005. I have been ...
- 11.8k
0
votes
0
answers
534
views
Postgresql logical replication suddenly stop (wal status is extended, An existing connection was forcibly closed by the remote host)
I checked the replication status of our production server when i noticed that one of the replicated DB is missing (using pg_stat_replication command).
I also check the replication slots and found out ...
0
votes
1
answer
502
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 ...
CommunityBot
- 1
2
votes
5
answers
12k
views
Ola Hallengren - DatabaseBackup - LOG Unable to open Step output file. The step failed
DatabaseBackup - USER_DATABASES - LOG: This job fails saying "Executed as user: Domain\XXXX-SVC. Unable to open Step output file. The step failed."
The error is only with LOG backup job.
The other ...
6
votes
1
answer
13k
views
Multiple IPs registered for listener when using AlwaysOn AGs w/ multi-subnet clustering
We are testing AlwaysOn Availability Groups on a WSFC multi-subnet cluster and using dynamic DNS registration. Our issue is that sometimes the IP for the Availability Group Listener (AGL) in the ...
- 2,201
2
votes
1
answer
1k
views
SQL Server maintenance plan not working after renaming administrator
I have renamed the Windows administrator account to TEST using Local Group Policy editor. After that, the SQL Server maintenance plans are not working anymore:
Unable to determine if the owner of ...
- 231
0
votes
1
answer
193
views
EMCA insists that it cannot connect to the service
Really new to Oracle and being a DBA in general. I am trying to set up a development environment so that I can play an learn oracle better. Enterprise Mananger failed to configure itself when I first ...
CommunityBot
- 1
1
vote
0
answers
67
views
BCP to SQL Server DB seeing excessive waits
I have a process I built in Powershell which has been working flawlessly for years on a couple servers, but when I migrate it to new servers I see a lot of waits (ASYNC_NETWORK_IO) during BCP step ...
- 11
0
votes
0
answers
273
views
SQL Server High Availability Windows Cluster - DNS Records are deleted after failover
We an an issue were when we failover a sql server clustered instance sometimes the server fqn servername.domain.com DNS Host A record entry will disappear. Has anyone had this issue and a fix?
...
0
votes
0
answers
161
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
138
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,146
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
73
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
...
- 15.8k
1
vote
0
answers
128
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
817
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/...
- 38.6k
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
974
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