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
150 views

What are the risks if you rename a server that hosts a named instance of SQL Server (2005) and skip updating the system metadata?

My apologies as this is the last SQL 2005 instance we have and it's pretty urgent or I wouldn't go through all this trouble asking. Questions What is the risk to leave things as they currently are, ...
0
votes
1answer
770 views

Access SQL Server Configuration Manager on a remote server

I am trying to add a traceflag as a startup parameter to a distant SQL Server 2016, installed on a Windows 2016 core server and I am following these instructions At this point in the document: ...
9
votes
4answers
2k views

Increased memory to server, but do I need to change page-file size?

I'm running SQL Server 2017 on Windows Server 2012 R2 and have increased the memory from 256 GB to 512 GB. I've noticed the following configuration for Virtual Memory: C: [OS] = 2 GB G: [DATA] = ...
0
votes
1answer
206 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 ...
0
votes
1answer
28 views

Can I use LetsEncrypt to secure SQL Server?

I am running SQL Server 2014, and use LetsEncrypt to encrypt some websites on the server. I want to remain PCI compliant, which requires an encrypted connection to the database, if accessing from ...
1
vote
1answer
314 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 ...
0
votes
0answers
21 views

Is It Possible Backing Up Postgres Backups To Windows Backup Server With PgBackRest

I want to take my postgres backups to our backup backup server which works on windows server, with pgbackrest. My postgres databases are on CentOS/7 OS. I can take those backups to my local but i want ...
1
vote
1answer
443 views

MariaDB on Windows Server 2012 R2 - out of memory

I have two servers, one with Windows Small Business Server 2008 and the other runs Windows Server 2012 R2. The servers have running multi master replication. Both uses MariaDB 10.2.6. On the old 2008 ...
2
votes
2answers
51 views

PowerShell command 'New-Item' fails when invoked through SQL Server Agent job

I have the following PowerShell script to create a folder at a share location. The share has full control permissions for everyone. I have granted all permissions for testing. The problem is the ...
1
vote
2answers
5k 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 ...
2
votes
1answer
258 views

SSRS ReportServer_XXX.log is giving incorrect CPU count

I am currently investigating an issue wherein sometimes the SSRS just suddenly stops accepting requests until we do an IISRESET command. This happens after we added an additional processor on the ...
0
votes
1answer
22 views

MySQL DB Causing Spike-up on Windows Server CPU

This is a Magento application connected to MySQL Db. When I ran show engine innodb status\GI get a list of TRANSACTIONSand it looks like some of them are pending and others are in a DEADLOCKand it ...
3
votes
1answer
405 views

MySQL Create Table with Partition Very Slow on server machine

Following create table statement with Partition runs in 10 Second on My Development Machine windows 7, i5 , 8GBRam, single disk runs in 16 Second on Virtual Machine windows server 2012 , xeon 2GHz , ...
0
votes
1answer
139 views

High CPU usage on fresh new install of MongoDB

I read a lot of post about high CPU usage of Mongo but almost all relates to queries. I just did a fresh install of MongoDB 4. I have no other databases than the default one. As soon as I start the ...
2
votes
1answer
3k views

SQL Server 2012 Installation Error on Windows 2008 Server

I am facing an error while trying to install SQL Server 2012 EXPRESS ADVANCED EDITION(32bit) on Windows Server 2008 Enterprise(64bit). After passing Rule Check, at install updates section, error ...
1
vote
2answers
109 views

How can I create a Windows Firewall rule to allow only one IP address to connect MS SQL 2017 Express database in Windows 2016 server?

I use MS SQL 2017 Express database in Windows 2016 server, now my MS SQL 2017 express server is being attacked. I hope to set a Windows Firewall rule to allow only one IP address (such as 45.23.56.12)...
0
votes
1answer
2k views

Why does max_connections in my.ini not match concurrent connections in Mysql instance config wizard?

MySQL 5.1.x | Windows Server 2003 Can someone please clarify why max_connections in my.ini is much larger than the manual value I specify in the Concurrent Connections Dialogue? For example, if I ...
10
votes
2answers
6k views

SQL Agent - PowerShell step “syntax error”

I have the following code setup in SQL Agent Job step that is not running. The message received is simply: Unable to start execution of step 1 (reason: line(46): Syntax error). The step failed. ...
0
votes
0answers
21 views

SQL Server Service has stopped, but process still appears in TaskMgr

A customer has the strangest situation. Windows Server 2016 with SQL Server 2016. There is only one SQL instance on the machine (the default). Service name: MSSQLSERVER. The service take a very long ...
0
votes
1answer
128 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 ...
2
votes
0answers
53 views

SQL Browser Service Stops After One Minute

I am encountering an issue with the SQL Browser service where the service will start, run for around 60-90 seconds and then stop. No error is logged, the event logs show three informational entries: ...
-2
votes
2answers
62 views

Unable to install SQL Server Express 2014 on Windows Server 2008 R2

I'm trying to install SQL Server Express 2014 on Windows Server 2008 R2. But the setup routine is giving me the warning message: System doesn't meet the minimum requirement for installing SQL ...
1
vote
1answer
152 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
1answer
258 views

