Questions tagged [remote]
The remote tag has no usage guidance.
136
questions
5
votes
1
answer
47k
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 ...
- 51
2
votes
1
answer
397
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
1
answer
79
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 ...
- 13
1
vote
2
answers
3k
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....
- 133
3
votes
2
answers
2k
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....
- 61
0
votes
1
answer
670
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
1
answer
2k
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 ...
- 1,394
0
votes
1
answer
1k
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 ...
- 101
1
vote
0
answers
326
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 ...
- 303
0
votes
1
answer
650
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 ...
- 23
2
votes
2
answers
73
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:~...
- 153
0
votes
1
answer
42
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.
...
- 23
4
votes
2
answers
26k
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 ...
- 41
1
vote
1
answer
322
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 ...
- 113
1
vote
0
answers
222
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.
...
- 1,342
0
votes
1
answer
290
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 ...
- 101
9
votes
2
answers
3k
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 ...
- 221
4
votes
1
answer
4k
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
2
answers
2k
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, ...
- 143
1
vote
1
answer
535
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 ...
- 121
1
vote
0
answers
56
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 ...
- 121
0
votes
1
answer
786
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 (...
- 121
2
votes
1
answer
11k
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 ...
- 21
5
votes
1
answer
7k
views
Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error
Error creating SQL Model Connection connection to TSMDB1. (Error: [jcc][t4][2010][11246][3.68.61] Connection authorization failure occurred. Reason: Local security service non-retryable error. ...
- 1,215
7
votes
1
answer
8k
views
SQL Server: Failed to start debugger - Data is Null
I'm a developer working on a web application using an instance of SQL Server 2014. I use Visual Studio 2010 sp1 for development. For a task I'm currently working on, I'd like to use the SQL Server ...
- 193
1
vote
0
answers
50
views
Security: direct remote access vs webinterface
I need to remotely connect to my (mongoDB) database and I currently allow direct access to the DB server port with user/pw login.
I often read that this is generally a bad idea and that one should ...
- 129
-2
votes
1
answer
723
views
Connect an desktop application to my SQL Server using internet
I want to connect a desktop app to a SQL Server using internet, not local. The app will run on every network in the world with internet and the data will retrieve and send from my PC using SQL Server.....
2
votes
2
answers
793
views
cannot login to MySQL remotely
users and root can log in locally with no problems. No user can login from a remote connection though
from remote:
[root@yoda:~] # mysql -v --host=r2d2.er.com --user=power --password='burp' power
...
- 33
0
votes
1
answer
352
views
Remotely inserting 3.5m records mysql
I need to remotely insert 3.5 million rows to my amazon rds. Currently my data is in an access database, for which I will use bullzip, access to mysql to create dump files. I have created my schema on ...
- 304
1
vote
1
answer
481
views
Unable to remote access MySQL - Unbuntu [closed]
I have installed Ubuntu 15.04
I've bind the IP address, there are no firewalls installed, but yet connection is still being refused! I've tried everything I could find online, anyone have any way of ...
- 11
-1
votes
1
answer
135
views
Unable to connect to mysql remote
I am struggling to connect MySQL database with my application, I am having the following set up
3 Applications running in cluster mode and trying to connect with same DB.
MySQL database running on ...
2
votes
0
answers
3k
views
PostgreSQL FATAL canceling authentication due to timeout
I have a PostgreSQL 9.4 Database running on my CentOS 7 Server.
This database has only ever been available to users on the LAN,
however recently I needed to make it available to users outside the LAN
...
- 207
1
vote
1
answer
388
views
PostgreSQL: changing data directory location (sshfs)
I'm trying to change my PostgreSQL data directory initially on my Debian server to my NAS (running also on linux).
To do so, I've mounted it on a specific directory through sshfs (in /mnt/titanBDD).
...
- 131
1
vote
1
answer
2k
views
Remote access from domain and other pages on that domain
I know that you can access a database from a domain name with a user like this user@example.com but will this user also be able to access the database if they are trying to connect via another page on ...
- 113
0
votes
1
answer
4k
views
Want to remove global_name from DB links (Oracle 11g)
I am trying to call remote function via DB LINKS.
However, My global name contains the string ON and I believe it causes an error.
The Error I have is ...
SQL> var tmp varchar2(2);
SQL> ...
- 101
2
votes
2
answers
5k
views
Cannot remotely connect to SQL Server 2012 VM on Azure
I have a SQL Server 2012 instance running on a virtual machine in Azure. I have tried to connect to it using the public virtual IP address; however, I get an error saying:
The server was not found ...
- 257
0
votes
2
answers
2k
views
INSERT in a remote server is far too slow, how to speed it up?
I need to load 480.000 rows into a remote database. The database can't be accessed locally, it's an Azure WebApp, so i can't load the SQL statements on the server.
I was wondering if there is a way to ...
2
votes
1
answer
7k
views
SQL Server remote connection to 2nd instance impossible
After installation of another SQL Server 2014 instance to a server where a default instance of SQL Server 2008 R2 is present, I cannot remote connect remote to the new named instance.
The default ...
- 4,717
4
votes
1
answer
7k
views
Confused by GRANT ALL PRIVILEGES ON *.* (...) WITH GRANT OPTION
Normally I manage users on my databases via phpMyAdmin, but since I do everything else in standalone programs such as SQLyog or HeidiSQL, I wanted the ability to manage users remotely from these ...
- 143
2
votes
2
answers
3k
views
MySQL Drop User Fails for Remote Host
We're clearing out some old MySQL users that connected from remote hosts during a database transfer.
Why is this DROP USER query failing for the user asdfasdf_imac4? I'm logged in as root.
mysql> ...
user58509
1
vote
3
answers
2k
views
secure way to connect with remote Mysql database
I created my application using MySQL and it relies completely on the database I have around 190 tables, and I'm afraid of security breaches and another problem is for remote access I have to add the ...
23
votes
2
answers
83k
views
can't connect to remote postgresql database
I'm trying to connect to a remote psql database. Before I added the pg_hba.conf entry with the client's IP address, I was getting an error message :
xdev@xdevbox:~$ psql -U postgres testdb -h 10.1.1....
- 741
0
votes
0
answers
863
views
Can't connect to other instance of SQL Server 2012
I'm working through a Microsoft exam study book.
I have set up 2 SQL Servers (both 2012 Standard on Server 2008 R2) and a DC.
The book wants me to remotely connect SQL-A to SQL-B. Unfortunately the ...
- 113
0
votes
1
answer
60
views
Can mariaDB contain indices only with data coming from remote tables?
I'm trying to think through a setup with a central mariaDB instance (A) accessing data on physically remote servers (B).
All queries to the database (A) can be answered from indices only. Indices are ...
- 263
2
votes
1
answer
7k
views
MySQL workbench: Cannot Connect to Database Server (ssh)
General pointers would be appreciated -- it's likely I'm misunderstanding the mechanisms involved in a remote connection through ssh. I can use ssh to connect remotely, and then, through the CLI, ...
- 121
1
vote
1
answer
946
views
Backup a remote database, from my machine, to another server (SQL Server 2008)
I'm trying to backup a database, of a remote server, from my machine, to another server.
SERVER1 >>> BACKUPSERVER
\ /
\ /
\ /
...
- 7,274
1
vote
4
answers
3k
views
How to make a remote mysqldump?
I know that's it's possible to do a remote mysqldump if I specify --host but is it possible to create the file in the remote server as well?
- 255
1
vote
2
answers
354
views
Cancel Query in remote ssms from ssms in my pc [closed]
We connect to our customer's database server with vpn. Sometimes we manage Sql server to connect database server or to connect with ssms in our pc's.
I executed a query with ssms in database server, ...
- 139
7
votes
2
answers
79k
views
How to allow remote connections to mysql from specific IPs only? [duplicate]
I have a fresh install of mysql server 5.2.6 on a 64 bit Ubuntu running on a remote server with static IP. Is there anyway to allow Mysql remote connections to be made from pre-approved IPs only?
I ...
- 71
1
vote
0
answers
196
views
Restore postgresql database from remote sql file
I would like to know if it's possible to restore a database from a remote sql file.
The problem:
- Working with PostgreSQL 9.2.4
- I have an small remote server with 10GB left in storage
- I have a ...
- 113