Questions tagged [remote]
The remote tag has no usage guidance.
136
questions
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
15
votes
2
answers
93k
views
How to add a user with access to a single view?
I'm working with MSSQL Server Management Studio 2008 and I need to expose a view to a third party for their data reconciliation. I have created the appropriate view but I'm having trouble creating a ...
- 151
12
votes
4
answers
15k
views
Slow remote SELECT statement due to long "client processing time", but fast locally
While connected to our production server (SQL Server 2008, very powerful machine), this SELECT statement takes 2 seconds, spitting back all fields (4 MB of data in total).
SELECT TOP (30000) *
FROM ...
- 323
11
votes
2
answers
12k
views
Having a PostgreSQL database exposed to the internet
I've seen on DBA and other sites that exposing a database to the Internet is a particularly bad idea, but I noticed that PostgreSQL has SSL-certificate-only authentication. Does this make it any safer ...
- 365
10
votes
2
answers
39k
views
Server requested authentication method unknown to the client [mysql_old_password]
Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password]
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the ...
- 265
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
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
7
votes
1
answer
10k
views
How to insert in table from remote stored procedure without creating a distributed transaction?
How can I insert in a local table from a remote stored procedure without creating a distributed transaction? I want to run a stored procedure on a remote server and use the output as the source for an ...
7
votes
2
answers
42k
views
Connecting to an external database with pgAdmin III
I'm trying to connect to an external database from pgAdmin III (which is installed on both machines).
The client complains:
Access to database denied
The server doesn't grant access to the ...
- 207
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
6
votes
3
answers
21k
views
How to connect to remote PostgreSQL server
I wrote a web app, using java + spring+ PostgreSQL, which I have up and running.
I have a tester for my system and I want him to be able to connect to my database directly to check the result of ...
- 221
6
votes
1
answer
9k
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 ...
- 201
6
votes
4
answers
8k
views
Connect to SQL Server behind NAT from remote machine
The scenario is that this is a SQL Server behind a corporate firewall with your standard setup to allow only minimal outbound traffic and zero inbound. However, port 80/443 are open, per the usual ...
- 4,320
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
5
votes
2
answers
3k
views
Federated tables and triggers
This is the scenario.
Have two MySQL servers (S1, S2) on different machines, with a database on each (DB1, DB2).
I have a table (T2) on DB2 that needs to "fetch" rows from another table (T1) on DB1.
...
- 53
5
votes
1
answer
11k
views
Remote Debugging
I'm having an issue with remote debugging. I have a non-domain server and a non-domain client PC. The client PC can successfully connect to the server and the instance, and it even runs SSMS as the ...
- 41.8k
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
4
votes
5
answers
19k
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 ...
- 141
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 \\' + @...
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
4
votes
2
answers
8k
views
PostgreSQL error: remote query result rowtype does not match the specified FROM clause rowtype, on remote function call
This is my remote function:
CREATE OR REPLACE FUNCTION public._test1()
RETURNS record
LANGUAGE plpgsql
AS $function$
DECLARE
rec record;
BEGIN
select 1,2 into rec;
return rec;
END $function$;
...
- 143
4
votes
2
answers
5k
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 ...
- 175
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
3
votes
2
answers
6k
views
What port is used by SQL Server to write backups to a remote server?
I have a SQL Server 2008 R2 Standard instance in a "DMZ", so that it can be client-facing. I am trying to have it write its backups to a central location that is within the network. The engineers ...
- 263
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
3
votes
2
answers
5k
views
MySQL remote connection: Public vs. private IP address
I just went through the obligatory pain of getting MySQL to accept a remote login. Yes, I had to create a user of the form ''@'%', and I did so. Yes, I had to GRANT ALL ON . to my new '@%' user and ...
- 31
3
votes
1
answer
11k
views
DB2 Defining remote database alias
I'm using DB2 9.7.0.3 for AIX.
I want to select data from a remote database, also running DB2 9.7.0.3 for AIX, and insert it into the local database I'm connected to.
I believe the query for this ...
- 45
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
3
votes
1
answer
14k
views
Cannot connect remotely to sql server 2012 instance using SSMS
I have installed sql server 2012 Express on a local network machine, then added a new login: "sqlUser" mapped to "database1", and configured the instance to accept the remote access with both Windows ...
- 133
3
votes
2
answers
553
views
What do I need to sync a local site office SQL Server with the Head Office SQL Server
The company has a desktop application powered by SQL Server from the head office that is dependent on an internet connection to our remote sites. Usually when we move to a new site there is a good ...
- 247
3
votes
1
answer
284
views
Remote Database Backup [closed]
I am attempting to find a reliable service that does remote MySQL Database Backup.
Price is no object, unless it's absurdly expensive. I understand this question doesn't really have an answer, and I ...
- 323
3
votes
0
answers
1k
views
Timeout on remote query over database link
We are trying to verify if a database link is up before inserting data into a remote database. We have no control over the remote database's behavior and status. We need to set a timeout on a query ...
- 31
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
2
votes
3
answers
40
views
How do I block all IP addresses from connecting remotely to Cassandra?
I want access to remote cassandra with one ip address. how can I change cassandra.yaml to block all ip address except ip that I want to connect?
Can I do by cassandra.yaml ?
- 41
2
votes
1
answer
376
views
Is it possible to force a query to ignore the server option "remote proc transaction promotion" so it doesn't promote remote proc transaction?
I have a specific query that executes a stored procedure on a remote linked server and inserts the results into a local temp table.
I don't want it to promote a remote procedure transaction but I can'...
- 32k
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
2
votes
2
answers
8k
views
Connecting remote MySQL database to local MySQL database?
I want to write PHP code to be embedded in a Drupal7 module.
I want to call a procedure which can copy newly generated data in the local MySQL database to a remote MySQL database.
When data is ...
- 23
2
votes
2
answers
284
views
Connecting to SQL Server 2008 on windows server 2008
Hell all
I am new to windows server 2008 and we are trying to transfer our website from hosting to virtual server.
I installed SQL Server 2008 Express edition and I did the things like opening port ...
- 51
2
votes
1
answer
59
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, ...
2
votes
1
answer
2k
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 ...
- 121
2
votes
1
answer
144
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 ...
- 123
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
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
2
votes
1
answer
404
views
How to attach a sql db with blobs using a shared folder?
I use the following query for attaching a sql db:
CREATE DATABASE [myDb] ON
(FILENAME=N'C:\myDb\myDb.mdf'),
(FILENAME=N'C:\myDb\myDb_log.ldf'),
(FILENAME=N'C:\myDb\FILESTORE')
FOR ATTACH
In ...
- 57
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 ...
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
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
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
2
votes
0
answers
1k
views
Postgresql slow remote execution when using alternative clients
I noticed a strange perfomance issue when running sql queries on a remote Postgresql Server.
Everything good when using psql:
Connect via ssh and run things locally
$ ssh user@example.org
user@...
- 121
2
votes
1
answer
1k
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,103