MySQL restrict specific login to single ip address

i am trying to setup a mysql server with some logins that can be accessed from anywhere, and another login ( effectively root access ) from a single machine with a static ip. both machines have a ...
0
votes
0answers
8 views

Windows 2016 server with .NET version 3.5 having issue with connecting to mongo 3.0 replicaSet

We have a mongo server version 3.0 and driver version 1.11.0.92 and windows server 2016. I see other posts related to this but our code works well in Windows 2008 server with mongo version 3.0 and ...
0
votes
1answer
35 views

Windows Server and SQL Server updates and patching - and how to rollback (revert) if necessary

Say we have a server as SQL Server 2017 on Windows Server 2016, both have some pending updates recently Below few questions: What's the correct order of installing updates - first Windows, and then ...
1
vote
4answers
495 views

Windows Logs Application is full of “Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: ****]”

I have Windows Server 2016, with SQL Server 2017, and found Windows Log Application is full of Login failed messages (as follows) : Login failed for user 'sa'. Reason: Password did not match that ...
1
vote
1answer
569 views

MySQL Workbench, Windows Server 2019, MySQL not showing Performance, Information of MySQL Schemas!

This evening I installed MySQL on a new clean install of Windows 2019 server. When the install finished, the installer offered the possibility of opening Workbench so I said yes. Then I noticed that ...
9
votes
4answers
44k views

I need the reason why we should not install SQL server on the domain controller

I am a system administrator for a small firm. Now we consider to rollout Windows Server 2008 R2 for the firm. We plan to implement Active Directory. We would also like to upgrade RDMS, from SQL server ...
0
votes
2answers
113 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 ...
2
votes
1answer
521 views

DB2 doesn't start after change db2 hostname

After changing the hostname of my db2 server, the db2 services won't start anymore. After reading the notes on how to rename the db2 hostname I understand what went wrong, some things should have ...
0
votes
2answers
397 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 ...
-1
votes
1answer
10 views

Postgresql Error

I found below errors in logs , Transaction stop logging in my database 2019-11-19 15:48:25 UTCERROR: could not open file "base/16384/16464.3" (target block 858400): No such file or directory 2019-...
2
votes
1answer
253 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/...
2
votes
0answers
80 views

ODBC Driver Manager Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303) - Windows Server 2012 R2

I have a problem with adding MySQL server via linked server to my SQL Server Database Following this instruction unfortunately just does not work out for me. I added four data sources, 2 using 64-...
2
votes
2answers
69 views

SQL Server on Windows Server (VMware) - online storage swap

I have a VM cluster designed to store multiple SQL Server instances. We use variety of storage providers (i.e. 3PAR, XIV) which have to be changed now (not relevant to what brand). On Oracle on Linux ...
0
votes
1answer
119 views

error writing input to commandERROR: Invalid username and/or password

This is the error I have been getting on my RMAN notifcations on my backup jobs for the last day or so. The title is exactly how the message is formatted. ~~~End Step Output/Error Log~~~ Error Log:...
1
vote
1answer
457 views

Cannot add Network Service as User/Login

I want to setup ProGet on a 2016 server with SQL Express and IIS. Both the service and IIS web runs under the Network Service user. None seem to be able to access the Database on a local SQL Express ...
3
votes
2answers
80 views

SSMS cannot connect remote server by IP through Windows authentication

I'm trying to connect a remote server by IP,port via Windows authentication. It will end out with the following error Connection Timeout Expired. The timeout period elapsed while attempting to ...
1
vote
0answers
154 views

Is it possible to reset SA password without stopping SQL Server Service?

I lost a password for sa account. Now I want to reset SA password and at the same time not to restart SQL Server Service or going into single-user mode. I would like to mention that I am windows ...
0
votes
1answer
22 views

Why does a fresh SQL Server instance with the same details as the original think that my DB backup is in the original location?

So I'm working on a server application for a large government body and need to setup a development environment to test on. For this I'm using a Vagrant-controlled VM with Windows Server 2019 installed ...
2
votes
1answer
255 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 ...
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 ...
5
votes
2answers
18k views

SQL Server Service Account login or password is not valid error

I am trying to install SQL Server 2012 Express on a Windows 2012 Server for test purposes. This machine is part of our company domain. During installation I am trying to use one of domain account ...
2
votes
1answer
386 views

Startup Parameters greyed out in SSCM for new instance

We do not appear to be able to change the startup parameters for a new SQL Server instance, using SQL Server Configuration Manager (see screenshot below). We are members of the sysadmin fixed server ...
0
votes
1answer
154 views

SQL server agent unable to establish connection

I have recently installed sql server 2014 enterprise version on windows 2016 server. For some reason sql server agent is not starting but sql server service is up and running. I am not really sure ...
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
1k 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
votes
1answer
385 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 ...
8
votes
3answers
47k views

Moving SQL Server to different domain

What are best practices/important steps when the Windows Server machine hosting SQL Server 2008 R2 is moved to another domain? What steps definitely/might need to be done for SQL Server before and ...

1 2 3 4 5 8