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
617 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 ...
0
votes
1answer
20 views

Which full backup will be differential one based on?

I wanted to perform a differential backup of a DB in SQL Server 2008. I currently have a .bak file with a full backup and I want to add this new one in it. Will be the differential backup based on ...
3
votes
0answers
482 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. ...
0
votes
1answer
42 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 ...
2
votes
1answer
1k 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 ...
3
votes
3answers
6k views

MySql service on Windows won't start after changing datadir

Tried to change the data directory for a default Windows installation of MySQL. Here's the steps I've taken. Stopped the MySql service. Located the data directory of MySql and moved it to another ...
3
votes
1answer
2k 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 ...
0
votes
0answers
41 views

Memory Consumption [duplicate]

In one of our PROD Servers... The Total Physical RAM is 128GB The Total RAM I assigned for SQL Server is 122GB. When I checked the SQL Server there were no Open Transactions, No Blockings....But ...
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 ...
2
votes
1answer
2k views

Sql Server Brute Force Attack [closed]

I am running MS Sql Server 2008 on a Windows Server 2008 box. I noticed a slow down and random moments where my Sql instance failed to connect, and looking at the event log showed repeated (1-2 times ...
0
votes
1answer
160 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 ...
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
257 views

Two active + one passive node for failover clustering

I'd like to know if it is possible to have a single passive node for two SQL Servers in a failover clustering deployment. For example, both active servers A and B will use server C as their contingent ...
5
votes
1answer
4k 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 ...
3
votes
1answer
262 views

db_owner does not have access to Windows folders [duplicate]

This is MSSQL Server 2008 R2 running on Windows Server 2008 Enterprise. Service Instance is running as 'Network Service'. I have two logins, UserA and UserB. UserA is a sysadmin. UserB is a db_owner ...
0
votes
1answer
1k views

Oracle patch conflict [closed]

I'm attempting to apply patch 23530402 to Oracle 11.2.0.4 with OPatch 11.2.0.3.15 on a 64-bit Windows 2008 server. Our Tenable security software indicates this is one of two patches that must be ...
0
votes
1answer
572 views

Which is suitable db2 version on windows server 2012 server?

I am planning to install db2 database server on my client machine. So which version of db2 will be more suitable on windows server 2012 server db2 10.1.0 or db2 10.5.0 or any other ? ...
4
votes
2answers
810 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 ...
0
votes
1answer
1k views

What is the language of my SQL Server setup files?

Im trying to install SQL Server in my Windows Server in english . But got this error. I look for a solution and say I have to change the setting on Control Panel to match my media. The problem is ...
0
votes
1answer
3k views

Missing options in Feature Selection when installing SQL Server 2016 on existing server

I have a Windows 2008R2 64-bits server that already has 2 instances of SQL Server 2008R2 installed, and working fine. I want to add a new instance, but for SQL Server 2016, while keeping the existing ...
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 ...
0
votes
1answer
97 views

How to change SQL Server in a domain with a new server machine and latest SQL database? [closed]

We have an SQL Server in our domain. The SQL Server version is MS SQL 2000 and the Operating System is Windows Server 2003. Now I want to change the machine itself with new computer running windows ...
3
votes
2answers
533 views

user/login name on process unknown

SQL Server version is 11.0.5569.0. The user/login for the process on a server is as follows: S-1-9-3-412646706-1242810017-220819094-3312857753 This is not an orphaned user (as suggested below) ...
2
votes
3answers
2k 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, ...
0
votes
1answer
615 views

How to create a Windows user suitable for installing db2 server with extended security?

I'm trying to install db2 10.5 on Windows Server 2008 not as built-in "Administrator", but as another local user, but it fails to create instance with the symptoms similar to http://www-01.ibm.com/...
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
votes
1answer
45 views

How can i restrict remote login in SQL Server 2012 Express using management policies [closed]

Does anyone know method to restrict remote login using management policies.
0
votes
1answer
201 views

Rebuild Windows cluster for Alwayson.

I am setting up Alwayson,somehow my cluster is gone ( get-clusternode shows down,down,down and Joining). SQL Server is working fine. What Should I do? Create new cluster or build new server? Any ...
0
votes
1answer
207 views

MongoDB cannot be started after moving the server

I had a happy MongoDB 3.0.5 installed on a VM on a Windows 2012R2 Server, for light use. I moved the VM to a new physical server without any major changes, and to my surprise it cannot be started; and ...
1
vote
3answers
7k 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
32 views

Move a database (from decomisioned server) to an existing server with heavy ongoing loads

We have a situation where one of our database approx. 60 GB in size with transactions running every 2-3 mins 24*7 has to be moved, since the server it is on is going to be decommissioned. Now, we ...
0
votes
1answer
711 views

Automatic recovery on a 3 node AlwaysOn Multisite Cluster?

We are looking to build a 3-node AlwaysOn Windows 2012 R2 failover cluster with 2 nodes in our primary datacenter for HA, and a 3rd node replica in our DR datacenter for reporting. Given this is a ...
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 ...
3
votes
1answer
1k views

SQL Server 2012 failover cluster node won't start cluster services

We have 2 node SQL server failover cluster setup in our environment. Node2 SQL server machine got shut down. I turned it back on and connect back to the failover cluster. It successfuly ...
3
votes
0answers
58 views

How can I attach the SSL authenticated certificate for my SQL Server 2014 if it is not on domain controller

We have Microsoft Azure with Windows Server 2012 R2 in Cloud Computer and window Server is Standalone it is not come under domain controller. We want to add SSL authentication. SQL Server is not ...
0
votes
1answer
40 views

I created an index approx 5gb in size but the file system doesn't show any difference in free space

On a table with many millions of rows and two existing indexes (one clustered and one non-clustered primary key index) I created a third non-clustered non-unique index. Before creating this index, ...
0
votes
1answer
3k views

How to enable TLS1.2 for port 1433

I have received vulnerability on Microsoft SQL server 2008 (RTM) [high] [1433/tcp/mssql] TLS Version 1.2 Protocol Not Enabled TLS v1.2 is not enabled on this port. Already enabled TLS 1.2 on OS ...
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 ...
2
votes
1answer
4k views

Error installing Oracle Database Client 12c: “OracleMTSRecoveryService Control Utility has stopped working”

The installation of the "Oracle Services For Microsoft Transaction Server" component fails when I attempt to install Oracle Database Client 12c (12.1.0.2.0) on Windows Server 2012 R2. When ...
3
votes
0answers
585 views

Move SQL Server cluster from one location to other

I am looking for ideas on how to move SQL Server 2012(standard) two node cluster installed on Windows server 2012 standard to other location which is far away from current location. The two locations ...
-1
votes
1answer
54 views

Installing a Failover Cluster Instance on a Cluster already in use for Instances hosting Always On

I have been asked to install a SQL Server FCI on a 3 nodes cluster already hosting 4 different instances with Always On Availability Groups. While I am building the lab on my machine, I am wondering ...
0
votes
1answer
1k views

SQL Server 2012 on a Windows 2008 R2 cluster, would like to upgrade Windows to 2012 R2

I need someone to help validate a strategy. I have a pair of Windows 2008 R2 server in a active/passive failover cluster with SQL Server 2012 installed. I would like to upgrade the Windows OS to ...
2
votes
2answers
752 views

MongoDB not using all memory in Windows server

I have a stand-alone MongoDB instance running in windows. It's recently experiencing slowness and my troubleshooting has found the following symptoms. The slowness normally occurs after a full text ...
3
votes
0answers
122 views

SQL Server 2012 certificate encrypt connection

I'm not a DBA by trade. My organization doesn't have a dedicated DBA, we have to just figure things out. I have a SQL Server 2012 Enterprise installed on a Sever 2012 R2 OS. It is a not in a SQL ...
2
votes
1answer
1k views

Auto start pgAgent

When my windows server 2008 start, both services postgres and pgAgent start because they are automatic. But if my db is frozen and I need to restart the postgres service, the pgAgent is also stoped, ...
3
votes
1answer
10k views

Can't install Microsoft SQL Server 2016 Release Candidate 3 (RC3) on Windows Server 2008 R2

I am attempting to install Microsoft SQL Server 2016 Release Candidate 3 (RC3) on Windows Server 2008 R2. I have removed all other versions of SQL Server, and removed VS 2015 Community and all it's ...
3
votes
1answer
246 views

Security concerns on SMTP in SQL Server

In my company, while I try to get the ports opened to connect to my SMTP server from my SQL Server running on Windows Server 2012, I get a reply saying that it is a security concern to open ports ...
0
votes
1answer
724 views

SQL 2012 Availability Group issue - The core cluster resources do not move when we initiate AG fail-over

I have a Windows 2012R2 cluster with two nodes and a File Share quorum. I am running SQL 2012 SP2 and I have configured a test AG with a dummy database. When I fail-over the AG, the Availability ...
0
votes
1answer
212 views

Make a (copy of a) postgis database available to customer?

Our application uses a PostgreSQL database (with the PostGIS spatial extension). Now one of our customers has requested direct access to the database; because, as they claim, it’s their data. We’d ...
3
votes
2answers
2k views

Connecting to MySQL VM remotely (Azure Resource Manager)

I have a VM setup in Azure (running Windows Server 2012 R2) with MySQL 5.7 installed. I am trying to access this using MySQL Workbench - which when running on the server works perfectly. However, ...

1
4
5
6 7 8