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 [remote]

The tag has no usage guidance.

0
votes
1answer
17 views

Cannot allocate memory for the buffer pool when using remote access MySQL

I tried to separate the webserver and mysql server. MySQL server = 16GB RAM and the config of Innodb_buffer_pool_size = 10GB. And my Web server = 4GB RAM My website connect to my database server ...
0
votes
1answer
36 views

How to insert data from a local MSSQL db table to a remote MSSQL db table using WCF application coded in .NET [closed]

I made a WPF application using VS2013, coded in .NET. It is working fine in my local SQL Server. But I want to use it to upload data from a local database to a remote database. How can I do this? I ...
0
votes
1answer
39 views

Optimize Oracle 11g SQL*Plus connection for large remote SELECTs [closed]

Which options should I set in SQL*Plus for a script that runs multiple SELECTs, (some are JOINs) to SPOOL the results as text (CSV) in order to optimize these SELECTs, specifically one resulting in a ...
2
votes
1answer
110 views

Cannot remotely access PostgreSQL on EC2 instance

I was unable to access a remote AWS postgres database via things like psql -h *EC2ExternalIP* -U *me*. I would get: psql -h *EC2ExternalIP* -U *me* psql: could not connect to server: Operation timed ...
0
votes
0answers
28 views

Remotely access a database not public to Internet

I am looking for a way to remotely edit a Microsoft SQL database running on Windows 7 and that is not public to the Internet. Right now I am using TeamViewer to do this but is really bad. The reason ...
2
votes
1answer
21 views

Connecting to server which located remotely throws timeout exception

Below are the steps which I follow while connecting manually: Connect to VPN RDP to the remote machine using my credentials Open SQL Server Management Studio Connect to Server > database engine, ...
1
vote
2answers
159 views

Unable to update MySQL table from linked server on SQL Server 2014

I'm using SQL Server 2014, with a linked server to a MySQL database on AWS. I need to update rows on that linked server, using data that exists on another linked server. And if that wasn't complicated ...
0
votes
0answers
280 views

How to connect to remote MongoDB server?

I am trying to connect remote mongoDB server but getting below error: pymongo.errors.ServerSelectionTimeoutError: 172.16.1.70:27017: timed out. The error is on line print(coll.count()) The Code ...
0
votes
0answers
28 views

VB.net insert to Remote MySql Server on a Network with a Proxy Server

The network at work has a proxy server which doesn't allow my desktop application to communicate to a remote mysql server; the Proxy Server doesn't allow communication to the remote MySql server's IP. ...
3
votes
4answers
1k views

Command line tool / script to backup a remote SQL Server database to local disk

I've been researching and googling for 10 hours and couldn't find anything, so I decided to ask here. I'm looking for a command line tool or a script (running under windows) that can backup a remote ...
0
votes
2answers
53 views

Unable to connect from remote computer, while local connection works

I have a Windows 2008 R2 64-bit server with SQL server 2008 R2 installed on it. I manage to log to SQL server with SSMS with the sa SQL account and with a test SQL account. But when I try to ...
1
vote
1answer
131 views

Remote login via rman working for one instance but not another

I have Oracle 12c installed on two servers. On server UAT I have an instance RMCAT that hosts an RMAN recovery catalog. On server EXT I have two instances, extdev02 and extuat01. I can use the ...
1
vote
0answers
522 views

PostgreSQL, could not connect to remote server via port 5432

I know other people have posted similar questions but none of the solutions applied here. I have installed Postgresql-9.6 under CentOS 7 on my virtual private server, and I am trying to connect to the ...
3
votes
2answers
43 views

Connect to SQL Server on Linux over the network

I have setup Microsoft SQL Server on an Ubuntu VM. I know how to connect to SQL Server on Windows using SSMS -> but unfortunately I can not install SSMS on Ubuntu. Which leads me to the question ...
0
votes
0answers
41 views

SQL remote connection with new user fails

Besides the sa user in the SQL server, I created a new user (called test) which only has read permissions. The user was created via MSSMS, with the following properties: Sql server authentication ...
0
votes
0answers
45 views

Tuning MySQL 5.0 / Linux TCP/IP settings for remote connections

I have installed MySQL 5.0 on a remote server over the internet and connected my JAVA application to it. It works fine, yet I see some delay retrieving results from the database compared to MySQL ...
0
votes
0answers
35 views

