Questions tagged [windows]

Operating system produced by Microsoft. Windows is produced in various desktop and server versions. Please also add a version-specific tag like windows-10 if that is relevant to the question.

Filter by
Sorted by
Tagged with
0
votes
0answers
7 views

Do we need to shutdown DB/Stop DB service before Windows server patching

Before patching Windows server, do we need to shut down any DB or stop DB service. If we need to shutdown a MongoDB on a node(Windows server) which is part of a replica set, what we need to before ...
0
votes
0answers
19 views

Getting “unknown variable postgresqlini” when updating PostgreSQL

I am getting an error when attempting to upgrade a PostgreSQL installation. The full error is: A data directory is registered in ***unknown variable postgresqlini*** but is neither empty or a ...
0
votes
1answer
66 views

How to resolve MDF and LDF files remaining in use?

I am attempting to copy off approximately 220 gigs of database MDF and LDF files from a MS SQL server 2000 install in order to transfer ownership to a third party. The error I get when I try to stop ...
1
vote
1answer
18 views

Reset mongo cache memory for test perfomance - windows

recently i'm working on mongo db and I'm trying to check the performance of mongodb with 2 million record. I need to clear cache every time I start the test. I don't want to restart the computer/...
0
votes
2answers
48 views

Load PostgreSQL database from corrupt drive [duplicate]

I suffered corruption of a hard drive but managed to recover files for a PostgreSQL server. We are running on the assumption that the files themselves are not corrupted (yet to be able to tell). My ...
0
votes
0answers
11 views

posgres instance is listening to old port even after changing to new port number

My machine is having posgres server 11th version,for testing purpose i installed another posgres instance(12 version )in same machine.i changed port number of this new instance to 5433 but when i try ...
3
votes
1answer
282 views

In the context of another principal what permissions hinge on the identity of the database owner?

By "database owner", here, I mean the principal whose SID is sys.databases.owner_sid. This answer to the question of best practices for database ownership includes the following: The answer here ...
13
votes
2answers
2k views

Why is database ownership by groups not allowed? Which user should own a database?

Per microsoft "ALTER AUTHORIZATION for databases for SQL Server": Requirements for the new owner: The new owner principal must be one of the following: A SQL Server authentication ...
1
vote
1answer
241 views

Building Oracle XE docker image in Windows 10 Pro

I'm trying to install Oracle XE 18c in a docker container in Windows 10. I have docker already installed, and I need to build the image as explained here. I cloned the git repository, but I'm stuck ...
0
votes
0answers
21 views

Ingres ODBC driver not working

I recently installed an Ingres database as part of an application install. When I try to view its ODBC though it returns the following screen. A majority of the text has been replaced with ERget: ...
0
votes
1answer
80 views

Secure postgres 9.5 database packed on Windows desktop application

My desktop app includes a postgres database and a front app. I need the db to be accessed only by my front app. The credentials of this user are going to reside in the front app binaries. I realized ...
-1
votes
1answer
23 views

Trying to perform an update command on MySQL to insert a column of data is taking over 5 minutes. What can I do to debug this?

I have an application where it join two tables from two different MySQL DBs and with the resulting table from that join, update a column on another table in another DB. The resulting data from the ...
0
votes
0answers
24 views

Hyper-V Live-Migrating MongoDB Server

Does anyone know if DBs in general or in this case a Centos 7.x box running mongoDB would have corruption or any issues for that matter, if Live migrated from one host to another ? These are hosted ...
1
vote
1answer
94 views

Different default innodb_buffer_pool_size on Windows with MySQL 8.0.18

