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-2016]

The tag has no usage guidance.

2
votes
1answer
79 views

Startup Parameters greyed out in SSCM for new instance

We do not appear to be able to change the startup parameters for a new SQL Server instance, using SQL Server Configuration Manager (see screenshot below). We are members of the sysadmin fixed server ...
0
votes
0answers
6 views

Windows 2016 Workgroup failover cluster

I am building a two node Window failover cluster for SQL Server AG. I am getting following errors in the cluster log. Please help me to resolve the error. Thanks
0
votes
0answers
90 views

Issues with a SQL Server instance alias

I have the most simple of questions: I've got a Microsoft SQL Server with two instances, default and a named instance called Instance1. The default instance is running on static TCP/IP port 1433 and ...
0
votes
1answer
33 views

What rights do you need for Ola's integrity check?

I'm configuring a new server and Ola's integrity check is working for user databases (I have restored a database of around 50 GB for tests) and is failing for system databases. If I look in the logs ...
0
votes
0answers
29 views

renaming Windows machine and SQL Server

We've built a new Windows 2016 VM with SQL Server 2016 that we'll migrate a mission critical database currently on SQL Server 2008 R2 to. The original plan was to have users test, test, test and test ...
1
vote
2answers
197 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) ...
0
votes
1answer
39 views

Will a SQL Server 2008 R2 MDF file work on SQL Server 2016 with Windows Server 2016?

We release our database as a .MDF file taken from a SQL Server 2008 R2 server. I have a client who is planning to move to SQL Server 2016 on a Windows OS 2016 and is asking if our .MDF can be restored ...
2
votes
2answers
288 views

Can't create database on volume mounted as folder (Error Msg 5123 & 1802)

SQL Server 2016 SP1 + CU8 Installed on Windows Server 2016 Standard Edition. Everything was working fine for a while and I was able to create databases until for some reason unbeknownst to me, a ...
1
vote
1answer
212 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
0answers
100 views

Domain Independent Cluster on AWS

I am trying to work out whether it's possible to create a Domain Independent Workgroup Cluster in AWS (on Windows Server 2016 for use with SQL 2017 Availability Groups). This environment also has no ...
0
votes
1answer
281 views

is xampp slow in windows server 2016?

I have this big query and i run it in my local PC (Windows 10) and it return result in 3s but i run it in client Windows 2016 Server it get more time than 30s i use XAMPP in ...
5
votes
2answers
914 views

Is it safe to run a Windows Failover Cluster Public and Heartbeat on a Single NIC?

I have a 2-Node Windows Failover Cluster (Windows Server 2016, SQL Server 2017) with a Quorum Disk Witness on fibre-connected shared storage. How important is it that the heartbeat is on its own ...
1
vote
2answers
210 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 ...
3
votes
0answers
63 views

database restore with filestream on Windows Server 2016 renames data file

I have a database in SQL Server 2008 R2 sp2 that has filestream enabled. Restore of the database on a Win10 machine works as it should. However, on Windows Server 2016, the data directory (file) for ...
-1
votes
2answers
3k views

How to login to SQL Server using AD user

I created an AD user through Administration tool then performed following commands: -- Add AD user EX. thu1 to database master USE [master] GO CREATE LOGIN [QALAB\ABC1] FROM WINDOWS WITH ...
2
votes
1answer
9k views

Cluster network name resource 'Cluster Name' failed registration

I have a fail-over cluster set between two Windows Server 2016 machines, and I'm seeing errors regarding the DNS record, both for the cluster itself and for any listener I try to add in SQL high ...
-2
votes
2answers
37 views

backup compatibility between SQLExpress 2012 and 2016 [duplicate]

May I make a backup from SQLExpress 2012 and restore it into a SQLExpress 2016?
1
vote
1answer
813 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 ...
0
votes
2answers
77 views

SQL 2017 Standard Availability Group

I am working on creating an AG on SQL Server 2017 Standard and Windows Server 2016. I have created the failover cluster using a file share witness and everything checks out OK with the cluster. The ...
0
votes
2answers
100 views

Postgres file increment size

I'm COPY-ing 300 tables / 400G to PG10@win2016server using a few threads to speed things up, but because the table files are incremented in 64-kb units (or something there-about) they get fragmented ...
1
vote
0answers
187 views

Can Oracle Database run on Microsoft Nano Server?

Microsoft Nano Server is attractive alternative to a heavier installation of Microsoft Windows Server 2016. Can Oracle Database be prepared to run this way?
0
votes
1answer
577 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 ...
5
votes
1answer
10k 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 ...
2
votes
1answer
4k 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
68 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
1answer
122 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
154 views

RSAT on Windows 10 fails to add node to server 2016 cluster

I have been testing server 2016 failover clustering. I have 3 hyper-v VMs running server 2016 core. I installed the RSAT tools on Windows 10 Pro to use the failover clustering wizard. I cannot add a ...