SQL Server 2005: The target server cannot download a multiserver job from the master server if the target server is running a German version or a French version of SQL Server 2005 or a German version of SQL Server 2008 R2
By TechSupport
SUPPORT PROBLEM: The target server cannot download a multiserver job from the master server if the target server is running a German version or a French version of SQL Server 2005 or a German version of SQL Server 2008 R2
Applications Supported:
COPYRIGHT NOTICE: (c) 2007 Microsoft Corporation. All rights reserved.
SUPPORT SOLUTION:
Consider the following scenario:You create a multiserver environment that contains a target server and a master server. The target server is running a German or French version of Microsoft SQL Server 2005 or a German version of SQL Server 2008 R2. On the master server, you create a multiserver job.In this scenario, the target server cannot download the multiserver job. Additionally, an error message that resembles the following is logged in the SQL Server Agent log (Sqlagent.out) on the target server: - Fehler, [298] SQLServer-Fehler: 102, Falsche Syntax in der Nähe von ‘%’. [SQLSTATE 42000] (DownloadMSXInstructions).- Fehler, [298] SQLServer-Fehler: 102, Falsche Syntax in der Nähe von ‘0xf2cd03d68967b44caaf3bb311c512703′. [SQLSTATE 42000] (ProcessJobMSXInstruction).- Erreur, [298] Erreur SQLServer : 105, Unclosed quotation mark before the character string ‘, 16, 1, @msx_version) END’. [SQLSTATE 42000] (DownloadMSXInstructions)Note The SQL Server Agent log is located in the same folder as the errorlog of the SQL Server. See description of parameter “-e” in the topic “sqlservr Application” in SQL Books Online for more details..Service pack information for SQL Server 2008 R2
2, ‘resolution’);
To resolve this problem, obtain the latest service pack for SQL Server 2008 R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2527041
(http://support.microsoft.com/kb/2527041/
)
How to obtain the latest service pack for SQL Server 2008 R2
. You can avoid this error situation by setting the display language of your SQLAgent- account on the TSX- Server to US- English..Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the “Applies to” section.This problem was first corrected in SQL Server 2008 R2 Service Pack 1 for SQL Server 2008 R2..
For File Repair and Data Recovery, visit File Repair / Data Recovery