Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [windows-server-2012]

The tag has no usage guidance.

0
votes
0answers
37 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
173 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
39 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
307 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
26 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
31 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
122 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
49 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
0answers
23 views

Perfmon Counter stop collecting at random Intervals

I have created a collector set in Windows Performance Monitor which logs to a SQL table using an ODBC connection. The collector set runs everyday from 00:00 and starts polling and stops polling for ...
0
votes
1answer
229 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
171 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
4k 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
325 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
73 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
112 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
165 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
222 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
6k 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
463 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
312 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
500 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
4k 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
992 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
541 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
65 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
720 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
505 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
289 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
117 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
334 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
3answers
4k 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
261 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
65 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
933 views

How do you Audit Login Failures? Solutions?

How do you Audit Login Failures? Solutions?
0
votes
1answer
310 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
698 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 ...
-1
votes
1answer
232 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
495 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 ...
0
votes
2answers
443 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 ...
4
votes
0answers
236 views

Error: “Computer X is Joined to a cluster” when creating a new cluster

I am trying to create a New Cluster for Always On Availability Groups. On Failover Cluster Manager when I try to add the cluster nodes I get the following error: Computer X is joined to a cluster. ...
3
votes
1answer
704 views

Collation issue after update (KB3072779) of SQL Server 2012

If found the following error while starting my SQL Server 2012 instance, after the update KB3072779 performed by Windows Update (Windows Server 2012 Foundation). Creating procedure ...