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
0
votes
0answers
120 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 ...
3
votes
0answers
71 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 ...
2
votes
1answer
65 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
votes
2answers
6k 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 ...
0
votes
1answer
79 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 ...
0
votes
2answers
453 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 ...
0
votes
1answer
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. ...
2
votes
1answer
276 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/...
0
votes
0answers
366 views

High disk usage by Windows Server when executing SSMS

Every time we execute SSMS on Windows Server, there is a high disk usage System process for ntuser.dat.LOG, as seem at Resource monitor: The write rate is between 2 MB/sec and 8 MB/sec. Why do we ...
0
votes
0answers
248 views

Not able to run mongorestore job from schedular task on windows

I have a Shell Script under which restore command is mentioned for restoring the DB from target folder. My File name will be mongorestore.sh NOTE: Dump data location will be E:Backup/test #!/bin/...
3
votes
1answer
12k 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 ...
0
votes
1answer
640 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?
1
vote
2answers
489 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
0answers
70 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
2answers
864 views

MySQL - Service Name in Windows

What is the MySQL service name? Get-Service | where{$_.name -like "*MySQL*"} Is that correct?
2
votes
1answer
261 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 ...
0
votes
1answer
800 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 ...
3
votes
1answer
24k 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
41 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
397 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
votes
2answers
5k 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
0
votes
0answers
1k 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 [...
0
votes
0answers
140 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 ...
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
755 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 ...
0
votes
1answer
628 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 ...
0
votes
1answer
488 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 ...
0
votes
2answers
93 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
0answers
395 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 ...
0
votes
1answer
38 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 ...
0
votes
1answer
310 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 ...
0
votes
2answers
119 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 ...
0
votes
0answers
713 views

Adding Azure VM as 3rd node to the 2-node On-Premise Windows Server Failover Cluster - Problem

We have 2-node WSFC, which is hosted on-premise in our datacenter This WSFC is running one clustered role which is SQL Server Availability Group Node-1: Windows Server 2016 - two subnets - 192.168.7....
1
vote
3answers
7k 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 ...
3
votes
2answers
4k 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 ...
1
vote
0answers
31 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 ...
33
votes
4answers
12k 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. ...
-1
votes
1answer
2k views

Sql Server Error 18452 The Login Is From An Untrusted Domain

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 ...
1
vote
1answer
359 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
682 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
0answers
873 views

Primary Server is “Resolving state” & Quorum node is in “failed” state

I would like to say that in my environment I have a 2 node in WSFC with the nodes SQLServer-01 (Primary Server) SQLServer-02 (Secondary Server) And for third vote in cluster also One (File share ...
2
votes
1answer
4k views

How can I troubleshoot issues with dynamic registration?

For testing I have been trying to install Oracle 11g on a test system with a single database several times with the aid of snapshots. This most recent iteration I have been having issues getting the ...
0
votes
2answers
1k views

how to run SSMS as a different user?

I am running SSMS as a different user from my local machine and it works fine. When I try to do the same, even using my own credentials, on server01 I get the following error: access is denied I am ...
0
votes
4answers
75 views

Upgrade my server or migrate it to a new server [closed]

I have a two servers, one is application server that runs with Windows Server 2003 and one SQL server runs with SQL 2008 and windows server 2003 OS. I would like to upgrade the both servers' OS to ...
0
votes
1answer
134 views

EMCA insists that it cannot connect to the service

Really new to Oracle and being a DBA in general. I am trying to set up a development environment so that I can play an learn oracle better. Enterprise Mananger failed to configure itself when I first ...
1
vote
0answers
222 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?
2
votes
1answer
3k views

Throttling SQL Server database cpu usage

I'm wondering if there is away to limit specific database from using server's resources like setting max CPU and RAM for each database [simpler to IIS App pools]? I'm working with SQL Server 2014 ...
3
votes
1answer
7k views

Missing assembly when running PowerShell script using SMO

I wrote a script which takes database name, restored DB name, backup source, data file location and log file location as parameters and performs database restore on SQL Server instance. Script works ...
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 ...
0
votes
1answer
348 views

Known Good SQL Logins Failing (Error 18456) Accompanied by “Unable to Reuse a Session” (Error 18056)

I am losing my patience with this problem. I did see a couple of other questions here that are similar, but I've already looked at the fix actions that resolved their issues and they did not apply ...

1 2
3
4 5
8