Microsoft Sql Server Error 14529
Contents |
14529 0 I configure replication following the MS turorial http://technet.microsoft.com/en-us/library/aa337453.aspx My configuration is Distributor WIN-EVHR6GD8156 Publisher WIN-EVHR6GD8156\REPTGT Subscriber HOMSAR\WULU2012 Configure proxy is not a valid windows user 14529 subscription got error: Server Name: WIN-EVHR6GD8156 Error Number: 14529 Proxy "HOMSAR\repl_distribution"
Sql Server Proxy Account Permissions
is not a valid Windows user. Changed database context to 'CoreDB-SVRIA-DX'. Warning: The distribution agent job has been implicitly created and will run under the SQL Server Agent Service Account. Job 'WIN-EVHR6GD8156-CoreDB-SVRIA-DX-publ_200_coredx-HOMSAR\WULU2012-17' started successfully. (.Net SqlClient Data Provider) I expect using the linked server repl_distributor to connect to the Distributor. What is wrong? more ▼ 0 total comments 801 characters / 82 words asked Oct 04, 2013 at 10:22 AM in Default luggg 90 ● 9 ● 11 ● 14 add new comment (comments are locked) 10|1200 characters needed characters left ▼ Everyone Moderators Original poster and moderators Other... Viewable by all users 1 answer: sort voted first ▼ oldest newest voted first 0 The machine user repl_distribution on HOMSAR is apparently not recognized as a user on the WIN-EVHR6GD8156 machine. Are you in a domain? You might try to use a domain account with adequate pemission that can be authenticated on both machines. At the very least, you need to have some type of user that is recognized by both machines. I'm a bit rusty on mapping machine users between machines - maybe you can tell WIN-EVHR6GD8156 than HOMSAR\repl_distribution is a valid user. more ▼ 0 total comments 486 characters / 80 words answered Oct 15, 2013 at 03:39 AM KenJ 24.7k ● 3 ● 10 ● 19 add new comment (comments are locked) 10|1200 characters needed characters left ▼ Everyone Moderators Original poster and moderators Other... Viewable by all users Your answer toggl
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Why occurs Error 14529 (Proxy '%s' is not a vaild windows user) after configuration of Peer to Peer topology Want to Advertise Here? Solved Why https://ask.sqlservercentral.com/questions/107077/subscription-configure-failed-error-number-14529.html occurs Error 14529 (Proxy '%s' is not a vaild windows user) after configuration of Peer to Peer topology Posted on 2008-09-15 MS SQL Server 2005 1 Verified Solution 1 Comment 3,073 Views Last Modified: 2011-10-03 Hi, all Starting situation: Two Pc (pc35 and pc44) running XP Pro connected over Win NT4 server as workgroup members (no domain!). Both running Ms Sql https://www.experts-exchange.com/questions/23731443/Why-occurs-Error-14529-Proxy-'-s'-is-not-a-vaild-windows-user-after-configuration-of-Peer-to-Peer-topology.html 2005 Developer Edition with a vb6 application. On pc35 this users (full rights): Distr, Snap, LogReader. On pc44 this users (full rights): Distr, Snap, LogReader (same names as on pc35). Shared path \\pc35\Snapshot and \\pc44\Snapshot44. Following "Ross Mistry, MS SQL Server 2005 Management and Administration Chapter 6.Administering SQL Server Replication" I tried to setup a Peer to Peer transactional replication using the said users and shared pathes. In the databases I logged in the said users. The database on each PC is 'LeoAlpha', The distribution database on each PC I named 'LeoAlphaDistr'. The publication on each PC I named 'LeoAlphaPub'. Firewall disabled on both pc's. At finishing configuration of the peer to peer topology I get the following error message (in german): >> SQL Server konnte kein Abonnement für Abonnent 'PC35' erstellen - Ausnahme beim Ausführen einer Transact-SQL-Anweisung oder eines Transact-SQL-Batches. --- Der Proxy "pc35\Distr" ist kein gültiger Windows-Benutzer. Der Datenbankkontext wurde auf 'LeoAlpha' geändert. Der Auftrag 'PC44-LeoAlpha-LeoalphaPub-PC35-4' wurde erfolgreich gestartet. Warnung: Der distribution-Agentauftrag wurde implizit erstellt und wird unter dem Konto des SQL Server-Agent-Dienstes ausgeführt. (Microsoft SQL Server, Fehle
contains the information needed for the package. I did this as described on: http://msdn2.microsoft.com/en-us/library/ms190703.aspx . After that i tried to create an proxy account, but when I chose the created credential, Management Studio http://www.bigresource.com/MS_SQL-Cannot-use-credentials-for-proxy-account-Tj40G8Ri.html says "Der Proxy "[name_of_credential] ist kein gültiger Windows-Benutzer(Microsoft SQL Server, Fehler: 14529)". This means something like: "This Proxy is not a valid windows-user. Error: 14529". Any hints how to use a credential that is not a windows-user? Regards, Jan Wagner View 7 Replies Similar Messages: Xp_cmdshell Does Not Execute For Non-sysadmin Account Even With Proxy Account Problem Running SSIS Package Using Credentials/Proxy Proxy Account. Error On SET Proxy Account sql server SQL 2012 :: Proxy Account Not Being Used Creating A Proxy Account Proxy Account/Credential Proxy Account Not Responding Proxy Account - SQL Server Proxy Account Security. Error Authenticating Proxy Account Proxy Account Principals Not Saved Execute A Stored Procedure Using A Proxy Account SQL2K CmdExec Proxy Account Setup Execute Stored Proc Using A Proxy Account In 2005 Does Xp_cmdshell Proxy Account Need Admin-level Permissions? Integration Services :: Required Privilege Is microsoft sql server Not Held By Client In SSIS With Proxy Account Execute A Stored Procedure Which Calls SSIS Packages Using A Proxy Account For Non Sysadmins In Sql Server 2005 Proxy Auto-Configuration Url Not Found Error - But Not Using Proxy Whether To Use Local System Account Or Domain Account For Service Account SA Account (DBA System Account) Granting Priveleges But SQL Server 2000 Not Applying Them DTS Fails As A Job With Service Startup Account As "System Account" Domain Account Vs Local Account For SQLServerAgent Domain Account Without A SQL Login Account Cmd Shell Proxy Proxy Error Problem With A Proxy Proxy Fails To Run The Job XML Source And Proxy Need Help With Credentials..... DTS Package - FTP Download Thru Proxy Xp_cmdshell From IIS: Proxy Not Working ADVERTISEMENT Xp_cmdshell Does Not Execute For Non-sysadmin Account Even With Proxy Account Mar 2, 2004 Hi all, i hope you can help me.Basically a dts package has been setup that pulls in data from another companies server, this data requires to be on-demand i.e individual users can pull in updates of the data when they require it.I am using xp_cmdshell and dtsrun to pull in the data. This obviouly works fine for me as i am a member of sysadmin.Books onlin