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]

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.

0
votes
1answer
43 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
31 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
56 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
18 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
22 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
36 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
46 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
vote
0answers
155 views

Error cs1567 while installing ms-sql on windows 8.1

I tried to install sql server 2008 and 2012 on my windows 8.1 laptop but at both times i faced with the same error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following ...
0
votes
1answer
58 views

Running loadjava with Windows authentication

I want to run following command under Windows with Oracle Database 12c installed: loadjava -force -genmissing -r -user username/password@database -verbose core-1.7.jar The problem is that I use ...
0
votes
1answer
35 views

Oracle TKPROF Insert data doesn't match text results

I'm trying to make sense of the output from a SQL Trace from an Oracle 12.2 database on Windows. I've used TKPROF to interpret the the resulting trace files. This utility generates a text file output ...
1
vote
0answers
43 views

MySQL 5.7 issue with 16TB disk

(Repost from StackOverflow) I have a MySQL 5.7 running on a Windows Server 2016 VM with two disks from a NAS: C:\ for system and D:\ for data (empty at start). I try to create a partitioned table: ...
1
vote
1answer
44 views

Which Editions of Oracle are Free?

I am aware of Oracle Express edition which is up to version 11g, which is pretty dated. However, I have read that Oracle are changinging/have changed their licensing of newer editions so that we will ...
-2
votes
2answers
252 views

How do I install a PostgreSQL extension in Windows? [closed]

In Linux (with Ubuntu or Debian) if I want to install gen_salt(), I first install the -contrib package. sudo apt install postgresql-contrib Then I install the extension in the database, psql -d ...
2
votes
1answer
26 views

How to access a shared folder from Windows Cluster IP [closed]

This is a very strange question, but I am trying to access a Windows file share from a SQL server cluster IP, that resides on that server. In the past and on other servers I have, I get connected to ...
6
votes
1answer
826 views

Error starting SQL Server 2017 service. Error Code 3417

I have SQL Server 2017 installed on my computer. This is what SELECT @@VERSION returns: Microsoft SQL Server 2017 (RTM-GDR) (KB4293803) - 14.0.2002.14 (X64) Jul 21 2018 07:47:45 Copyright (C) ...
2
votes
1answer
343 views

How to restore from .wt files?

Environment Windows Professional 10 MongoDB 3.6.4 2008R2Plus SSL (64 bit) (before computer crash) MongoDB 4.0.2 2008R2Plus SSL (64 bit) (after computer crash) I have been developing locally, and ...
0
votes
1answer
57 views

Always On Windows Server Edition

For setting up Always On Availability Groups in SQL Server I know you need to have at least Enterprise Edition for SQL Server 2012, 2014, or 2016. Do you also need the Datacenter or Enterprise ...
-1
votes
2answers
49 views

MySQL on Windows or Linux [closed]

I am new to the Database region while have to migrate the company's database from AWS RDS to AWS EC2 and subscribe MySQL Enterprise edition. What I am confused now is which OS should I choose, ...
0
votes
0answers
29 views

Do any of the PostgreSQL releases for Windows support automatic updates?

PostgreSQL has two distributions for Windows, EnterpriseDB BigSQL Do either of these Windows distributions support automatic updates for the term of support? Something that looks for the updates ...
1
vote
2answers
283 views

MySql 5.6: Ignores innodb_page_size setting in my.ini

So I tried to increase the innodb_page_size to 32k, by setting this value in my.ini: innodb_page_size=32k I then stopped the MySql service, and restarted it. The service in Win looks like this: "C:\...
0
votes
1answer
220 views

Python version issue on Cassandra 3.11.2

Searching around I found a lot of thread about this problem (coming from 2012) but I can't find an official solution: running cqlsh.bat File "C:\apache-cassandra-3.11.2\bin\\cqlsh.py", line 146 ...
0
votes
1answer
93 views

Does the Mysql install location affect write speeds?

