Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [remote]

135 questions
24
votes
2 answers

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.47 psql: FATAL: no pg_hba.conf entry for host…
dot
  • 781
  • 5
  • 11
  • 22
16
votes
2 answers

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 user and giving that user appropriate permissions…
velojason
  • 161
  • 1
  • 1
  • 3
12
votes
2 answers

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 to expose a database to the internet (cert-only…
dreamlax
  • 375
  • 2
  • 5
  • 13
12
votes
4 answers

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 person WITH(NOLOCK); From any other box on the…
FranticRock
  • 323
  • 1
  • 3
  • 12
10
votes
2 answers

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 client I get the error above while trying to connect…
Chibuzo
  • 265
  • 2
  • 4
  • 9
9
votes
2 answers

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 only really need it as an annotation because some…
odinho - Velmont
  • 221
  • 3
  • 7
8
votes
2 answers

How to allow remote connections to mysql from specific IPs only?

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 am looking for simple and elegant way to do this…
python man
  • 81
  • 1
  • 1
  • 2
7
votes
2 answers

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 database: the server reports FATAL: no pg_hba.conf entry…
Sean Allred
  • 207
  • 1
  • 4
  • 10
7
votes
1 answer

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 insert into a local table.
Guillermo Gutiérrez
  • 667
  • 2
  • 7
  • 13
7
votes
1 answer

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 both SQL Server and SQL Server Browser (1433 -…
salbenny
  • 71
  • 1
  • 1
  • 3
7
votes
1 answer

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 Remote Debugger to debug a very large stored…
Garrett Bates
  • 193
  • 1
  • 5
6
votes
4 answers

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 allowance. Has anyone tried, or is it possible…
孔夫子
  • 4,330
  • 3
  • 30
  • 50
6
votes
1 answer

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 out Is the server running on host *EC2ExternalIP*…
rikb
  • 201
  • 2
  • 6
6
votes
3 answers

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 interaction with application. As always, the web is…
Aubergine
  • 221
  • 2
  • 3
  • 5
5
votes
1 answer

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 context of the local administrator account of the…
Thomas Stringer
  • 42,434
  • 9
  • 120
  • 155
1
2 3
…
8 9