Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [proxy]

17 questions
17
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
  • 271
  • 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
  • 273
  • 1
  • 4
  • 13
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
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
  • 5,948
  • 6
  • 35
  • 77
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,534
  • 16
  • 75
  • 147
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,403
  • 10
  • 25
  • 36
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
  • 4
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
  • 14,544
  • 46
  • 126
  • 249
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
  • 1
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
  • 25
  • 1
  • 4
0
votes
1 answer

How to configure Oracle traffic director for full site failover to have high availability?

I have two server systems, each server having both Apache Tomcat server (deployed web app) and Oracle 11g database server. The database on the two servers is synchronised by Oracle Data Guard for high availibility. Tomcat web server is running…
Rishi Gandhi
  • 1
  • 1
0
votes
1 answer

How to block SSMS from accessing the internet?

How do I block SQL Server Management Studio from accessing internet sites? Let me set the stage. I'm sitting behind a Bluecoat proxy server at work. We have a management policy forbidding us to access the internet using a privileged account. And…
user763861
  • 43
  • 1
  • 6
0
votes
1 answer

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 configured so that I can connect to it from my…
Greg Schmidt
  • 103
  • 1
1
2