Questions tagged [windows-server-2012-r2]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
0
votes
0answers
17 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 ...
0
votes
0answers
10 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#...
1
vote
1answer
161 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 ...
0
votes
1answer
41 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
votes
1answer
36 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
35 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
3k 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 (...
1
vote
1answer
57 views

Query of sys.login_token doesn't include particular windows group while connect within workgroup

I had two SQL Server Logins which correspond to two windows groups: MachineName\MyAppAmdin MachineName\MyAppUser And I use select principal_id, name, [type], usage from sys.login_token where ...
2
votes
1answer
129 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 ...
0
votes
1answer
354 views

I'm trying to enable SQL Filestream on Windows Server 2012 and SQL Server 2016 64 bit, Management Studio 2017

The machine config is Windows Server 2012, 64 Bit SQL Server 2016, and SQL Server Management Studio 2017. When I use SQL Server Configuration Manager to enable filestream, it gives me an error that I ...
0
votes
2answers
959 views

How to change the SQL Server Backup file (.bak) file default icon?

As I would like to say that by mistake the SQL Server 2012 backup file (.bak) open with wordpad. Due to this reason all backup files of SQL Server (.bak) file change with wordpad icon in entire the ...
4
votes
2answers
1k views

when applying a sql server cumulative update or service pack on a virtual machine - what could be a safe way of stopping VMWaretools?

While applying cumulative updates to sql server 2016 SP1, there are a bunch of services and applications that need to be stopped for the update to go on. Among those is the very core of the virtual ...
1
vote
0answers
88 views

Waiting Tasks on Mirror

I just migrated my primary's synchronous mirror to a new server and I've noticed that there are 150 to 230 waiting tasks on the mirrored instance (based on the activity monitor.) I don't recall if ...
0
votes
0answers
38 views

how to find out if it is safe to uninstall an application from a production sql server?

I noticed Microsoft Office components installed in a production SQL Server Box (which is part of an availability group - currently the principal) OS is microsoft windows server 2012 r2 datacentre, ...
0
votes
1answer
938 views

How to Migrate Oracle 11g R2 (Windows) database to Oracle 12c R2 (Linux) db

I have a requirement to migrate Oracle 11g R2 database (Windows platform) to Oracle 12c R2 database (Red Hat Linux platform). Is there any methods using RMAN to do it? Any help will be appreciated.
0
votes
1answer
50 views

Quorum configuration warning for cross subnet AAG failover

We have setup a 3 node AAG in our staging environment as a POC. The 3rd node has been configured in a different subnet and also as an asychronous replica. The Windows Server version is 2012 R2 and the ...
0
votes
1answer
18 views

Can SQL Server 2014 server reported drive space properties change overnight when database growth is set to Unlimited?

Our SQL Server 2014 server is running on Windows Server 2012 R2. The drive space properties reported by the OS shows that we had 17 GB free one day, and the next day it shows we have only 718 MB free. ...
0
votes
1answer
613 views

System Memory (RAM) for Windows Server 2012 Standard with SQL Server 2012

We are using Windows server 2012 standard server with 2.4 GHz and 16 GB RAM. SQL Server 2012 is installed in it and also our primary application is installed on the server. Using transaction ...
1
vote
1answer
324 views

Intermittent failures to connect to 127.0.0.1

I have an instance of SQL Server 2016 (13.0.4451) which I can reliably connect to over shared memory (lpc:(local)\instance). If instead I try to connect to 127.0.0.1,1433 I experience low (~1/1000) ...
0
votes
1answer
517 views

login failed for user 'domain\localMachineName$'

login failed for user 'domain\localMachineName$'. Reason: Could not find a login matching the name provided. [CLIENT: ] This appeared on my new SQL Server right after I added it to an existing ...
0
votes
1answer
370 views

adding node to existing availability group

Currently have a 2 node availability group, trying to add a 3rd. Added Node3 to the Windows Cluster. Node3 appears as UP in "Nodes" on the Failover Cluster Manager console. However I have the ...
1
vote
0answers
287 views

Why is SQL Server unable to access partitions stored on UNC paths?

I have a database with its primary file and log file stored locally. One table is split into 101 partitions which are stored on a Windows share on another server accessed by a UNC path. Each partition ...
0
votes
1answer
276 views

Arithmetic Overflow at RunningPackages (SSIS) problem [closed]

I've developed an SSIS Package with the C# Code.All the Package were running fine.But for the past 2 days, we are experiencing public void Main() { // TODO: Add your code here ...
0
votes
2answers
1k views

how to run SSMS as a different user?

I am running SSMS as a different user from my local machine and it works fine. When I try to do the same, even using my own credentials, on server01 I get the following error: access is denied I am ...
2
votes
1answer
2k views

Throttling SQL Server database cpu usage

I'm wondering if there is away to limit specific database from using server's resources like setting max CPU and RAM for each database [simpler to IIS App pools]? I'm working with SQL Server 2014 ...
3
votes
1answer
5k views

Missing assembly when running PowerShell script using SMO

I wrote a script which takes database name, restored DB name, backup source, data file location and log file location as parameters and performs database restore on SQL Server instance. Script works ...
1
vote
3answers
483 views

Service Account for SQL Cluster

I am setting up Test SQL ( 2012) server cluster with always on feature. Cluster consist of two windows server 2012 R2 servers. I need to setup SQL service accounts, Does anyone know if it will be ...
7
votes
1answer
10k views

'The computer must be trusted for delegation and the current user account must…' error when trying to connect to sql server 2008

Our admin set up a brand new Windows 2012 R2 server with Visual Studio 2015. When I try to connect to an existing sql server 2008 database (running on a windows 2008 r2 server) from Visual Studio, ...
3
votes
3answers
368 views

SQL Server FCI won't start after OS Upgrade

I have a two node sql server 2008 r2 cluster that we just did an OS upgrade from windows 2008 r2 to windows 2012 r2, the OS upgrade was done in place so the SQL Server Installation stayed in tack. ...
1
vote
1answer
341 views

MariaDB on Windows Server 2012 R2 - out of memory

I have two servers, one with Windows Small Business Server 2008 and the other runs Windows Server 2012 R2. The servers have running multi master replication. Both uses MariaDB 10.2.6. On the old 2008 ...
2
votes
0answers
39 views

Capture SQL 2014 installation errors

Right now when I install SQL 2014 (via a PowerShell script) it automatically sends errors to: c:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\blahblahlog.txt I'm hoping to capture ...
1
vote
1answer
682 views

Always Encrypted - certificate cannot be used as a column master key

I want to create a new column master key using certificate created in advanced. I use the following command to create a certificate in the Windows Certificate Store - Local Machine. New-...
5
votes
2answers
13k views

SQL Server Windows NT 64 bit Sudden High CPU Spike

I am facing a strange behavior of my SQL Server 2016 web edition. SQL Server Windows NT 64 bit suddenly jump to use 90% of the CPU and then it goes down after 5 sec, then the spike comes again after 3 ...
1
vote
0answers
661 views

SQL Server not Using Allocated Memory

I have a weird problem I am struggling to troubleshoot. I have a development server with 18GB RAM and two SQL Server 2012 SP3 instances with @@version output: Microsoft SQL Server 2012 (SP3) (...
1
vote
2answers
1k views

Always On log files bigger than database files

We had SQL RAP and we got warning that Transaction log files larger than the database files. They advised me to remove databases from Always ON, change recovery mode to SIMPLE and then shrink log ...
1
vote
1answer
1k views

Confused about the “Maximum Failures in the Specified Period” setting on SQL Server Cluster

The failover properties of the SQL Server role on my two-node SQL cluster are as follows: Maximum Failures in the Specified Period: 2 Time period: 6 (hrs) I would expect that forcing failover (...
0
votes
1answer
9k views

The SQL Server (MSSQLSERVER) service terminated unexpectedly. Event ID: 7034

Unable to find the cause why the SQL Server Service was Terminated Unexpectedly? (Event ID: 7034) I looked into the SQL Server Error Logs but could find the reason about why the SQL Server service ...
4
votes
2answers
757 views

4 CPUs of 20 (NUMA node 0) Pegged at 100%

The previous Senior DBA left the company and I was made aware of a server which suffers from multiple problems, largely slowness (all the way from SSMS taking a long time to open, long running queries,...
0
votes
1answer
41 views

backup of databases - consistently back up databases with control of log truncates

My question is how can I back up my database by controlling the log truncates? I need to perform a testing with VEBF (Veeam Endpoint Backup FREE). A test case that I have to make now is that I have ...
3
votes
1answer
1k views

Restore keeps failing

I have a SQL Server 2014 instance with a ~900GB backup database that goes through a weekly restoration process from a full backup. The server it's on is a Windows Server 2012 R2. I have recently ...
1
vote
1answer
1k views

Not enough server storage is available to process this command - RESTORE DATABASE is terminating abnormally

First a little description of the system that I'm seeing the problem on: My firm has a regularly scheduled restoration of a database from backups of another, I won't go into the business reasons for ...
5
votes
1answer
3k views

Always On AG is Down when service is stopped

I have SQL Server 2014 running on Windows Server 2012 R2. There are three nodes, one is remote DataCenter. So two nodes have voting. Failover Cluster is using file share witness on remote server. If ...
4
votes
2answers
644 views

Why is the processor % different in Activity Monitor vs Resource Monitor?

I'm tracking a significant difference between the processor % reported in the Activity Monitor for SQL Server vs the total processor % used in the Resource Monitor. I'm seeing about a 50% difference ...
2
votes
3answers
1k views

Database is slow after server transfer

I have a big database, about 250GB, and recently our system had to be transfered to a new machine. The old machine: Has a Windows Server 2008 R2 Standard Edition Runs SQL Server 2012 32GBs of RAM, ...
1
vote
2answers
2k views

By what policy are SQL Server 2014 updates installed automatically?

Tonight our server decided to install SQL Server 2014 CU7 for SP1. The update appears in the Windows Update history and I found downtime in our logs for it. The previous patch level was CU3. I was ...
1
vote
3answers
5k views

Allow remote access only from certain IP addresses

If I've understood what I've read, all you need to do in order to allow remote access to SQL Server is to open TCP port 1433 in Windows firewall. But that will leave your server wide open to the ...
1
vote
1answer
855 views

SQL Server 2016 Standard Version Features Evaluation

We're looking to test the new Basic Availability Groups (BAG) feature in SQL Server 2016 Standard Edition. So far, I have not been able to find an evaluation copy of Standard. Is there a way we can ...
1
vote
1answer
838 views

MongoDB fails with SymInitialize error unless there is a very large Page File in Windows

I'm wondering if someone can help with a MongoDB/page-file issue we seem to experience as our database increases in size over time. Every now and then MongoDB will crash on a particular node in our ...