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
1
vote
2answers
804 views

How to Disable Windows Authentication in SQL Server

I would like to say that as per my Organization requirement they want to Disable Windows Authentication in SQL Server. My Environment is as follows:- 1) Microsoft Azure 2) Windows Server 2016 3) ...
1
vote
1answer
882 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
178 views

WSFC Quorum query

I have an three node AlwaysOn AG setup, running on SQL Server 2012 SP3 in Windows Server 2012 R2. Node 1 and Node 2 are in the same physical location. Node 2 is the secondary replica. Third node acts ...
1
vote
1answer
2k views

SQL Server failover cluster installation fails on primary node

I'm trying to install SQL Server 2014 fail-over cluster, but the installation fails with following log i have tried a lot of things but without any success.. The installation failed with following ...
1
vote
1answer
38 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 ...
1
vote
1answer
646 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 ...
1
vote
1answer
659 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
71 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 ...
1
vote
1answer
1k 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 ...
1
vote
3answers
644 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
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 ...
1
vote
1answer
819 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
1answer
2k 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 ...
1
vote
1answer
14k views

SQL Server 2012 compatibility with Microsoft Server 2016

This is just a really simple question before I steam roller ahead and wreck everything. I have ordered a server that will have Windows Server 2016 installed however I have now realized that the tools ...
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
1answer
837 views

Issues installing patches on SQLserver 2008

There are multiple issues with a server I manage, we cannot start management studio on it and when we try to install patches to SQL Server the setup never shows up. I run the patch as an ...
1
vote
2answers
927 views

How many deadlocks am i really getting? system health or deadlocks/sec?

I'm trying to look at deadlocks on a troublesome server, and when I look at the system_health xel file, I see 80 records for "xml_deadlock_report" in about 16 hours. I assume these are all different ...
1
vote
1answer
151 views

Least Privilege for SQL Agent to run DISKPART

The DISKPART script SELECT DISK 1 ONLINE DISK runs fine as long as SQL Agent has admin rights on the server; otherwise the script fails with this message: Message Microsoft DiskPart version 6.3....
1
vote
2answers
8k views

MySQL on Windows or GNU/Linux?

I've just read this article: http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html There it says that MySQL on Windows is a good choice. (or is what I've understood) In ...
1
vote
1answer
70 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 ...
1
vote
1answer
487 views

Cannot add Network Service as User/Login

I want to setup ProGet on a 2016 server with SQL Express and IIS. Both the service and IIS web runs under the Network Service user. None seem to be able to access the Database on a local SQL Express ...
1
vote
1answer
161 views

How to synchronize a Windows database for Linux?

I have some database (PostgreSQL 9.5) on a Windows server, and I would like this data to be synchronized to a Linux server, that is connected in an application. Is it possible to synchronize?
1
vote
2answers
404 views

Using ASPState database in the AG cluster with multiple teams using the same ASPState

We are migrating a number of the 2008 Windows clusters to the 2016 servers and consolidating databases in the same AlwaysOn cluster. Our dev teams are currently using ASPState databases specific to ...
1
vote
2answers
491 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?
1
vote
1answer
402 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) ...
1
vote
1answer
1k views

Use Windows 2016 Storage Replica for SQL Server failover cluster instance

We have two standalone servers with local storage. Based on our needs we have determined that we need to use AlwaysOn failover cluster instances. Can we use the "Storage Replica overview" feature of ...
1
vote
1answer
757 views

granting access for remote account to local database instance [closed]

i have two computers in a same domain, there is database instance on one of them, which is the DC, the question how can i add an account (reside on the other computer) to grant access to that DB!. i ...
1
vote
1answer
362 views

R Script permissions error

I executed this to check to see if I have write permissions on a folder and it fails (returns -1). I am a system admin and SQL admin. I have full access to this directory but the R Script says I do ...
1
vote
1answer
684 views

Run out of virtual memory after added to triple physical RAM and change SQL Server memory option?

Recently, we added some physical RAM to our server which running SQL Server 2008 R2 instance, the total memory was changed from 64GB to 192GB. And we tuned the memory option of SQL Server by changing ...
1
vote
1answer
748 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-...
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 ...
1
vote
1answer
1k views

How do you Audit Login Failures? Solutions?

How do you Audit Login Failures? Solutions?
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
686 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 ...
1
vote
1answer
443 views

Windows PostgreSQL Update Timezone Data

Turkey government has announced that Turkey will stay on GMT+3. We've waited for OS pathces to update tzdata on PostgreSQL. Now, timezone patch for Windows is installed. On Linux, restarting ...
1
vote
1answer
78 views

Quorum disk conundrum

I'm having a problem with a 2-node active-active cluster which has been failing over lately but not bringing resources back online. We've had a Microsoft engineer look at it and, among other things, ...
1
vote
1answer
2k views

Failed installation of SQL 2012 on Windows Server Core

I'm in the process of building the lab for 70-462 exam. On page 49 of the text, it provides the command to install SQL 2012 on Windows Server Core: Setup.exe /qs /Action=install /Features=SQLEngine,...
1
vote
1answer
869 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 ...
1
vote
2answers
7k views

Proper Shutdown of SQL Servers in a Cluster

I was just wondering what the best approach should be for shutting down an Active/Active Cluster where both nodes need to be shutdown for disk maintenance. I was thinking of this process: Open ...
1
vote
3answers
6k views

MySQL: How to avoid case sensitivity in SQL queries when migrate from Windows to Linux?

I have migrated my Database from Windows to Linux server. In many places, query has been written without focusing their cases (uppercase / lowercase). So, these queries are not getting executed and ...
1
vote
1answer
869 views

Backup Database (SQL 2000 Compatibility) on SQL Server 2005 with CHECKSUM, but Page Verification TORN_PAGES Detection

I am trying to backup a 250GB database on SQL Server 2005 running in SQL 2000 compatibility mode. The page verification is set to TORN_PAGES detection. So, far the backup has been corrupted when we ...
1
vote
2answers
630 views

Why does MySQL + Windows Server = crashed tables periodically?

Windows Server 2008 R2 x64 MySQL Server 5.6.14 x64 Is anyone else having an issue in where some tables are marked as crashed on a Microsoft Windows server? We have a couple of Windows servers (not by ...
1
vote
1answer
5k views

startup mount issues with Oracle

I am trying to simply shutdown and restart an Oracle db instance on a Windows Server 2008 machine (Oracle 11.2.0). Logged in via sqlplus, I issue the command shutdown immediate;. I get the Database ...
1
vote
1answer
2k views

PostgreSQL 8.0 - Windows Server 2008 R2 install - Service won't start

I am trying to install postgreSQL 8.0 on a windows server 2008 R2 machine. After the installation, the service does not start. When I try to start it manually, I get a message saying that the service ...
1
vote
0answers
38 views

SQL server availability group cannot access database after disabling sql service

I've completed this setup: OS: Windows server 2016 Database: SQL Server 2017 2 node availability group configured with automatic failover on both nodes. Fileshare witness configured, both nodes ...
1
vote
0answers
332 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, ...
1
vote
0answers
183 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 ...
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 ...
1
vote
0answers
162 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 ...

1 2 3
4
5
8