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
0answers
46 views

Win 2019 + SQL Server 2014 slowly locks up the server

We have a 2019 + 2014 sql server box that was running fine for a few days after we first stood it up on Ec2. After a week I removed a temp drive (EBS) that we had initially used to load up the ...
0
votes
0answers
23 views

Connect google cloud storage bucket in MSSQL(2016)

I host a SQL Server Enterprise 2016 + Windows Server 2016 DataCenter on google compute engine. I'm going to use .bak file on my google cloud storage (GCS) bucket, to restore database on other folder ...
3
votes
2answers
131 views

Windows Server version and SQL Server

Is there a blog / webpage / information (I did not find anything) out there, if it has performance benefits, if I use a newer Windows Server version for my SQL Server? Example: I run SQL 2016 on a ...
1
vote
1answer
30 views

Which account should be used for the SQL Server Service logon account where the server has been added to a domain?

I have installed SQL Server 2017 Express onto Windows Server 2012 R2. I need to add a self signed certificate to SQL Server Protocols in order to enable wire encryption. This comes with a requirement ...
0
votes
1answer
35 views

Two physical servers with sql server on same network

IS there a way I can remotely access sql server DB having two different servers in the same network/public IP? The first Server is configured to listen to 1433 port but we make the connections using ...
0
votes
1answer
23 views

Configuring pg_admin 9.6 while there are users using it on Windows Server 20XX?

I read something about pg_ctl reload (I'm not sure if that's on the Windows distro of pg)...also is there a way to verify the configuration isn't going to break it completely, like apachectl ...
3
votes
2answers
238 views

Evict node from SQL Server 2016 Cluster on Windows Core

I have 4 nodes cluster on Windows Core with SQL Server 2016 installed on them (4 instances, 1 instance on each node). I would like to remove 2 nodes from the cluster (2 instances aren't needed). I ...
0
votes
0answers
31 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
votes
2answers
82 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 ...
1
vote
1answer
1k 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
27 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
321 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
29 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
2answers
360 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
34 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
121 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
270 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
190 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
139 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
370 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
63 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
234 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
3k 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
977 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
121 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
939 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
378 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
554 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
30 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 ...
1
vote
1answer
201 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
553 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
1k 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
548 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
482 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) ...
0
votes
2answers
103 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
422 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
2answers
1k 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
729 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
4k 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
36 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
111 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
1k 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 ...
2
votes
1answer
85 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
12k 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
666 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
160 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
175 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
907 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 ...