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.
437
questions
1
vote
0
answers
272
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 ...
- 1,761
0
votes
0
answers
59
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,
...
- 15.8k
-1
votes
1
answer
591
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 ...
- 1
1
vote
0
answers
38
views
Can I remove some of our disk allocation?
I've started work for a new company who are using Azure for their SQL Databases.
As one of my first tasks, they've asked me if they have too much storage (expensive storage), and would like to remove ...
- 71
3
votes
2
answers
2k
views
SQL Server Agent Services not Coming Up
After the Windows Server 2008R2 was restarted after some planned downtime, the SQL Server Agent Service is not getting started. There are multiple SQL Server named instances and Agent Services of non ...
- 397
7
votes
2
answers
5k
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 ...
- 536
1
vote
2
answers
654
views
SQL Server 2014 Standard FCI Does Not Failover
Have a peculiar case where a previously working FCI, after installing a large backlog of Windows updates, is now failing often and not failing over. On occasion, and this appears to happen around ...
- 123
1
vote
2
answers
15k
views
Why have SQL Server services disappeared from services.msc?
I'm running an Always On Availability Group with 2 SQL Server 2014 database servers in an AD domain. Updates are supplied to all domain servers via WSUS. Also have a third MS Reporting Services server ...
0
votes
1
answer
93
views
Best High Availability Solution for SQL Server 2014
Please we are about to implement High availability for for SQL server 2014 on our new infrastructure but i need to know which is best between SQL Failover Clustering and Always On High Availability ...
1
vote
0
answers
1k
views
clussvc.exe consuming high cpu
We have a 4 node cluster running 2 SQL Failover Instances.
Windows 2012 Standard & SQL 2014
Microsoft Failover Cluster Service has been consitently between 25 - 30 % CPU. This is happening on 2 ...
1
vote
1
answer
356
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?
0
votes
1
answer
1k
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.
1
vote
2
answers
887
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 ...
- 21
0
votes
1
answer
79
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 ...
- 625
0
votes
0
answers
277
views
Remove node from failover cluster without access to said cluster or domain
I have a server running Windows Server 2012 and SQL Server 2008 R2. The server used to be part of a SQL cluster but it is now standalone and no longer has access to the cluster.
I want to repurpose ...
- 629
3
votes
0
answers
78
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 ...
- 31
2
votes
1
answer
164
views
Log Shipping with Failover Cluster Server Cores
Failover Over Cluster 2 Node - 6 Cores- Enterprise Edition 2014
Log Shipping with Cluster with 4 Core License- Enterprise Edition 2014
My question is if I need to log ship do I need to match the ...
- 1,021
-1
votes
2
answers
8k
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 ...
- 167
0
votes
1
answer
99
views
Copying Oracle datafiles to a system clone
We have an Oracle 11G R2 on Windows 2008 R2.
One night, a windows update package caused our Oracle Instance to be down (no way to connect using sqlplus. we believe it's a network, NIC issue.).
We ...
- 103
0
votes
2
answers
1k
views
How to restrict SSMS to list the database of a particular user (Windows 2012 + Plesk)
We are using windows 2012 R2 server with Plesk and provide shared hosting for our customers.
Version Details: MSSQL server 2012 and SSMS 11.0.2100.60
In SSMS if we login with particular user, it is ...
- 129
0
votes
1
answer
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. ...
- 1
2
votes
1
answer
947
views
GSSAPI on MariaDB
I'm using Maria 10.2.13 on Windows Server 2012 and I want to use GSSAPI authentication with it so that we can continue using windows auth.
I have followed this tutorial:
https://mariadb.com/kb/en/...
- 131
3
votes
1
answer
15k
views
Application Server is not able to connect to SQL Server database when TLS 1.2 or 1.1 is enabled
In our environment, SQL Server 2012 Servers whenever TLS 1.2 or TLS 1.1 is enabled Application Server is not able to connect to the database.The same issue is observed only on MS SQL Server 2012 ...
- 31
0
votes
1
answer
905
views
Can I Configure Enterprise Manager Cloud Control on Standard Edition
Is it possible to configure enterprise manager cloud control on Oracle 12c Standard edition?
Will it administer multiple databases (Non-CDB)?
What about administering databases on different servers?
- 434
1
vote
2
answers
827
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?
- 53
1
vote
0
answers
78
views
How to set processes parameter in oracle 11g Windows in accordance with RAM in the server
Could anyone explain me whether there is any limitation in setting processes parameter in Oracle 11gr2 and how to set sga_target according to this.
Right now I have set the processes to 4000 and I ...
0
votes
2
answers
2k
views
MySQL - Service Name in Windows
What is the MySQL service name?
Get-Service | where{$_.name -like "*MySQL*"}
Is that correct?
2
votes
1
answer
397
views
Cosmos DB ODBC driver installation problem
We are trying to install Cosmos DB ODBC Driver following the instructions provided in this Microsoft Azure resource and are running into the following error:
The setup routines for Microsoft ...
- 21
0
votes
1
answer
1k
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 ...
- 111
5
votes
2
answers
70k
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 ...
- 51
-2
votes
2
answers
72
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
1
answer
822
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) ...
- 2,628
-2
votes
2
answers
7k
views
Connecting to Database using powershell [closed]
I'm trying to connect to my database using PowerShell but it's not find it even though I can see it using SSMS.
I'm trying to follow the example MS provides here
- 149
0
votes
0
answers
2k
views
Installing SQL Server using config.ini
I'm trying to install SQL using a config.ini file but it doesn't seem to accept the parameters set in the file.
For example, at the top of my file I have:
;SQL Server 2017 Configuration File
[...
- 149
0
votes
0
answers
169
views
Just use WSFC without Always On Failover Cluster Instance? [duplicate]
There was some unanswered questions about the difference between "Windows Server Failover Clustering" and "Always On Failover Cluster Instance".
From MS document:
A Windows Server Failover ...
- 135
1
vote
1
answer
2k
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 ...
- 125
1
vote
1
answer
2k
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 ...
- 11
0
votes
1
answer
1k
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 ...
- 1,490
0
votes
1
answer
839
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,490
0
votes
2
answers
97
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 ...
1
vote
0
answers
879
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 ...
- 1,134
0
votes
1
answer
40
views
Un-Install OS Patch (KBs) in Physical PRODUCTION Servers - Consequences [closed]
We have our PRODUCTION Database and Application Servers which are Physical Servers .
Recently , the October month OS Patches (specific KBs) are little problematic and reported by Microsoft too that ...
- 1,580
0
votes
1
answer
485
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
...
- 158
0
votes
2
answers
232
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 ...
- 218
2
votes
3
answers
10k
views
SQL Server CPU usage is overloaded sometimes
We do have a couple of servers, one is dedicated to the website without SQL and the other server is dedicated to SQL.
Now the server running SQL is quite powerful, yet sometimes the server CPU is ...
- 123
3
votes
2
answers
9k
views
Why should I install both 32 and 64 bits Oracle provider for the same machine?
I needed to read an Oracle DB from SQL Server, so I had to install the Oracle provider (ORAOLEDB.Oracle).
My machine:
System: Windows Server R2 2008 Enterprise, 64 bits (SP1).
RDMS: Microsoft SQL ...
- 131
1
vote
0
answers
32
views
How to handle large sized oracle databases in a windows server
My Production database is having 188 GB size. The server handling the db is having C Drive with a space of 250 GB.
My database is growing rapidly.I don't think this database is having much size ...
35
votes
4
answers
18k
views
Slower SQL Server performance after allocating more CPU and RAM
We have SQL Server 2008 R2 (10.50.1600) running on a virtual Windows 2008 R2 server. After upgrading the CPU from 1 core to 4 and the RAM from 4 gb to 10 gb, we've noticed the performance is worse.
...
- 505
-1
votes
2
answers
4k
views
Sql Server Error 18452 The Login Is From An Untrusted Domain [closed]
I have two MS SQL databases under the same server: I connect normally to one of them using MS SQL Server Management Studio with Windows Authentication but when I try to connect to the other I get the ...
- 99
1
vote
1
answer
699
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 ...
- 51