I have installed MySQL 8.0.18 Community with the same configuration (mysql-installer-community-8.0.18.0.msi installer, custom install with server + workbench, standalone server, legacy authentication, ...
1
vote
1answer
36 views

Programming query execution Postgres

I need to execute update querys routinely over a Postgres table. Is it possible to program an automatic execution of the query, let's say, every day at 15:00 hs? The Postgres version is 9.5, I'm ...
0
votes
1answer
24 views

Why is it necessary to run both mongod and mongo.exe in windows? What's happening behind the scene?

Why is it necessary to run both mongod and mongo.exe in windows? What's happening behind the scene? What's the difference between these two?
0
votes
1answer
183 views

How to have more verbose logs for mysqld startup

I have installed MySQL 8.0.17 via the official installer for Windows. I am starting MySQL like this mysqld --log-error-verbosity=3 \ --console \ --defaults-file='c:/mysql/etc/my....
0
votes
1answer
162 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 ...
0
votes
1answer
29 views

Oracle 11g connectivity over windows based client-server net [closed]

I have two PCs as follows: I want to create network for both PCs and share Oracle database from PC1 PC1 (windows 10 Pro 64-bit operation system) - Oracle 11g Installed PC2 (windows 10 Pro 64-bit ...
0
votes
0answers
31 views

Adding login of a pc on the network - Microsoft SQL Server Management Studio 2014

I have a small office network and I am trying to add new logins for the other PCs on Microsoft SQL Server Management Studio 2014 (all computers are Windows 7). I cannot seem to find the other ...
0
votes
2answers
93 views

How to use pg_archivecleanup on Windows

Trying to figure out a proper way to clean old WAL files located in archive directory for point in time recovery purposes. I know I can use hard-coded name of WAL segment something like this: ...
1
vote
1answer
992 views

pgAgent service for PostgreSQL does not run

OS: Windows 10 PostgreSQL 11.4 I Installed PgAgent with Stackbuilder setup. In Windows services; PostgreServer service is running. However, the pgAgent service is stopped. When I try to start ...
0
votes
0answers
239 views

Unable to start PostgreSQL service after pgAgent installation

I had Postgre running just fine on my Windows 10 (64-bit). Then I tried to install pgAgent via the stackbuilder for postgres. I got some error that it was not able to create a .conf file under %\...
1
vote
1answer
41 views

mysql workbench - Couldn't find option to remove DROP TABLE IF EXIST

Recently I've been looking into export options to find an option to remove: DROP TABLE IF EXISTS and replace it with CREATE TABLE IF NOT EXISTS. I've seen on other MySQL clients like HeidiSQL or ...
0
votes
2answers
85 views

SQL*Plus - interactive mode on windows

How can I issue commands through SQL*Plus on Windows? In Linux is like this: sqlplus -s /nolog<<EOF conn username/password@database EXECUTE some_proc; EXIT; EOF And Windows?
1
vote
1answer
286 views

Windows Login can't access SQL Server even with SYSADMIN role

I'm working on AD permissions and have removed my user account from the Domain Admins security group. Now I'm having difficult accessing my SQL Server database with my Windows login. The login is in ...
0
votes
0answers
14 views

Trying to create 2nd instance of mariadb on windows server

I have a windows server with MariaDB (10.2.14-MariaDB) and I'm trying to install a 2nd instance on it. I have 1 instance working using port 3307. I used mysql_install_db to install it on port 3307. I ...
1
vote
2answers
522 views

Locale is incompatible error in Postgresql 10 when replicating from Ubunu to Win 10

The locale available in my Ubuntu PG-10 DB is en_US.UTF-8. When doing PG_Basebackup to a PG-10 DB in Win-10, Psql failed to connect with error psql: FATAL: database locale is incompatible with ...
0
votes
0answers
69 views

missing the OracleOraDB12Home2TNSListener service

I have just completed the installation of the Oracle 12c database, following this tutorial. My OS is Windows 10. The installation has completed successfully, only green ticks. The problem is that, ...
0
votes
2answers
1k views

Postgres Windows post-install “The database cluster initialization failed”

I've seen many solutions and have been working on this issue for hours now. After installation the post-installation script fails with the message above. This is a development installation of ...
0
votes
1answer
52 views

Move Mysql database from Windows Xampp to Linux MySql Server

I 'am looking for a way to move some database in my local xampp to remote MySql Server , running into a Linux VM (Centos 7) Any idea or any suggestions to do this migration?
1
vote
1answer
112 views

Dynamic quorum and Dynamic witness in Always On AG 2016

I have a Always On AG 2016, configured on Windows Server 2012 R2 – 2 node cluster. Quorum configured as 2 nodes + Fileshare witness, totally 3 votes. Scenario 1: Now, either 1 node fails – remaining ...
1
vote
0answers
298 views

Oracle 18 on Windows with long hostnames doesn't talk to the local listener?

Note: Initially this was about installing Oracle 18c XE on a Windows machine with a long (> 15 chars) hostname. During our further tests we then noticed that Oracle 18c XE does not work properly at ...
0
votes
0answers
434 views

MySql Workbench Couldn't find section mysqld in the remote config file /etc/mysql/my.cnf

if you get this trying to connect to your remote server using MySql Workbench, then try to (on your remote server) navigate to /etc/mysql/my.cnf and add [mysqld] then it should look like: !...
2
votes
1answer
98 views

SQL Server Demo Environment on Docker Desktop (Win 10): DB storage und upgrade paths

I would like to run SQL Server 2019 on my work as well as my private machine (both running Windows 10 Pro). Thus I thought Docker Desktop would be a nice option. However I would like to keep the ...
0
votes
0answers
17 views

Windows 2016 Workgroup failover cluster

I am building a two node Window failover cluster for SQL Server AG. I am getting following errors in the cluster log. Please help me to resolve the error. Thanks
0
votes
0answers
153 views

bcp: dsn specified an unsupported driver

A straight-forward call to bcp works on linux and not on windows. Ubuntu ~$ /opt/mssql-tools/bin/bcp "select @@version as v" queryout foo.csv \ -D -S mydsn -c -U myuser -t, -r '\n' -P '...' ...
1
vote
1answer
457 views

Error while configuring REST for Oracle APEX on Windows

I'm trying to deploy Oracle APEX 18 on Windows 8.1 PC using Oracle REST Data Services and Oracle Database 18c XE following this guide. But when I'm trying to run @apex_rest_config.sql I get this ...
10
votes
2answers
1k views

Limit max CPU usage SQL SERVER with WSRM

I have a physical server running one instance of SQL Server. I notice that quite often this server is running at 100% CPU usage. My IT team is not happy about this, and suggested we reserve 2 of the ...
0
votes
0answers
1k views

Can't figure out how to start postgres on port 5432 in windows

Setting up Postgres on Windows for frontend web dev This is not my area of expertise (frontend guy), but I need postgres simply running on my side to connect with the test DB for the project I'm ...
1
vote
0answers
129 views

PostgreSQL 9.6 on linux server gives a different collation than windows installation

I am running into an issue with a script that makes a backup towards the SQL. What happens is that with our script we make a dump of SQL we can read out to restore the PostgreSQL database. Our client ...
0
votes
0answers
25 views

MySql module in xampp server is not starting..Getting following error log:

Error: MySQL shutdown unexpectedly. 3:30:57 PM [mysql] This may be due to a blocked port, missing dependencies, 3:30:57 PM [mysql] improper privileges, a crash, or a shutdown by another ...
0
votes
1answer
420 views

SQL Server Management Studio - Debugger buttons greyed

I have for mission to enable Transact SQL from a remote computer. My database is on a server and i'm trying to use the debug from a computer on the same network. My firewalls are all open on both side....
0
votes
1answer
443 views

SQL Server Execute Permission Denied

I have a small app which calls a stored procedure over ODBC using a sysadmin user with login and password. The problem is that some (Windows Domain) users get an error saying execute permissions were ...
2
votes
0answers
417 views

SQL Server stored procedure not throwing certain kind of error

I noticed an issue in my app recently where an database insert that occurred in a stored procedure was failing, but no exception was getting thrown. The insert failed because a column that doesn't ...
1
vote
1answer
3k views

Getting error while creating a New Connection using Studio 3T for Mongo DB

I tried to create a new connection with Studio 3T for Mongo DB. I don't have a previous DB connection and this is the new one that I am trying to create it. I can't able to figure out why this is ...
0
votes
1answer
60 views

adding pgadmin3 to windows start menu

I have installed postgres (different versions actually) as well as pgadmin3 on windows using the package manager: https://www.openscg.com/bigsql/package-manager/ https://www.openscg.com/bigsql/docs/...
-1
votes
1answer
183 views

Cannot find innodb_page_size option in [mysqld] section in my.ini file

Where can I find innodb_page_size option? Since I cannot find it in [mysqld] section in my.ini file. I want to change it to 32k or 64k since I am getting the below error: MySQL: Error Code: 1118 ...
1
vote
1answer
188 views

Import Windows MySQL dump on a Debian Linux server

I created a test database on a Windows computer with MySQL 5.7 and filled it with many data records. Now I created a database dump with mysqldump and wanted to import it on my server (Debian Jessie, ...
-1
votes
2answers
57 views

What permissions should be added to public users sql [closed]

I have a SQL Server and am looking at making it public. What I mean by this is: I can create a DB and give access to myself and friends etc. I need to create a login which can only view databases it ...

1 2 3 4 5 11