Questions tagged [proxy]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
26 views

Proxying a Postgres connection

I have a client whose Postgres database I need to connect to periodically. This database is currently hosted on their server, let's call it psql.example.com, with standard port 5432. They have it ...
1
vote
1answer
35 views

how to script out proxy accounts?

I have servers where I use proxy accounts to run ETL processes or even to backup SSAS databases using powershell through a job. I can see what AD Accounts are related to my proxies: use msdb go ...
1
vote
0answers
491 views

SSIS job runs successfully but doesn't load data

I am running a job from SQL Server Agent and the job runs successfully. However it doesn't load any data (in my case Excel files from a local folder). I created a new Proxy Account to run this job but ...
0
votes
2answers
501 views

Is it possible to redirect queries to another server?

I want to set up a server that redirects queries. It would receive incoming SQL Server traffic, redirect to the actual SQL Server, and return results back to the client. Is this possible? What are ...
1
vote
1answer
305 views

MongoDB how to achieve asynchronous geo-replication

I have read a lot of background about MongoDB replication and sharding. None of the default solutions that I know can actually do what I'm trying to achieve. Current situation We have a time ...
0
votes
1answer
420 views

Postgres-XL adding GTM Proxy seems to do nothing

I've set up a Postgres-XL cluster using this recipe: GTM: hostname=host1 nodename=gtm Coordinator: hostname=host2 nodename=coord1 Datanode1: hostname=host3 nodename=datanode1 Datanode2: hostname=...
2
votes
1answer
929 views

SELECT Proxy User For Other Sessions

When a Proxy Authentication is used, there is the impersonated user (called the client) and the impersonating user (called the proxy). So if Bob wants all the privileges of App1 and has been granted ...
7
votes
2answers
4k views

SSIS proxy/credentials not working from within SQL Agent job step

I have been looking around and found similar questions but nothing specific to what I am having trouble with. Problem: I cannot get the SSIS proxy and SQL credentials configured correctly to ...
3
votes
2answers
12k views

How to find what SQL Jobs are using a specific account as Proxy?

We have identified a few servers that are using Proxy accounts inappropriately. Some of these servers have multiple Credentials and Lots of Jobs. Manually checking the Job Property GUI for "Run As" ...
2
votes
1answer
1k views

Unable to set user/group as principal on a proxy

I'm organizing permissions on our SQL Server instance. I want to stop using a SQL Server account, and instead grant permissions to Active Directory groups, and then add user and service accounts to ...
4
votes
2answers
13k views

Can MongoDB be configured to sit behind a load balancer?

According to this post: In a single replica set, you cannot distribute writes, they all must go to the primary. You can distribute reads to the secondaries already, via Read Preferences as you ...
2
votes
2answers
348 views

Troubles connecting to a SQL Server Express instance on AWS

I'm trying to remote connect a SQL Server Express instance that is running on AWS on a db.t2.micro. I'm getting the following error: A network-related or instance-specific error occurred while ...
1
vote
2answers
2k views

Connecting to Google Cloud SQL via SSH

The network I'm using doesn't allow port 3306 so I can't connect to Google Cloud SQL. How do I set up a proxy server (on a different network that allows 3306) that I could connect to via SSH to ...
15
votes
1answer
15k views

MySQL GRANT PROXY - what does it mean?

I run: show grants for root@localhost; and I see GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION From mysql docs: https://dev.mysql.com/doc/refman/5.5/en/proxy-users.html This ...