Up until lately, I used a 32 bit version of Mysql 5.7, bundled with a WAMP server (EasyPHP) on Windows for local development, all running on an SSD. I ran into database size issues, and had to upgrade ...
0
votes
0answers
44 views

OpsCenter missing in Datastax Cassandra for Windows

Following this guide within the Cassandra installer I should get OpsCenter too. But this screenshot https://www.datastax.com/wp-content/uploads/2012/01/dsc-win4.jpg doesn't match the current release (...
1
vote
1answer
23 views

Connection is Using Properly or not in Net Use via SQL Procedure

am doing an operation of creating a file and writing in a SAN SAMBA where it will be done using the cmd_shell via SQL Procedure. It's creating and writing it successfully but while am calling that ...
0
votes
1answer
97 views

MySql Replication on Windows

guys any one please give detailed document on Mysql Replication on Windows System.I replicated master to slave, but it is showing 'connecting to master' errorno showing as 1045 and 2003 its varying. ...
0
votes
0answers
28 views

Retrieving Mongo Databases without connecting directly to an instance

Hope someone can help. I have two MongoDB 3.6 installation set up on Windows Server and Ubuntu. Both installations (Windows and Ubuntu) have 5 databases each including the default databases. I've ...
1
vote
3answers
778 views

How to prevent asking for password when creating new database in PostgreSQL 10?

I use the following batch file to create a new database in PostgreSQL 10. echo off cd "C:\Program Files (x86)\PostgreSQL\10\bin" createdb -h localhost -p 5432 -U postgres myDB But it asks to enter ...
0
votes
2answers
47 views

Drive holding my database is running out of space. What are my options?

I am new to database administration. I've been scraping a website for a month now. I have two drives, each 2TB in size. I have PostgreSQL 10 on my first drive (c:) and it has 50GB left. I've only ...
0
votes
1answer
253 views

Local Cosmos DB service unavailable

I've installed the azure cosmos db in my local machine but is not loading the explorer pages as shown below: Explicit error: Failed to get authorization headers for offers: {"readyState":4,"...
0
votes
1answer
2k views

How to create a new database in PostgreSQL 10 in Windows from batch file?

I am creating a batch file to create a new database in PostgreSQL 10. I used the following code, echo off cd "C:\Program Files (x86)\PostgreSQL\10\bin" psql "dbname=myDB host=localhost user=postgres ...
1
vote
1answer
525 views

MySQL select * from table without conditions does not return rows right away

I have a table with about 4 million rows and a bunch of columns on each row and I'm doing a simple select * from table in the mysql client and it doesn't return data right away. A count(*) of the same ...
0
votes
1answer
737 views

`“C:\xampp\mysql\bin”' is not recognized as an internal or external command,operable program or batch file [closed]

I am trying to access to mysql from windows command prompt by this command: "C:\xampp\mysql\bin" mysql -u root - p But it sayas: `"C:\xampp\mysql\bin"' is not recognized as an internal or ...
0
votes
1answer
17 views

Regularly clone/backup 2 MySQL databases unidirectionally from PC to Laptop both running Windows

I have a PC running Windows XP with a custom ERP system and MySQL Server 4.x (A) and a Laptop running Windows 10, same MySQL 4.x and same custom ERP (B). I'm afraid I can't upgrade PC nor MySQL, etc. ...
1
vote
1answer
276 views

Access denied error when archiving WAL during postgresql 9.5 replication setup

I want to setup Postgres replication on Windows. I followed the given youtube url step by step: youtube video. For archive_command I use this: archive_command = 'copy "%p" "\\\\ip-address of ...
0
votes
1answer
222 views

How save psql `ERROR` output to the same file as the DDL commands?

I'm trying to restore a database from a text file. I'm following the answer on this question. How do I restore a plain text postgres .backup file But add: > c:\result.txt psql.exe -U sde sde <...
1
vote
1answer
47 views

Share mongo database between two OS on dual boot

