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
2
votes
2answers
44 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
21 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 ...
0
votes
1answer
93 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, ...
0
votes
2answers
63 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
20 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
52 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
48 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
7 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
365 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
342 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
32 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
10 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
63 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
62 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
145 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
22 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
132 views

SQL server agent unable to establish connection

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
113 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
66 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
49 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
8 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
106 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
101 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
120 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#...
2
votes
0answers
53 views

How to Configure SSRS Web Service Port via Command Line

It is straightforward to change the TCP port of SSRS using the GUI (Reporting Services Configuration Manager) but I am trying to fully script the installation and config of our SSRS servers. Is it ...
1
vote
1answer
476 views

Issues setting up Oracle 18c XE on Windows Server 2012 r2

I've been running into some problems getting my Oracle installation up and running on Windows Server 2012 r2 at work. Initially, I had installed Oracle on my Win10 laptop for test purposes - I ...
2
votes
1answer
66 views

MySQL 8.0 Replication filters lost between restarts

I don't know if I fell on a bug or a feature, I read the documentation several times but haven't found the information. I have two MySQL servers, both on 8.0.15 and hosted on a Windows Server (x64). ...
0
votes
0answers
56 views

Connect google cloud storage bucket in MSSQL(2016)

I host a SQL Server Enterprise 2016 + Windows Server 2016 DataCenter on google compute engine. I'm going to use .bak file on my google cloud storage (GCS) bucket, to restore database on other folder ...
3
votes
2answers
138 views

Windows Server version and SQL Server

Is there a blog / webpage / information (I did not find anything) out there, if it has performance benefits, if I use a newer Windows Server version for my SQL Server? Example: I run SQL 2016 on a ...
0
votes
1answer
215 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 ...
1
vote
1answer
34 views

Which account should be used for the SQL Server Service logon account where the server has been added to a domain?

I have installed SQL Server 2017 Express onto Windows Server 2012 R2. I need to add a self signed certificate to SQL Server Protocols in order to enable wire encryption. This comes with a requirement ...
0
votes
1answer
51 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 ...
0
votes
0answers
52 views

Performance difference between on-prem SQL Server and SQL Server running on Azure(IaaS)

We are comparing the performance of an on-prem SQL Server and SQL Server running on Azure VM. The Azure VM is created by Azure Site Recovery(ASR). For the testing purpose, we have executed following ...
0
votes
1answer
29 views

Configuring pg_admin 9.6 while there are users using it on Windows Server 20XX?

I read something about pg_ctl reload (I'm not sure if that's on the Windows distro of pg)...also is there a way to verify the configuration isn't going to break it completely, like apachectl ...
3
votes
2answers
529 views

Evict node from SQL Server 2016 Cluster on Windows Core

I have 4 nodes cluster on Windows Core with SQL Server 2016 installed on them (4 instances, 1 instance on each node). I would like to remove 2 nodes from the cluster (2 instances aren't needed). I ...
2
votes
1answer
364 views

Startup Parameters greyed out in SSCM for new instance

We do not appear to be able to change the startup parameters for a new SQL Server instance, using SQL Server Configuration Manager (see screenshot below). We are members of the sysadmin fixed server ...
0
votes
0answers
17 views

Windows 2016 Workgroup failover cluster

I am building a two node Window failover cluster for SQL Server AG. I am getting following errors in the cluster log. Please help me to resolve the error. Thanks
7
votes
2answers
1k views

Run Powershell Script From Agent As Administrator

I need to recycle an AppPool in IIS on my server when the SQL Server Service starts. The route I am taking is to have a startup stored procedure which runs an Agent job that has a Powershell job ...
0
votes
0answers
174 views

Issues with a SQL Server instance alias

I have the most simple of questions: I've got a Microsoft SQL Server with two instances, default and a named instance called Instance1. The default instance is running on static TCP/IP port 1433 and ...
-1
votes
1answer
37 views

Database Connection SQL Server 2012

My payroll application developed in ASP.net and C language not able to connect the database. Our Payroll is broadcast through IIS, after we change our router i can't access this TimeCardUploader. How ...
0
votes
1answer
788 views

How to find how many number of transactions are happening in SQL Server/SQL Server database in a day?

I have to migrate my SQL Server on a particular public cloud, which is charging/licensing on the basis of number of transactions happening on the SQL Server. I am aware of the Performance Counters ...
2
votes
0answers
14 views

Where should I put my system databases in WindowsCore container

We're looking into migrating our SQL Server environment to use containers. I've successfully built a WindowsCore image with SQL Server installed. The instance is accessible with the data files using ...
0
votes
1answer
42 views

What rights do you need for Ola's integrity check?

I'm configuring a new server and Ola's integrity check is working for user databases (I have restored a database of around 50 GB for tests) and is failing for system databases. If I look in the logs ...
0
votes
1answer
36 views

Remove Windows FCI completely

When I built the cluster I forgot to uncheck the storage. It's now giving me all sorts of errors. How can completely remove the cluster so I can rebuild it? This is a 3 node cluster and I evicted two ...
5
votes
1answer
4k views

SQL Server Service does not start automatically after system restart

I have a SQL Server system that reboots weekly (after installing Windows Updates). The last three weeks I have seen that the SQL Server service does not start when the server comes back up (...
0
votes
0answers
32 views

renaming Windows machine and SQL Server

We've built a new Windows 2016 VM with SQL Server 2016 that we'll migrate a mission critical database currently on SQL Server 2008 R2 to. The original plan was to have users test, test, test and test ...
0
votes
1answer
114 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:...