8
votes
Connect to SQL Server over Internet
The recommended way to do this is to set up a VPN between the two sites. The steps to do this vary depending on the particular firewall/router being used. If a VPN cannot be used, the following ...
4
votes
Command line tool / script to backup a remote SQL Server database to local disk
There are two common ways to do this:
Easy way - with "normal" database backups - when you run the BACKUP DATABASE command, the SQL Server service on the remote box needs to write the backup to a ...
- 43.2k
4
votes
Cannot remotely access PostgreSQL on EC2 instance
(self-answering in case someone else has these same symptoms!)
Then I stumbled upond Shubham Dipt's post on
"PostgreSQL on EC2 (Ubuntu) in AWS",
making me aware of the "Security group" layer AWS ...
- 201
4
votes
Accepted
Is it possible to force a query to ignore the server option "remote proc transaction promotion" so it doesn't promote remote proc transaction?
Is there a query hint or some way to force it to not promote a remote procedure transactions?
No there isn't, but if you're currently doing something like this:
INSERT #Temp
EXECUTE schema_name....
- 90.3k
3
votes
Accepted
Connecting to mySQL from 2 different machines
So what you can do :
If you want to change IP from 192.168.1.4 to 192.168.1.3 then you can update mysql.user table
Update mysql.user set host =' 192.168.1.3 where host='192.168.1.3' ;
Flush ...
3
votes
Command line tool / script to backup a remote SQL Server database to local disk
This sounds like the perfect use of a newer tool by Microsoft, mssql-scripter. This open source, python based bad boy should be able to do everything you need.
Warning: it is still technically in ...
3
votes
Command line tool / script to backup a remote SQL Server database to local disk
Your requirements require the use of the following two tools:
sqlcmd (SQL Server Built-In CMD Tool)
psexec (SysInternals Remote Execution Tool)
SQLCMD
First you have to have a valid SQLCMD command. ...
- 18.3k
3
votes
Unable to remotely connect to Postgresql 9.5 instance
Turns out my hosting provider moved the server behind a managed firewall without notice.
- 61
3
votes
SQL Server Management Studio - Debugger buttons greyed
You need to open the network ports & firewall ports between your desktop running SSMS, and the remote computer.
Just generally speaking, though, I'd highly recommend against running the debugger ...
- 43.2k
3
votes
Accepted
PostgreSQL error: remote query result rowtype does not match the specified FROM clause rowtype, on remote function call
To understand what's going on, first check what is being done on the remote:
SELECT _test1();
_test1
────────
(1,2)
This does return a record, not two integers. When the dblink() call reports
...
- 31.6k
2
votes
Using postgres database from another computer
Yes, two things that need to happen:
Your database must be listening on a port and ip to external connections. For this you need to modify postgresql.conf, you may choose to use the new-ish method of ...
- 64.7k
2
votes
can't connect to remote postgresql database
I do not agree to use
host all all 0.0.0.0/0 md5
if your database is exposed to the internet. In my project postrgres is in the cloud and it is used from the backend. I need to connect directly to ...
2
votes
Accepted
Connect to SQL Server on Linux over the network
1st you need to identify your VM IP address, supposing it is 10.1.1.10
sqlcmd -S 10.1.1.10 -U SA -P "YourPassword"
Either check connectivity between your host and your VM using
ping 10.1.1.10
and/...
- 451
2
votes
How to connect to a SQL Server installed on Windows Server 2012 running on VPS?
In addition to using SQL Server Configuration Manager to enable TCP/IP connections, you need inbound tcp port 1433 and optionally udp port 1434 open at the firewall for SQL Server to accept inbound ...
- 70.5k
2
votes
Accepted
Is there a server option which limits the amount of rows returned by a remote query?
You can use OFFSET and FETCH to effectively page through results
e.g.
SELECT * FROM MyTable ORDER BY MyColumn OFFSET 100 FETCH NEXT 100 ROWS ONLY
Helpful article here...
Article About OFFSET FETCH
...
- 758
2
votes
Connecting to server which located remotely throws timeout exception
In your manual procedure you state that you specify "name" in the server name, not an instance.
However in your connection string you specify
Data Source =tcp:<IPAddress of RDP Machine>\<...
- 15.7k
2
votes
How to insert data from a local MSSQL db table to a remote MSSQL db table using WCF application coded in .NET
I can see four ways you could accomplish this:
1. Linked servers
You can establish a linked server on both the local and remote SQL Server, which will allow you to reference tables not only on the ...
- 9,133
2
votes
PostgreSQL error: remote query result rowtype does not match the specified FROM clause rowtype, on remote function call
In my scenario, I get exactly the same error.
ERROR: remote query result rowtype does not match the specified FROM
clause rowtype
I have a VIEW using dblink and initially I create a VIEW using "...
- 151
2
votes
Accepted
How to insert into temp table on Server A results from dynamic SQL open query stored proc call to remote server B via Remote Query showplan operator?
I noticed in the execution plan, it's using a Remote Scan showplan operator. I know when possible the Remote Query showplan operator is more efficient...
There's nothing inherently inefficient about ...
- 90.3k
2
votes
Allow user to create databases on server and to see only the databases that are created by him, without creating login first
Instead of making Logins for each user, you should use an Active Directory Group that each user is a part of (e.g. DOMAIN USERS), and assign permissions directly on that AD Group or on a Role you can ...
- 39.6k
2
votes
Enable remote access to database via proxy server
Have you thought of something like humongous.io (disclaimer I'm a co-founder)?
It's an online GUI for MongoDB. You whitelist one IP address (Humongous' server) and your team can access MongoDB through ...
- 121
1
vote
Unable to update MySQL table from linked server on SQL Server 2014
Configure the MSDASQL provider
I believe the following should fix it. Turn on the following for SQL Servers MSDASQL provider:
AllowInProcess
IndexAsAccessPath
LevelZeroOnly
DynamicParameters
...
- 2,798
1
vote
Unable to connect from remote computer, while local connection works
Rather than using the IP, Use yourdomain\SQLinstance
Also have you allowed the TCP port inbound through the windows firewall on the server side?
Also change server authentication:
Lastly I would ...
- 63
1
vote
Connect to SQL Server on Linux over the network
Microsoft SQL Operations Studio, which works on Linux, Mac, and Windows, is a feature-rich SQL Server-compatible graphical client.
Assuming your VM has the appropriate ports open in it's firewall, ...
- 70.5k
1
vote
Accepted
MariaDB ran mysql_secure_installation, but seeing remote login attemps in logs
Yes, the server would still be accepting remote connections. And yes, it probably did what it was supposed to do. mysql_secure_installation doesn't set bind-address=127.0.0.1 neither in MariaDB nor in ...
- 6,479
1
vote
Oracle database connection instant timeout
That timeout can be configured with the SQLNET.OUTBOUND_CONNECT_TIMEOUT parameter.
For example, place the below in sqlnet.ora, which results in outbound connections timing out after 10 seconds ...
- 41.1k
1
vote
TNS connection forward
You tried
ssh MachineD -L 15219:MachineB:15220 -L 15220:MachineA:1521
this did not work but you think in the right direction, you want to join two tunnels.
login to MachineD and make a tunnel from ...
- 7,751
1
vote
How to Backup Remote Database to FTP server
You have two processes here that are discrete,
Dumping the database.
Moving the dump to an FTP server.
There are numerous ways to accomplish both of these. You'll have to ask a more specific ...
- 64.7k
1
vote
Unable to connect to SQL Server 2016 remotely
should i construct the server name as tcp:ipaddress\instance, 1433
Absolutely no.
All that the network library needs to connect to SQL Server instance is it's IP + port.
When you are using default ...
- 11.2k
1
vote
Accepted
How to replicate schema changes from local database to a remote?
Next time, click the Generate Scripts button and then execute the generated SQL script at both the local and remote databases.
For the changes you made locally, that you now want to replicate to the ...
- 9,507
Only top scored, non community-wiki answers of a minimum length are eligible