Stack Exchange Network

Stack Exchange network consists of 174 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]

All versions of Windows Server. Please also add a version-specific tag like windows-server-2012 if that is relevant to the question.

-1
votes
2answers
51 views

SQL Server Express 2017 Database Mail Silent error

I have made an installation of a development environment in VMWare that contains: Windows Server 2016 SQL Server Express 2017 The objective is to perform migration tests of a base that is currently ...
0
votes
1answer
143 views

Maximum concurrent connections to SQL Server Express 2017 installed on Windows Server 2016 Essentials

If I install SQL Server Express 2017 on Windows Server 2016 Essentials, what is the maximum number of users that will be able to connect concurrently across the network to the SQL Server Express ...
-1
votes
1answer
25 views

What are the permissions needed for User which is used to connect a data source which is used in TypePerf windows utility? [closed]

I am logging performance counter data to tables using TypePerf utility and i need to pass DSN(data source name). In DSN, I need to specify the user to connect to the server where i'll be logging my ...
0
votes
1answer
202 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
vote
0answers
28 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 ...
3
votes
1answer
157 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 ...
0
votes
1answer
31 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
1answer
68 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
122 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
78 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
0answers
22 views

Azure premium storage on Dsv3 VM

I am new to Azure VM's and I am going through General purpose virtual machine sizes. In there under "Dsv3-series" it says we can use Premium storage. But if I go through the premium storage page, it ...
0
votes
0answers
80 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/...
1
vote
2answers
242 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
43 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 ...
2
votes
1answer
173 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 ...
-2
votes
2answers
1k 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
661 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
97 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
569 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
99 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
0answers
360 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
0answers
29 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 ...
0
votes
1answer
85 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
431 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 ...
3
votes
2answers
855 views

SQL 2016 low TPM with HammerDB-Test

we have some trouble with a fresh installed MSSQL 2016 Server. The Server is a virtual VMware Machine using VMware's Best Practice. We have used the HammerDB-Tool to test TPM with TPC-C Standard. ...
2
votes
3answers
391 views

Memory Consumption on Database Machine

My Database server is consuming 71% - 75% percent of RAM memory, I can see from perfMonitor logs that SQL_Service is eating up 65% - 69% of RAM memory. We carried out different operations to lower ...
2
votes
0answers
343 views

SQL Server 2014/2016 (Win2K12R2) and Winsock limits - how to cope?

We're experiencing a problem with connections to SQL Server and after a week of digging through I was able to pinpoint it to Winsock limits. Here's the description: We have SQL Server 2014 (and 2016) ...
1
vote
0answers
29 views

Hard Drive Controllers Importance and fail prevention tips/techniques in SQL Server? [closed]

What is Hard Drive Controllers and what is the Importance of using in Windows (MS SQL SERVER)? Recently we experienced Hard Drive Controllers card failed on Demo Environment (Database in Restoring ...
0
votes
0answers
147 views

designing new PGSQL server hardware

I currently run Postgresql on a virtual machine on a host with the following spec: 36 bay Storage Node, 2x E5-2630 CPU, 128GB RAM, LSi megaRAID The DB is used for large research datasets, so large ...
0
votes
2answers
86 views

Best way to get SQL Server databases on small capacity VPS

I have several small sites and I've just rented a Windows VPS server with 1&1. It includes 2 "vCores", 4 GB RAM and 120 GB SSD. It runs great for my needs but now I need to determine the best way ...
2
votes
0answers
296 views

SSIS 14 - Buffer Memory - Good practices

I've a some packages in SSIS 14 in order to extract the data from a lot of operational databases and load into my Data Warehouse. I've the following virtual machine: Windows Server R2 Standard RAM:...
2
votes
0answers
45 views

Failover Cluster : Environment - SQL Server [closed]

I am trying to setup an SQL Server test environment as I need to familiarize myself with some functions which I am not exposed to during my daily job. As a part of a side task I wanted to setup ...
3
votes
2answers
974 views

Best use of RAM for multiple SQL instances?

I have a new Windows Server 2016 box with 32GB of RAM, it will be used for dev testing by one or two users max. There will be occasional use of VM/Hyper-V instances and a couple of IIS test sites ...
1
vote
1answer
609 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
2answers
3k views

frm-92100:your connection to the server was interrupted

frm-92100: error I use my using internet explorer & JInitiator 1.3.1.13 using oracle 11g and dev9i windows server 2008 R2. The app was running fine for last 2 years but suddenly this happen. I ...
0
votes
1answer
35 views

Not able to install MSSQL 2014 on an additional disk(some disk other than the OSdisk) silently on Windows 2012 R2

I am providing the following paths during installation(and yes, there's no overriding anywhere)- InstallSQLDataDir = "R:\Microsoft SQL Server\Instance" SQLBackupDir = "R:\BACKUP\Microsoft SQL Server\...
0
votes
0answers
89 views

Very slow performance querying sys.dm_os_performance_counters

We have a query which essentially does a SELECT * FROM sys.dm_os_performance_counters WHERE object_name = @sobj AND counter_name = @scnt Normally this is instant, but one some systems, this query ...
0
votes
1answer
836 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 ...
3
votes
1answer
64 views

Should Database Servers Be Defragmented?

I've never been clear on this point - should Windows servers running SQL Server ever be defragmented with a tool such as Smart Defrag or Windows' Disk Defragmenter?
1
vote
1answer
11k 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
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
575 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 ...
0
votes
0answers
311 views

Replication after Master down in Master-Master schema in MySql

I have set up a Master to Master replication scheme. I have 2 Master server: server A and server B. Server A is configured as follow. my.ini server-id = 1 binlog_do_db = example log-bin=mysql-...
1
vote
1answer
144 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 ...
0
votes
1answer
143 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
785 views

Patching strategy when Windows and SQL Server patches not applied for over 3 years

The company I'm at hasn't patched their production servers for a while, neither SQL 2012 or Windows 2012. When I say "for a while" I mean, well, actually "never" - no patches or updates since the ...
1
vote
1answer
2k views

Oracle TNS Permission denied when creating database

I hope you can help me. I need to restore an Oracle 9i (9.2.0.6.0) database on a Windows Server 2003 R2 x64 from a cold backup. I managed to get the 9i installer and the version patch (since I was ...
3
votes
1answer
346 views

Copy SQL DB files/backups

We have a task to copy 2TB of DB files/backups over LAN in a most efficient and speedy way. We are brainstorming amongst our team to come up with a best solution. These files are multiple backups and ...
0
votes
1answer
956 views

SQL server Virtual account and folder permissions

How does SQL server 2012 still work after changing the Service account to a domain account or even a local account. For example: as mentioned in MSDN https://msdn.microsoft.com/en-us/library/...
7
votes
1answer
24k views

Configuring SQL Server 2016 to allow remote connections

I have SQL Server 2016 installed on Windows Server 2016 Core. Locally, it seems to be working. I can connect using SQLCMD.exe and do some basic selects and what not. From remote, I cannot connect. ...