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
3answers
630 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
3answers
642 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 ...
1
vote
0answers
405 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 ...
8
votes
1answer
13k 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
489 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
458 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 ...
1
vote
1answer
151 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
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 ...
2
votes
1answer
1k views

SSIS data flow task failed for no reason [closed]

An SSIS package keeps failing for no reason. There are only three lookup transform components in the package (besides the source and output component), two running in partial cache mode and the other ...
2
votes
0answers
725 views

SQL Server 2014/2016 (Win2K12R2) and Winsock limits - how to cope?

We're experiencing a problem with connections to SQL Server and after a week of digging through I was able to pinpoint it to Winsock limits. Here's the description: We have SQL Server 2014 (and 2016) ...
1
vote
1answer
746 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-...
2
votes
1answer
3k 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
1answer
805 views

Windows Server 2016 Active Directory-Detached Cluster - Cannot add a Client Access Point

I am setting up a Windows Server 2016 cluster detached from an active directory (so called Workgroup Cluster, i.e. nodes are not added to an active directory). I cannot add a Client Access Point to ...
0
votes
2answers
4k 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. ...
6
votes
1answer
18k views

Fastest way to move MongoDB to a new server

I have to move a 200GB MongoDB from one server to another (both Windows 2016 OS). During this operation, it is assumed that the accompanying program will be offline, so no need to worry about ...
0
votes
2answers
126 views

Best way to get SQL Server databases on small capacity VPS

I have several small sites and I've just rented a Windows VPS server with 1&1. It includes 2 "vCores", 4 GB RAM and 120 GB SSD. It runs great for my needs but now I need to determine the best way ...
2
votes
0answers
513 views

SSIS 14 - Buffer Memory - Good practices

I've a some packages in SSIS 14 in order to extract the data from a lot of operational databases and load into my Data Warehouse. I've the following virtual machine: Windows Server R2 Standard RAM:...
5
votes
1answer
4k 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
390 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
6k 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 ...
5
votes
2answers
15k 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 ...
0
votes
1answer
329 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
861 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
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
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
2k 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 (...
1
vote
1answer
69 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 ...
0
votes
1answer
11k 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 ...
1
vote
1answer
1k views

How do you Audit Login Failures? Solutions?

How do you Audit Login Failures? Solutions?
2
votes
2answers
1k views

Best use of RAM for multiple SQL instances?

I have a new Windows Server 2016 box with 32GB of RAM, it will be used for dev testing by one or two users max. There will be occasional use of VM/Hyper-V instances and a couple of IIS test sites ...
0
votes
1answer
353 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
818 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 ...
0
votes
1answer
13k views

Microsoft SQL Server, Error: 10054

The SQL Server Management Studio is working just fine when we RDP into the server and try to perform any sa privileges.However, when we use it from our local machines it is throwing the errors ...
0
votes
1answer
3k views

Cannot Generate SSPI Context when connecting to the remote Computer

I am connecting to Windows Server 2008 R2 which has SQL server 2005 installed via ODBC from a client machine. Recently I started getting this error Cannot generate SSPI Context. I have gone ...
1
vote
2answers
5k views

frm-92100:your connection to the server was interrupted

frm-92100: error I use my using internet explorer & JInitiator 1.3.1.13 using oracle 11g and dev9i windows server 2008 R2. The app was running fine for last 2 years but suddenly this happen. I ...
2
votes
1answer
5k views

how to install SQL 2000 in windows server 2016 OS

how to install SQL 2000 in windows server 2016 OS, Is it possible ,please give me a solution.
0
votes
1answer
36 views

Not able to install MSSQL 2014 on an additional disk(some disk other than the OSdisk) silently on Windows 2012 R2

I am providing the following paths during installation(and yes, there's no overriding anywhere)- InstallSQLDataDir = "R:\Microsoft SQL Server\Instance" SQLBackupDir = "R:\BACKUP\Microsoft SQL Server\...
0
votes
1answer
84 views

TempDB on Shared VHDX

Multiple nodes within a cluster. Using HyperV as the virtualisation layer. VMs use Fibre Channel SAN for storage but trying to explore the possibility of using Local SSDs for the TempDB. Issue is when ...
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
vote
1answer
147 views

SQL Server TempDB on Local SSDs with VMs

Two physical Servers in a Cluster. Multiple SQL 2016 Virtual Machines. Fibre Channel SAN Storage used for the Virtual Machine Operating System and Database Data Files. I've seen multiple sources claim ...
0
votes
1answer
5k views

SQL Server 2012 Support on Windows Server 2008 R2

Is it possible to install Microsoft SQL Server 2012 on Windows Server 2008 R2 Datacenter? On the Windows Server 2008 R2 Datacenter - I have .Net Framework 3.5.1 Features(.Net Framework 3.5.1) and I ...
0
votes
1answer
326 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
1k views

Enabling AWE on SQL SERVER 2008

We have a Server running Windows Server 2008 32-bit (Enterprise Edition) and SQL Server 2008 (SP2) 32-bit (Enterprise Edition) installed. The server has 32 GB Memory and we assigned 22 GB to SQL ...
1
vote
1answer
681 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 ...
2
votes
1answer
165 views

Should Database Servers Be Defragmented?

I've never been clear on this point - should Windows servers running SQL Server ever be defragmented with a tool such as Smart Defrag or Windows' Disk Defragmenter?
4
votes
2answers
818 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,...
1
vote
2answers
614 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 ...

1 2 3
4
5
8