Questions tagged [windows-server-2012]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
17 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
38 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 ...
2
votes
0answers
24 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 ...
0
votes
0answers
43 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 ...
5
votes
2answers
612 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
50 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 ...
2
votes
1answer
620 views

how to Enable these Windows Firewall rules using powershell?

I have a few servers where I see a blue question mark on the sql server service, as per the picture below. This is the solution: Enabling these Windows Firewall rules did the trick for me ...
0
votes
1answer
31 views

Duplicate Ips for cluster nodes causing backup issues

We have a four node cluster (SQL Server 2014 on Windows 12) and we recently setup heart beat network on the nodes following a best practices source after experiencing some cluster instability issues. ...
1
vote
1answer
38 views

One instance, four clients, one is slow

We have a small office setup with one Windows Server 2012 running SQL Server 2016 Express. The database is hosting files for our accountant software. This is a multi module software that runs ...
1
vote
1answer
359 views

Quorom Configuration for 3 Node Windows cluster

We have 2 node onsite and the 3rd node on DR and there is no disk witness. Due to maintenance I set the DR site to be primary and the other 2 nodes to be manual in asynchronous mode and after both ...
1
vote
2answers
54 views

Can I install SQL Server 2012 Express edition on a same machine with 2012 SQL Server Standard version

As I would like to say that we are going to downgrade the SQL Server Standard 2012 SP1 edition with SQL Server Express 2012 SP4 in one Production Server. For the time being I want to keep the SQL ...
0
votes
1answer
339 views

Why does SQL Server Profiler crash when its run against a DB machine from a client machine?

I have: SQL Server 2014 (default instance )is on a Win Server 2012 machine. SQL Server Management Studio (v17.7) is on a Win 7 machine. Both machines are on the same domain. I'm logged into the Win 7 ...
1
vote
2answers
213 views

SQL Server 2014 Standard FCI Does Not Failover

Have a peculiar case where a previously working FCI, after installing a large backlog of Windows updates, is now failing often and not failing over. On occasion, and this appears to happen around ...
0
votes
1answer
5k 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 ...
1
vote
0answers
435 views

clussvc.exe consuming high cpu

We have a 4 node cluster running 2 SQL Failover Instances. Windows 2012 Standard & SQL 2014 Microsoft Failover Cluster Service has been consitently between 25 - 30 % CPU. This is happening on 2 ...
0
votes
0answers
89 views

Remove node from failover cluster without access to said cluster or domain

I have a server running Windows Server 2012 and SQL Server 2008 R2. The server used to be part of a SQL cluster but it is now standalone and no longer has access to the cluster. I want to repurpose ...
1
vote
2answers
216 views

How to restrict SSMS to list the database of a particular user (Windows 2012 + Plesk)

We are using windows 2012 R2 server with Plesk and provide shared hosting for our customers. Version Details: MSSQL server 2012 and SSMS 11.0.2100.60 In SSMS if we login with particular user, it is ...
2
votes
1answer
195 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/...
0
votes
0answers
283 views

High disk usage by Windows Server when executing SSMS

Every time we execute SSMS on Windows Server, there is a high disk usage System process for ntuser.dat.LOG, as seem at Resource monitor: The write rate is between 2 MB/sec and 8 MB/sec. Why do we ...
3
votes
1answer
8k views

Application Server is not able to connect to SQL Server database when TLS 1.2 or 1.1 is enabled

In our environment, SQL Server 2012 Servers whenever TLS 1.2 or TLS 1.1 is enabled Application Server is not able to connect to the database.The same issue is observed only on MS SQL Server 2012 ...
0
votes
1answer
537 views

Can I Configure Enterprise Manager Cloud Control on Standard Edition

Is it possible to configure enterprise manager cloud control on Oracle 12c Standard edition? Will it administer multiple databases (Non-CDB)? What about administering databases on different servers?
1
vote
2answers
388 views

How to create shared folder between my on-premise Windows Server and Azure VM Server?

I'm trying to migrate my on-premise SQL Server to Azure VM using 'Microsoft Data Migration Assistant'. But it is asking for shared folder to be accessed by both source and target. How to achieve this?
0
votes
2answers
635 views

MySQL - Service Name in Windows

What is the MySQL service name? Get-Service | where{$_.name -like "*MySQL*"} Is that correct?
0
votes
1answer
37 views

Un-Install OS Patch (KBs) in Physical PRODUCTION Servers - Consequences [closed]

We have our PRODUCTION Database and Application Servers which are Physical Servers . Recently , the October month OS Patches (specific KBs) are little problematic and reported by Microsoft too that ...
1
vote
3answers
5k views

SQL Server CPU usage is overloaded sometimes

We do have a couple of servers, one is dedicated to the website without SQL and the other server is dedicated to SQL. Now the server running SQL is quite powerful, yet sometimes the server CPU is ...
0
votes
1answer
1k views

Sql Server Error 18452 The Login Is From An Untrusted Domain

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 ...
0
votes
0answers
659 views

Primary Server is “Resolving state” & Quorum node is in “failed” state

