Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [proxy]

21 questions
18
votes
2 answers

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 enables the external user to be a proxy for the second…
Darius.V
  • 281
  • 1
  • 2
  • 6
7
votes
2 answers

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 impersonate a restricted-access service account for a SQL…
GregDBA
  • 303
  • 1
  • 4
  • 14
5
votes
2 answers

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" on each step is not desired. How can I quickly…
James Jenkins
  • 6,318
  • 6
  • 49
  • 88
5
votes
2 answers

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 deem appropriate. The driver keeps track of what…
James Crosswell
  • 153
  • 1
  • 1
  • 3
3
votes
1 answer

How I can proxy my connection in order to translate the host that I need to connect upon db?

I need to connect into a mysql via ssh tunnel: ssh -N -L 33308:localhost:3306 myserver And via terminal I try to connect into the mysql server using these commands: mysql -u testusr -p -h 127.0.0.1 -P 33308 testdb mysql -u testusr -p -h localhost…
Dimitrios Desyllas
  • 873
  • 2
  • 14
  • 30
2
votes
1 answer

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 the privilege to connect as App1, then the client…
Leigh Riffel
  • 23,884
  • 17
  • 80
  • 155
2
votes
1 answer

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 these groups. I'm also trying to remove sysadmin…
Hikari
  • 1,603
  • 12
  • 28
  • 42
2
votes
2 answers

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 establishing a connection to SQL Server. The server was…
Felice Pollano
  • 133
  • 5
1
vote
1 answer

Enable remote access to database via proxy server

What's the most painless way to create something like a proxy server so that my dev team can access a database from anywhere? The server in question is a managed MongoDB database. Currently, I am just whitelisting IP addresses in the dashboard for…
Anson Kao
  • 111
  • 3
1
vote
0 answers

Sql Server Agent Job - Unable to start execution of step 1 (reason: Error authenticating proxy "user", system error: The user's account has expired.)

My predecessor created several "Intergration Services Catalogs" dtsx packages which are scheduled / run via SQL Server Agent -> Jobs using an SSISFileProxy which is using SSISProxyCredentials. The expired error "user" is referring to my predecessors…
Wyvernstail
  • 11
  • 2
1
vote
1 answer

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 select s.job_id ,s.name as [job_name] …
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
1
vote
0 answers

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 it still doesn't help. I checked that the proxy…
Afreen
  • 11
  • 2
1
vote
1 answer

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 critical application balanced over three geographically…
Thomas Lobker
  • 113
  • 3
1
vote
2 answers

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 communicate with GCS directly using Navicat/MySQL…
Eustace
  • 125
  • 1
  • 4
0
votes
1 answer

Connecting to SQL Server from externally with proxy server

I have a server running SQL Server 2022 with a couple of instances. There is the need to grant access to an external supplier working with us on a project. The idea is: the supplier connects to our sql server on a specific database they need to…
aganju82
  • 1
  • 1
1
2