Skip to main content

Questions tagged [remote]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
24 votes
2 answers
86k 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....
dot's user avatar
  • 771
16 votes
2 answers
99k 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 ...
velojason's user avatar
  • 161
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 ...
FranticRock's user avatar
12 votes
2 answers
13k 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 ...
dreamlax's user avatar
  • 375
10 votes
2 answers
40k 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 ...
Chibuzo's user avatar
  • 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 ...
odinho - Velmont's user avatar
8 votes
2 answers
81k 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 ...
python man's user avatar
7 votes
1 answer
11k 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 ...
Guillermo Gutiérrez's user avatar
7 votes
2 answers
43k 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 ...
Sean Allred's user avatar
7 votes
1 answer
50k 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 ...
salbenny's user avatar
7 votes
1 answer
9k 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 ...
Garrett Bates's user avatar
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 ...
Aubergine's user avatar
  • 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 ...
rikb's user avatar
  • 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 ...
孔夫子's user avatar
  • 4,330
5 votes
5 answers
22k 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 ...
GMX Rider's user avatar
  • 151
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. ...
jila's user avatar
  • 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 ...
Thomas Stringer's user avatar
5 votes
1 answer
8k 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. ...
WernerCD's user avatar
  • 1,225
4 votes
1 answer
5k 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 \\' + @...
ProfessionalAmateur's user avatar
4 votes
2 answers
27k 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 ...
Jibran Khan's user avatar
4 votes
2 answers
10k 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$; ...
Kenobi's user avatar
  • 143
4 votes
2 answers
6k 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 ...
HotTomales's user avatar
4 votes
1 answer
8k 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 ...
zx81's user avatar
  • 143
3 votes
2 answers
7k 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 ...
Oliver's user avatar
  • 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....
Nel's user avatar
  • 61
3 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 ...
Magier's user avatar
  • 4,797
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 ...
WebLearner's user avatar
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 ...
Gabriel R.'s user avatar
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, ...
tim.baker's user avatar
  • 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 ...
Sami-L's user avatar
  • 133
3 votes
2 answers
557 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 ...
best's user avatar
  • 247
3 votes
1 answer
285 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 ...
Quintis555's user avatar
3 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 ...
TheLovelySausage's user avatar
3 votes
0 answers
2k 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 ...
Hugues's user avatar
  • 31
2 votes
1 answer
563 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'...
J.D.'s user avatar
  • 38.1k
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 ...
Johnathon64's user avatar
2 votes
3 answers
70 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 ?
RezaRastgoo's user avatar
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 ...
Shashank's user avatar
2 votes
2 answers
285 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 ...
Nag Bandla's user avatar
2 votes
1 answer
66 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, ...
Deepika Singh's user avatar
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 ...
Edalat Feizi's user avatar
2 votes
1 answer
176 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 ...
Beeblebrox's user avatar
2 votes
2 answers
76 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:~...
jacek.ciach's user avatar
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> ...
user avatar
2 votes
1 answer
562 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 ...
isxaker's user avatar
  • 77
2 votes
1 answer
453 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 ...
Alexandro Martinez Dominguez's user avatar
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 ...
K09's user avatar
  • 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 ...
U1_R's user avatar
  • 21
2 votes
1 answer
8k 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, ...
Thufir's user avatar
  • 121
2 votes
0 answers
3k views

MySql Workbench Couldn't find section mysqld in the remote config file /etc/mysql/my.cnf

if you get this trying to connect to your remote server using MySql Workbench, then try to (on your remote server) navigate to /etc/mysql/my.cnf and add [mysqld] then it should look like: !...
Nils Riga's user avatar