I would like to say that in my environment I have a 2 node in WSFC with the nodes SQLServer-01 (Primary Server) SQLServer-02 (Secondary Server) And for third vote in cluster also One (File share ...
0
votes
4answers
68 views

Upgrade my server or migrate it to a new server [closed]

I have a two servers, one is application server that runs with Windows Server 2003 and one SQL server runs with SQL 2008 and windows server 2003 OS. I would like to upgrade the both servers' OS to ...
1
vote
1answer
922 views

How to connect to a SQL Server installed on Windows Server 2012 running on VPS?

I want to connect to my SQL server installed on a windows server 2012, that is running on a VPS(Virtual Private Server) remotely, I have done the following steps: Enabling SQL Server to allow remote ...
2
votes
3answers
556 views

Memory Consumption on Database Machine

My Database server is consuming 71% - 75% percent of RAM memory, I can see from perfMonitor logs that SQL_Service is eating up 65% - 69% of RAM memory. We carried out different operations to lower ...
1
vote
0answers
331 views

Unable to start the Integration services for SQL server 2012

Suddenly we are facing some errors in starting up the integration services. From event viewer and ssms when we tried connecting we get below error message The SQL Server Integration Services 11.0 ...
1
vote
1answer
132 views

How to understand I/O bottleneck for SQL Server

I'm getting into the dba world for SQL Server via "trial by fire", and I have a IO question. I have a SQL Server 2016 engine built upon Windows Server 2012. This setup includes: 128Gb Ram 6Gb/s ...
2
votes
1answer
2k views

Can't login as root and can't change root password

I have a MySQL 5.5 server on Windows 2012r2. The database was not performing well, so I generated an ini at Percona and replaced that wit my old ini. The server is performing good now, but now I ...
0
votes
2answers
3k views

Database backup: NT AUTHORITY\\SYSTEM is not able to access the database

When trying to automatically backup a MsSQL database on a Windows 2012 Server, the following exception is thrown, and hence the backup is not taken: Description: Error encountered during backup. ...
5
votes
1answer
3k views

Diagnosing slow Always On commits

Two node Always On availability group, one synchronous replica. My synchronous replica falls out of sync very regularly. I see a pattern in which, when a log backup occurs on the secondary replica a ...
1
vote
0answers
21 views

Database service likely hang at some moments

Our team adopted MariaDB to replace SQL Server 2008 last year end. There is no issue for DB service hanging, and last week and yesterday I met 2 services hang issues. The following are configurations ...
2
votes
0answers
365 views

Slow SSMS connecting to AWS EC2 instance

I have an AlwaysOn availability group in AWS EC2. 2 nodes, multisubnet, with 1 DC in one subnet, the other DC in a separate (3rd) subnet. All in the same VPC. When anyone connects to either of the ...
2
votes
4answers
5k 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 ...
0
votes
1answer
296 views

SQL 2016 Always on Listener

I have followed many articles on how to get SQL 2016 always on setup and I am hopelessly stuck on the listener. One of such articles is http://blog.fedenko.info/2016/06/sql-server-2016-always-on-...
1
vote
0answers
2k views

Running Oracle DataPatch after OPatch

After patching an Oracle 12c database (Windows environment, container DB and 3 PDBs), is there any way to predict or estimate how long it will take to run DataPatch utility? Or to see how far along it ...
1
vote
1answer
66 views

Memory utilization for multiple instance (SQL server 2008R2 standard edition)

If SQL Server 2008 R2 standard edition is limited to 64 GB of memory, then is it required to restrict the max memory for multiple instances (3) which are running SQL server 2008 R2 standard edition ...
1
vote
1answer
1k views

How do you Audit Login Failures? Solutions?

How do you Audit Login Failures? Solutions?
0
votes
1answer
326 views

Innodb_table_lock status

can anyone explains to me what will happen if i set innodb_table_locks=ON or innodb_table_locks=OFF ? The pros and cons of the action. Thanks.
1
vote
1answer
743 views

AWS - MySQL server “Service CPU Usage” stuck at 50% / being throttled?

I have a c4.large EC2 instance which is running Windows Server 2012 and MySQL. When I look at the CPU usage on the machine it seems that MySQL is capping out at 50% CPU usage when the system is under ...
1
vote
0answers
1k views

Can I use Foreign Data Wrapper for SQL Server in Windows Server 2012?

I use PostgreSQL and SQL Server. I want to get SQL Server data in PostgreSQL. I found PostgreSQL Foreign Data Wrapper. There are installation packs for CentOS and Ubuntu. However, I want to use FDW ...
0
votes
1answer
1k views

How to check decimal separator in T-SQL

How can I check with a T-SQL Command what decimal separator is in use in a given user context. Microsoft Windows Server 2012 has a bug where the regional settings for Swiss German introduced an ...
0
votes
1answer
271 views

Teradata ODBC - version 14 and 15 side by side

Is there a way to install version 15.11 alongside version 14.10 of the ODBC Teradata drivers? I've run the 15.11 install wizard but it seems to want to remove all previous versions automatically. ...
1
vote
1answer
569 views

Remove a SQL Server Patch only visible in View Installed Update List

Kindly help me regarding our issue with a Clustered Environment's applied patch. The situation is: We removed a SQL Patch: GDR 6248 for SQL Server 2012 (KB3194721) (64 bit). When we successfully ...
3
votes
0answers
6k views

Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave

I am trying to setup multi source replication. In my slave I have defined following two properties in its configuration file. master-info-repository=table relay-log-info-repository=table These ...
1
vote
2answers
495 views

SQL Service failed to start master.mdf is in use

I've got this issue which has me baffled at the moment. When I came in this morning there were 2 instances on a server with 4 SQL Server instances who had a backupthread process which got stuck when ...