Proxies: What Is It For?
Jul 19, 2006Let me know any link for that.
tia
ADVERTISEMENT
SQL Server Express And Proxies
Dec 13, 2007I want to know how I get SQL Server Express to use a proxy when connecting to a remote server?
I have SQL Server Express 2005 installed on my laptop.I connect to the internet on the laptop by a proxy.
My desktop has a satellite service called skyDSL which allows me to use satellite to dial-up to the internet. There is a way of configuring it so other machines can connect to it by proxy. You simply connect a crossover cable between the laptop and the desktop and then enter the proxy address under "Tools-Internet Options-Connections-Lan Settings-proxy server"
I have been trying to connect on the laptop to the server that holds my sql server database (hosting365.ie) through SQL Server Express with no success.
This is obviously because the laptop is not directly connected to the internet but by proxy.
I have been changing the settings on sql server configuration manager (I have SQL Server Management Studio Express installed) to make it use the proxy but with no luck.
I am wondering is it actually possible to use a proxy on SQL Server Express is it only possible on the full version?
Any replies appreciated.
Jobs, Proxies And SQL Agent Permissions.....
Apr 22, 2008I have a job with a single ActiveX step that I have setup and am having problems running.
If i set the SQL Server Agent to run as an Administrator then my job processes fine however under the default setup which has the SQL Server Agent running as Local System I get an error.
I assume this is permissions problem so I created a basic windows user called ABC. I then created a credential called ABC linked to the windows user ABC. I then created a proxy that uses the credential ABC and then ticked the box that allows the proxy to run ActiveX scripts. I then set the ABC as a principle of the proxy.
I then set my single job step to be run under the ABC credential.
Still no luck. This is the first time i've worked with this sort of thing so I'm not sure if I'm going about it in the right way.
Please explain how i can have a job that runs as an active X script. I understand running sql server agent as administrator is bad for security so what are the alternatives?
Using Credentials And Proxies In Transactional Replication
Dec 12, 2006Hi everybody,
while playing around with replication in SQL Server 2005 I tested other accounts then the server agent account for log reader agent, snapshot agent and distributor agent. I found that the SQL Server generates credentials and proxies for every agent.
But when I use procedures to set up a replication I need to specify the account and the passwort. And I don't like to have passwords in scripts. So my idea was to generate my own credentials and proxies and use them for setting up a replication. But it doesn't work. I couldn't find out how I can use my own credentials and proxies instead of accounts and passwords.
Is it somehow possible to do what I want ? Did I miss something ?
Regards
Wolfgang
Proxy Object Always Listed In Unassigned Proxies
May 2, 2007I am running into a problem that I have seen others describe but yet to find an answer.
When defining a proxy user and setting it active to any subsystem it always shows up as unassigned and I am unable to reference it in my agent jobs via the 'Run-as' dropdown.
Under the "active to the following subsystems" box in the proxy accounts properties the subsystem I specified when it was created is not checked, when checking it I receive an error that it is already defined. The proxy does not show in the 'Run-as' pulldown.
However, if I script adding the job, and add @proxy_name to the sp_add_jobstep stored procedure it seems to impersonate correctly. It does not show up in the UI.
Any idea's ?
The problem has also been described here;
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=238493&SiteID=1
Creating Credentials And Proxies Pointing To SQL Server Login To Run A Job
Nov 8, 2006How to "CREATE credentials pointing to SQL SERVER logins" and "creating proxys for SQL server agent pointing to SQL SERVER login.
As The SQL server login does not display in the CHECK NAMES list when we are trying to select the identity but All the other Windows logins display correctly in this list .
So using the SQLserver login fails to run a SQL server Job (which uses the credentials and proxies pionting to SQL server logins)