“fast” way to export oracle database remotely

this is first time i use Oracle database, and i want to export database in my vps remotely to my local computer, i just try to export with Navicat, but it seem's take too long for large data (4M Rows),...
1
vote
1answer
42 views

MariaDB ran mysql_secure_installation, but seeing remote login attemps in logs

I installed MariaDB and ran mysql_secure_installation and answered yes to all questions to remove anonymous user, test DB, remote login, etc. However, I recently had MariaDB crash and in checking the ...
0
votes
1answer
748 views

Oracle database connection instant timeout

I have to check automatically if a connection to another database in oracle is vaild. I want a trigger to perform different actions based on whether the connection is vaild while it's running or not. ...
0
votes
2answers
120 views

TNS connection forward

There are 3 machines as follows: Machine A - Remote Exadata DB machine Machine B - Remote machine from which only I can connect to port 1521 of Machine A Machine C - Local Machine (To run SQL ...
0
votes
2answers
321 views

How to Backup Remote Database to FTP server

I can connect to a remote SQL Server via Management Studio. But, when I create backups, they get created on the server's disk. How can I transfer them to an FTP server? I only have a login to the MS ...
0
votes
1answer
1k views

Unable to connect to SQL Server 2016 remotely

I am trying to access SQL Server 2016 from outside of my network but each time I try I get this error message. A network-related or instance-specific error occurred while establishing a connection ...
1
vote
1answer
458 views

How to connect to a SQL Server installed on Windows Server 2012 running on VPS?

I want to connect to my SQL server installed on a windows server 2012, that is running on a VPS(Virtual Private Server) remotely, I have done the following steps: Enabling SQL Server to allow remote ...
2
votes
1answer
70 views

Is there a server option which limits the amount of rows returned by a remote query?

I have an issue where a system on our network is making a query (select * from table) which might result in 0 to 70k rows being returned. For large result sets, say around 50k, the calling system is ...
0
votes
1answer
339 views

Remote Access to database PostgresSql on NAS Synology DiskStation (DS216j)

I have a postgres database running on a NAS Synology DiskStation (DS216j). I set this up using ubuntu and modify the files pg_hba.conf and postgresql.conf through SSH. I would like to access to the ...
0
votes
1answer
1k views

Connecting to mySQL from 2 different machines

ALL, Is it possible to modify the permissions of the MySQL DB or I will need to revoke it and grant it again? My problem is as follows: I'm running MySQL server on Gentoo Linux and I'm trying to ...
1
vote
1answer
11k views

Connect to SQL Server over Internet

I want to connect to SQL Server via Internet: I turned off the firewall I enabled the the DMZ in the router, host address is 192.168.1.24 which is the SQL Server LAN IP I open port in the router for ...
2
votes
1answer
140 views

How to replicate schema changes from local database to a remote?

I was working with some big database and I want to replicate local changes from a local database (I just added some columns to a few tables) to a remote database on other server. The thing is that I ...
1
vote
1answer
53 views

Enabling both local and remote connections to a mysql server on linux (ubuntu)

Is there any way to enable both remote connections and connections via "localhost" to a mysql server. I tried adding both bind-address = 127.0.0.1 and bind-address = externalIP but it just used ...
0
votes
1answer
871 views

How to connect to remote MySQL from a specific IP?

I have two IPs (192.168.13.1 and 192.168.13.2) in my Server A and have provided select access to another Server B for secondary IP/virtual IP (192.168.13.2). mysql> show grants for web_app@192....
2
votes
1answer
424 views

Unable to remotely connect to Postgresql 9.5 instance

I am struggling to connect to a remote Postgresql 9.5 instance running on Ubuntu 16.10. The usual: psql: could not connect to server: Connection timed out Is the server running on host "xx....
-1
votes
1answer
195 views

postgresql query hangs indefinitely over VPN - new firewall

We have a product where a local linux machine "SCANNER" does some polling on a local network and then stuffs information into a database in our cloud server over an OpenVPN connection, using pg_query (...
2
votes
1answer
398 views

Remote Query Cost - High Row Count

I have a query that calls a remote table through Linked Server. However, in the execution plan the Remote Query is 71% of total cost and the time taken to run is over 4mins. It returns all rows in the ...
0
votes
1answer
234 views

Mysql Remote IP blocked

I have a peculiar issue with some database connections: I've got this (test) script on 2 different servers: $link = mysql_connect($db_server, $db_user, $db_passwd); if (!$link) { die('Could not ...
1
vote
0answers
192 views

SQL Server 2014 - remote login to AOAG named instance, listener port does not work

Your help is greatly appreciated. I spent a few hours trying to troubleshoot this and before I go to the firewall/network possibilities, i would like to check if my setup has any errors I am unable ...
0
votes
1answer
226 views

Can I restore a .bmp file of full database backup to an Oracle 12c EE instance running on RDS?

I've got an Oracle 12c EE database set up on an RDS box with no SSH access. I do, however, have SQL Developer and SQL PLUS tools. Is there any way I can restore a full backup into this database using ...
0
votes
0answers
15 views

Use MySQL Only to send commands to other hosts

I want to have mysql installed on a server, but only so I can send commands to other hosts from the command line of this server. I don't have any intention of storing data on this server. For ...
2
votes
2answers
40 views

Coping MySQL DB between two servers: which server shoud initiate the operation?

I want to copy a database from serverA to serverB. The servers can communicate directly with each other. So I'm able to do something like: ServerA is sending the database to ServerB: dbadm1@serverA:~...
0
votes
1answer
27 views

Problem remotely connecting to MySQL database

Good afternoon everyone. I have 3 servers on 2 different networks, all of which run MySQL. I can use mysql -u<user> -p -h<ip-addr> from server 1 to server 2 and back without a problem. ...
4
votes
2answers
7k views

Using postgres database from another computer

I have PostgreSQL version 9.5 installed at my machine (Windows 7 Enterprise x64 bit version). I have several databases in schema 'public'. I would like to use/access one of these databases from ...
0
votes
1answer
129 views

Read MS Sql query high latency w.r.t. Remote Query

I'm trying to read a table in a MS SQL Server using python, specifically SQLalchemy, pymssql, and pandas.read_sql. I want to execute the query, put the results into a pandas Dataframe, and continue on ...
1
vote
0answers
42 views

Unable to get anything other than 'Remote scan' when selecting from linked MySql server

I have a linked server in SQL Server 2012 (SP3) that points to a MySql 5.1.61 server on another machine. Whatever I do, I don't seem to be able to get any where filtering to occur on the remote side. ...
0
votes
1answer
90 views

Oracle Database Remote Connection

I've been searching online for a solution to my problem without any luck. I'm trying to connect to a remote server (~ 700 km of distance), but since I'm new in this Database administration world I'm ...
3
votes
2answers
1k views

Foreign Key (references) constraint on PostgreSQL Foreign Data Wrapper?

It seems to be disallowed to add a Foreign Key constraint to a foreign table. Is there any other way to do this? My two tables have these constrains on the remote server. More specific details: I ...
4
votes
1answer
2k views

When executing a command via xp_cmdshell what user issues the command to the system?

I'm executing the following command to stop a service on a remote server from within a stored procedure in SQL Server. ---------------- -- Stop Service ---------------- SET @Command = 'sc \\' + @...
3
votes
2answers
1k views

Connecting to MySQL VM remotely (Azure Resource Manager)

I have a VM setup in Azure (running Windows Server 2012 R2) with MySQL 5.7 installed. I am trying to access this using MySQL Workbench - which when running on the server works perfectly. However, ...
0
votes
1answer
257 views

Can I reference a specific column in a remote table (MySQL)?

I have two databases (MySQL) on two different servers, and one table references a table in the other. However, I am unable to point the reference to a specific column in the remote table for some ...
1
vote
0answers
46 views

How can I partition records vertically across machines?

I recently asked two questions: (1) how to store and connect partial records in two or more machines, with the record halves correctly associated, and (2) how to determine the increase in time/space ...
0
votes
1answer
521 views

Split data across databases/machines

I have two questions about how to partition data across servers. Can I create and connect two or more databases, with the records correctly associated, using only a mapping table stored in a third (...
1
vote
1answer
5k views

SQL Server slow response when accessed from a remote client [closed]

We have a SQL Server in a remote location. If we access the server from the same location (internal IP, same IP as the server is using) the performance is good. We don't face any problem with ...