Now I have two OS on my computer: Windows 10 and Linux (arch). Sometimes I use Linux but I also use windows because of gaming, and I want to create a small application that is going to work on both OS....
4
votes
2answers
403 views

Slow connect time to postgresql on Windows 10

Connect time to postgresql on my Win 10 machine incredible slow. It take 2.5-3.5 seconds for a connect. $ time 'c:/Program Files/PostgreSQL/10/bin/psql.exe' -h 127.0.0.1 -p 5433 -U xxx -c 'select ...
2
votes
1answer
10k views

pgAdmin 4: How to establish a connection through an SSH tunnel/interface in Windows

I installed the latest pgAdmin 4 (v2.1) but I found out that (related thread), for the moment, the only way to establish a connection through an SSH tunneling is using another outside process, an ...
0
votes
1answer
276 views

Removing a FILESTREAM windows share after uninstall

I had to uninstall my local SQL 2017 Dev edition on my home PC (Windows 10) because I changed some drive structure (including where all the system databases lived) a while ago, so I needed to ...
1
vote
0answers
276 views

PostgreSQL service stops immediately after installing Windows Fall Creators Update 1709

The server itself runs fine with pg_ctl -D <datadir> start But the service stops immediately ("...Some services stop automatically if they are not in use by other services or programs") ...
3
votes
1answer
213 views

mysqldump slow on Windows unless piped to file

Running mysqldump without piping to file such as: mysqldump -u root -pPASS db is really slow on windows. If I do mysqldump -u root -pPASS db > db.sql it runs fast. This might not seem like a ...
1
vote
2answers
3k views

Set TERMOUT OFF is not working when I am using sqlplus in command prompt?

I am using the sql statement listed below in my spool sql script, and I am executing this script from sqlplus. But in terminal query output is still coming and I am using sqlplus in command prompt. ...
1
vote
0answers
38 views

Never stop growing of MariaDB service memory on Windows

I have this strange problem in a Win7-4GB machine with MariaDB v. 10.1.18 using only InnoDB tables. mysqld.exe service memory grows until the OS error out of memory, it take some hours but at the end ...
0
votes
1answer
274 views

Installing command line tool with pgAdmin4

I have pgAdmin4 and the latest version of PostgreSQL installed on my machine. When I tried to insert large amount of data using INSERT statements contained in a .sql file of size 40 MB, 50MB and above,...
2
votes
1answer
2k views

Where can I download an old version of PostgreSQL for Windows? [closed]

I need version 8.4 for a legacy system, but EnterpriseDB (the official link) only shows 9.x On the PostgreSQL FTP Mirror I see the 8.4.22 binary, but only have binary for solaris:
0
votes
1answer
24 views

Problem connecting to postgresql from external windows machine

I have a Windows laptop running a postgresql database. I want to be able to pull data from this DB into an application on another laptop, say excel or access. So far, I set up a DSN on my machine ...
1
vote
1answer
32 views

Update table based on reference values from another table [closed]

I have two tables structured like so: Table1 (reference table) | Name UNIQUE | Value(Double) | Table2 (data table) | Name1 | Name2 | Number(Int) | I want to add 10 to the number in each row of ...
2
votes
1answer
291 views

What differences are there with SQL Server 2017's packaging of `Binn` on Linux and Windows?

Knowing that the Binn is packaged differently on Windows and Linux, I'm wondering what differences there are between the two? Do they come with different utilities? On Linux Binn is distributed in a ...
0
votes
2answers
93 views

There is already an object error after database is dropped

Started learning SQL Server and stuck with this simple code: drop database if exists dbo; create database dbo; create table dbo.a_table (a_table_a_field int not null); Running it twice in SSMS ...
2
votes
2answers
487 views

In 2-node cluster using failover with Dynamic Quorum, is Witness needed?

I have a 2-node cluster on SQL Server 2016 Standard with failover clustering configured with Dynamic Quorum. There is one thing that made me confused: do we really need a Witness in this case? Since ...