Error Authenticating Proxy Sql Server 2008 Replication
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » SQL Server 2008 High Availability » SQL 2008 error authenticating proxy sql server 2012 replication is failing 15 posts,Page 1 of 212»» SQL 2008 replication is failing Rate Topic
Sql Server 2008 Express Replication
Display Mode Topic Options Author Message Oracle_91Oracle_91 Posted Thursday, April 15, 2010 7:49 AM Right there with Babe Group: General Forum Members
Sql Server 2008 Replication Tutorial
Last Login: Wednesday, November 12, 2014 11:36 AM Points: 774, Visits: 1,742 Hi,I tried to confgure the replication sql 2008 between 2 systems (i.e 2 sql server instances on 2 different machines).Machine-A is acting as both
Sql Server 2008 Replication Types
Distributor and Publisher Machine-B is acting as subscriber.After configuring everything and once i open the replication monitor, i found replication failed. Pl find below error.Unable to start execution of step 2 (reason: Error authenticating proxy NT AUTHORITY\NETWORK SERVICE, system error : Logon failure : unknown user name or bad password). The step failed.and in Error details pane It is showing The job failed. The Jon was invoked by user sa. But i currently sql server 2008 replication step by step logged in as "sa" user. is that any problem???Can anyone suggest me on this on how to fix this problem and why it happened so.or do i need to use explicit domain accnt while specifying SQL Agent Security during the setup.Thanks in Advance, Post #904032 Roy ErnestRoy Ernest Posted Thursday, April 15, 2010 8:07 AM SSCrazy Group: General Forum Members Last Login: Tuesday, October 4, 2016 11:55 AM Points: 2,381, Visits: 6,849 SQL Service and Agent Service has to run under a domain account. Check if that is the case in your set up -Roy Post #904052 Oracle_91Oracle_91 Posted Thursday, April 15, 2010 10:25 PM Right there with Babe Group: General Forum Members Last Login: Wednesday, November 12, 2014 11:36 AM Points: 774, Visits: 1,742 currently, it is running under NT AUTHORITY\NETWORK SERVICE account.What does the above account mean?Is that mandatory to give the domain account only? Post #904549 Oracle_91Oracle_91 Posted Friday, April 16, 2010 1:14 AM Right there with Babe Group: General Forum Members Last Login: Wednesday, November 12, 2014 11:36 AM Points: 774, Visits: 1,742 Observations.1.SQL Server Agent Service is running under domain accnt. It is configured in SQL Server Configuration Manager.2.Restarted the SQL Server Agent and started successfully.3.Logged in as "sa" and configured the replication in sql 2008.4.Both Publisher and Subscriber both are sql
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow sql server 2008 replication monitor latency the company Business Learn more about hiring developers or posting ads with us Database sql server 2005 replication Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals sql server 2000 replication who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The http://www.sqlservercentral.com/Forums/Topic904032-1549-1.aspx best answers are voted up and rise to the top Error Authenticating Proxy Account when Executing SSIS job up vote 5 down vote favorite I have a SQL Server instance that runs 5 scheduled tasks each night, each of which run SSIS packages. These packages have been running for years and the associated steps run via a Proxy Account (PackageExecutor). PackageExecuter is associated with a SQL Credential that was a former domain admin http://dba.stackexchange.com/questions/21401/error-authenticating-proxy-account-when-executing-ssis-job account. Soon, the domain associated with this admin account is going to be shutdown. I have to use a new account, on a new domain, as the admin account associated with my roxy, PackageExecutor. When I created a new Credential for the new Admin account and associated it with PackageExecutor, I started to get the following error when I tried to run one of my SQL jobs as a test: Unable to start execution of step 1 (reason: Error authenticating proxy *Domain\Admin_Account*@*fully.qualified.domain.com*, system error: Logon failure: unknown user name or bad password.). The step failed. If I'm understanding this reasonably explicit error, what it's telling me is that the Credential accounts, associated with my proxy is in correct. How do I validate this? I know that this account is legitimate-- I've already associated it with every associated server group, I've made it a sysadmin user on the server. What could be causing this problem? To be clear, I haven't mis-typed the account name or the password associated with the Proxy Credential. However, when I entered the account name Domain\Admin_Account and clicked the Check Names button, SQL Server automatically transformed the User ID to the fully-qualified version. I'm not sure if this has anything to do with this problem. I'm at a bit of a loss. I've giv
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more http://serverfault.com/questions/283898/unable-to-authenticate-proxy-when-starting-sql-snapshot-agent about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Unable to authenticate proxy when starting SQL snapshot agent up vote 1 down vote favorite sql server I have a Windows Server 2008 R2 install running SQL Server 2008 R2 with all the latest updates etc applied, I have restored a database from an old image (SQL 2005) and am trying to get web-sync working with merge subscriptions. However when I attempt to start the SQL Snapshot Agent on the distribution I have defined I get this error: Unable to start execution of step 2 (reason: Error authenticating proxy SERVER-NAME\Administrator, system error: Logon failure: unknown sql server 2008 user name or bad password.). The step failed. I am starting the agent as the computer admin and am not using a proxy server. Any ideas on why this might show up? See below: The params used by the SQL Snapshot agent are: -Publication -Publisher -Distributor -PublisherDB -ReplicationType If you are using SQL Server Authentication (I am), you must also specify the following arguments: -DistributorLogin -DistributorPassword -DistributorSecurityMode = 0 -PublisherLogin -PublisherPassword -PublisherSecurityMode = 0 sql-server sql-server-2008 windows-server-2008-r2 sql merge-replication share|improve this question edited Jun 28 '11 at 8:35 asked Jun 24 '11 at 11:35 Myles Gray 3431926 migrated from stackoverflow.com Jun 24 '11 at 18:23 This question came from our site for professional and enthusiast programmers. Can you post the parameters from step 2 of the job? Be sure to mask any passwords. –mrdenny Jun 24 '11 at 18:37 Hi @mrdenny, I have attached a screenshot above, All I am doing is right clicking the publication, clicking view snapshot agent status and clicking start and I am confronted with that. –Myles Gray Jun 24 '11 at 19:13 Can you edit the SQL Agent job which is what actually runs the Replication agent and show those properties? –mrdenny Jun 27 '11 at 22:27 Hi @mrdenny, see above, I have added what params are needed by the snapshot agent, I can find the procedure too if n