Questions tagged [windows-10]

The tag has no usage guidance.

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

PG crashes after I run a big query after a C Functions

I noticed a weird behavior of PG. If I run a query using a C functions ( here the link - https://www.2ndquadrant.com/en/blog/compiling-postgresql-extensions-visual-studio-windows/) the simple add_one ...
0
votes
0answers
23 views

Failed to add 'Admin user' to %2% user group in Oracle 19C Windows 10 installation

Oracle 19c installation fails with this error message. I am trying to set up oracle for my 'Existing Local User' account Installation logs tries to add Admin user to all groups and fails .it says ...
0
votes
0answers
38 views

PostgreSQL: “PANIC: out of memory”

Got an error while running an application connected to a PostgreSQL DB (10.12). All the connections got disconnected, looking through the server logs, I found the below. TopMemoryContext: 292488 ...
0
votes
0answers
8 views

Is there some parameter/flag I can use to make pgAdmin 4 update silently without the GUI?

Every single time pgAdmin 4 has an update, I have made it so that it grabs the latest installer (this is on Windows) and puts it on my desktop, then notifies me. I then have to manually run this GUI ...
0
votes
1answer
75 views

After doing latest windows10 update 1909 SQL Server Management Studio 17 not working

yesterday I have an update for windows version 1909, after updating to the latest version, When I tried to open SSMS it shows me an error like this(please check the screenshot).
2
votes
1answer
153 views

Old ODBC app throws “cannot generate sspi context” on Windows 10

An old Access 2003 .adp project is currently running on Windows 7 machines, while SQL Server 2008 is on the backend. Since the app is moved to a Windows 10 machine, the app will trigger "Cannot ...
1
vote
0answers
154 views

All but one of my SQL Server 2017 databases are GONE after Windows 10 nightly update failure

EDIT: Restored to a restore point from three days ago, prior to a "Critical Update", and the databases are back. This is, I believe, the culprit update: September 10, 2019-KB4514601 Cumulative Update ...
1
vote
1answer
2k 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
19 views

PostgreSQL Active Directory authentication logins contain a period

PostgreSQL newbie here. I am trying to set up a PostgreSQL server to integrate our active directory credentials. I can edit the pg_hba.conf file to allow users with an internal IP to connect with OS ...
0
votes
0answers
64 views

Not able to use existing Windows user account while setting Oracle 12c db

I am trying to setup Oracle 12c (12.2.0.1.0) on Windows 10 Enterprise. (1809 update). I have a Windows user account created from the Edit Local Users and Groups window. As recommended, the user is not ...
0
votes
0answers
58 views

Sybase 8 to Sybase 16 migration in Windows 10 OS

Currently we are using Sybase 16 db in our project. But there are few Sybase 8 db's (that clients are using in market) that needs to converted to Sybase 16 for any patch testing. I used to use the ...
0
votes
1answer
773 views

How to set up signed SSL Root and Leaf certificates on a PostgreSQL 11 database on Ubuntu and Windows 10 Power BI plus PostgreSQL?

I have Power BI and PostgreSQL 11 installed on Windows 10 and my primary PostgreSQL 11 database on Ubuntu 18.10 Linux. I edited the postgresql.conf and pg_hba.conf files correctly to the IP Adresses ...
0
votes
1answer
41 views

PostgreSQL 11 Windows 10 Truncates All Tables on Shutdown

i have a new Windows 10 laptop with beefed up processors, 16GB RAM and 2TB SSD storage. I have installed PostgreSQL 11.2 on this laptop, and use it to compile large datasets from various sources and ...
0
votes
1answer
63 views

How present the result table below the last result query table, SSMS 2017

os: window 10 SSMS 2017, v17.9.1 I watched youtube videos of SSMS running two different queries and the last result was displayed below the last table. Example that I am referring in youtube. Now ...
1
vote
0answers
558 views

ODBC from Win10 32bit client only connects using IP address, but not using hostname

I'm experiencing a pretty strange problem. We're using a MS SQL based quality assurance software. The database is hosted on a MS SQL 2016 Std. server running on a Windows Server 2012 R2 VM. Our ...
0
votes
1answer
318 views

How to deploy install of MS SQL Server 2017 Developer Edition via command-line script - not working

I'm trying to deploy MS SQL Server 2017 Developer Edition via command-line script from a server share that holds the install media onto Windows 10 1803 (June release). However, I'm not having much ...
0
votes
1answer
666 views

SQL Server service start automatically only after Windows Shutdown, how can I make restart automatically without batch file? [duplicate]

I am using MS SQL Server 2014, When I restart my Pc the SQL Server Service does not start automatically, however, it does after Windows Shutdown and run again, how can I make it restart automatically ?...
1
vote
0answers
57 views

Deployed application (Oracle 11g, VB.NET 2015 and Crystal Reports) cannot connect to database

I'm developing an application using Oracle 11g, VB.NET 2015 and Crystal Reports on Windows 10. I created a package and installed it on another PC on same network. The package is running fine but ...
0
votes
3answers
2k views

MYSQL 8.0 server not found in Workbench directory in Windows 10?

I have upgraded my workbench to 8.0CE and also removed the previous 5.7 MYSQL server as well as Workbench 6.3. This is the directory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE Also when I typed ...
4
votes
3answers
946 views

Can't restart Postgres on Windows 10 with external drive

I've been working on a postgres database, with my data directory on my 8TB external USB drive. Occasionally, I need to restart the postgres instance to change configuration settings, but for some ...
1
vote
2answers
3k views

SSMS crashes when attempting to create a database diagram

I'm currently using the latest version of SSMS (17.8.1) on windows 10 and everytime I try to create a database diagram it crashes without giving me any error message. I've already tried to re-install ...
0
votes
1answer
2k views

Can't install Oracle 11g [closed]

Error while installing Oracle 11g: Please find the StackTrace of this error. ID: oracle.install.driver.oui.OUISetupDriver:13 oracle.cluster.verification.PreReqNotSupportedException: Reference data ...
1
vote
1answer
595 views

Connection's MAC address randomly changes on Windows 10, then stops

Because reasons (tm), we want to identify the client's MAC address on SQL Server side (local network, not about security, enables a very convenient feature in way transparent for applications). We do ...
0
votes
1answer
499 views

Connect analysis services to oracle database

I am looking to connect analysis services to an oracle database, and when I hit Process in AS, it gives me a generic Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [...
1
vote
0answers
70 views

SQL Server 2012 Management Studio not loading

I have installed SQL Server 2012 on my Windows 10 machine, but when I launch SQL Server Management Studio, the splash screen shows for a minute but then the tool never comes up. The computer is ...
1
vote
0answers
449 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") ...
1
vote
2answers
4k views

How to set cache on windows 10 pro 64bit machine

When running Mongod I get the following WARNING: The file system cache of this machine is configured to be greater than 40% of the total memory. This can lead to increased memory pressure and poor ...
0
votes
0answers
355 views

Vanilla installation of MySQL on Windows 10 fails, service cannot start, corrupt InnoDB page

I started with a clean machine (Windows 10, 64bits), no previous installation of MySQL. I downloaded MySQL Installer Web Community 5.7.20.0, and installed the following: MySQL Server 5.7.20 (x86) ...
13
votes
1answer
4k views

PostgreSQL 9.5 won't start after Windows 10 fall update

I've installed Windows 10 Fall update (1709) and now my PostgreSQL 9.5 server won't start. It worked yesterday before the update and I haven't made any changes to the configuration. I've checked ...
1
vote
0answers
2k views

How to relax file permissions conditions on postgres database folder?

Postgresql service refuses to start if the data folder (PGDATA) doesn't belong exclusively to the postgres user (i.e. permissions = 700). Is there any way to disable or circumvent that condition? ...
1
vote
0answers
418 views

How to run Oracle Client 10g from non Administrator account?

Hi I have 2 users configured on my Windows 10 Home machine. One is Administrator and another is my own user. Although my user is configured as an Administrator, I can use Oracle Client 10g from my ...
1
vote
1answer
3k views

'SSL is required but the server doesn't support it (2026)' error while making an SSL MySQL connection

I'm trying to make an SSL supported connection using MySQL Workbench 6.3.9. My OS is Windows 10 x64 and I have installed MySQL Server 5.7 x64 with OpenSSL-1.0.2L (Win64 version). I made a non-SSL ...
0
votes
2answers
543 views

Oracle12c R2 on Windows 10 starts only one of two instances. Manual start results in LRM-00109

I have installed Oracle 12c R2 on my local Windows 10 (64 Bit) machine. For the installation I choose only to install the software. After the installation I have used the tool that comes with the ...
1
vote
1answer
13k views

IO Error: Got minus one from a read call [closed]

I am very new with Oracle, I have installed 11g 64 bit on my Windows 10. And only started the oracle database using emctl start dbconsole. I have the following code to be connected to my database, ...
1
vote
0answers
98 views

How do install and configure Grid Infastructure on Windows>

I'm studying for the 1Z0-062 exam with John Watson's exam guide and I'm trying to install Grid Infrastructure alongside my Dbhome. The book seems to run an installer that displays a configuration ...
9
votes
2answers
13k views

Microsoft SQL Server local report culture is not supported: 3072 is invalide culture identifer

I am using Windows 10, language Serbian, SQL Management Studio 2016 and can't use Database reports because there is error: An error occurred during local report processing Culture is not ...
13
votes
6answers
31k views

The operating system returned error 21 (The device is not ready.)

Every time I reboot Windows, for some databases I get this error: The operating system returned error 21(The device is not ready.) I checked the disk with chkdsk /r - no bad sectors. I executed ...
1
vote
1answer
392 views

Using linked server from Windows 10 PC [closed]

I have been using SQL Server linked servers for years, and they have been working fine. But now when I try to run a query (on a machine with Windows 10) using linked server I get this error: Login ...
0
votes
1answer
2k views

Clear cache in Windows

I would like to make some timing tests in my PostgreSQL database. I would like to clear cache every time I run a query to disable influence of caching on my timing results. I've read some topics about ...
0
votes
1answer
311 views

Issue with 2016 developer edition install

Issue with 2016 developer edition install on new windows 10 machine. Not finding any docs or similar issues posted. An error occurred for a dependency of the feature causing the setup process for ...
0
votes
1answer
162 views

RSAT on Windows 10 fails to add node to server 2016 cluster

I have been testing server 2016 failover clustering. I have 3 hyper-v VMs running server 2016 core. I installed the RSAT tools on Windows 10 Pro to use the failover clustering wizard. I cannot add a ...
1
vote
3answers
4k views

Which driver should I choose for ODBC connect from Windows 10 => SQL Server 2014

What driver to use for ODBC connection from Windows 10 host to SQL Server 2014? I have a choice of 3 SQL Server clients: ODBC Client 11 SQL Server SQL Server Native Client. I've tried the ODBC ...
1
vote
1answer
2k views

SQL Server 2016 Plugin's not working [closed]

Recently I installed SQL Server 2016 on my PC. Here is the detailed information of my server : Microsoft SQL Server 2016 (RC1) - 13.0.1200.242 (X64) Mar 10 2016 16:49:45 Copyright (c) ...
1
vote
1answer
3k views

Install SQL Server 2014 in windows 10 not installing database engine and some features?

Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068054016 Start time: 2016-03-27 17:00:55 End time: ...
2
votes
1answer
3k views

Is Windows 10 compatible with SQL Server 2014 Developer MDS?

I have recently installed SQL Server 2014 Developer edition onto my PN, which has Windows 10 Professional installed. I upgraded from Windows 7 Pro to Windows 10 Pro last year as it was a free update ...
1
vote
3answers
806 views

Practicing AlwaysOn on SQL Server 2014 - Windows 10 Home

TL;DR: What possible solution(s) are there to practice AlwaysOn feature on SQL server 2014 installed on Windows 10 Home edition? I am learning Database Administration on my own and have installed ...
4
votes
2answers
4k views

MySQL - Slow InnoDB Write Speeds on Windows 10

I have Windows 10 bootcamped. I've installed the latest version of MySQL community server. I've also installed WordPress onto IIS. The MacBook has 16Gb of memory. Here is my config file [client] no-...
3
votes
2answers
2k views

SQL Server 2014 Developer on Windows 10?

Has anyone tried to use SQL Server 2014 Developer Edition (64 bit) on Windows 10 yet? I have a Lenovo G50-45 laptop that came with Windows 8.1 and I have the option to upgrade, but I don't want to ...
3
votes
1answer
3k views

Unable to uninstall Sql Server 2012 Express (With SP1)

My Stack: . Windows 10 Enterprise . SQL Server 2012 Express (with SP1 bundled). ISSUE: . Installed SQL to test for backward compatibility. . When I tried to Un-Install the following prompt is thrown....
8
votes
3answers
56k views

Maintaining SQL Server 2008 R2 on Windows 10

I have to run SQL Server 2008 R2 on Windows 10 but it is not supported and so I am not getting any updates. Installing a later version of SQL Server is not an option. I can find all the service packs ...