DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2216501 - Last Review: April 22, 2011 - Revision: 2.0

On This Page

SYMPTOMS

Consider the following scenario:
  • You configure a server that is running Microsoft SQL Server 2000 as a master server (MSX).
  • You try to enlist a server that is running Microsoft SQL Server 2008 with Service Pack 1 (SP1) or Microsoft SQL Server 2008 R2 as a target server (TSX).
In this scenario, multiserver jobs are not downloaded from the target server when they are created. If you try to run a multiserver job from the master server, the job fails, and the error log of the SQLServerAgent displays the following error:

[298] SQLServer Error: 170, Line 1: Incorrect syntax near '('. [SQLSTATE 42000]
298 = IDS_SERVER_ERROR (from source)

CAUSE

This issue occurs because the query that is run by the SQLServerAgent (TSX) was updated in SQL Server 2008 and in SQL Server 2008 R2 to fix a query parameterization issue. This change to the query syntax is unsupported by the SQL Server 2000 query syntax. When the updated query is run a computer that is running SQL Server in the MSX role, the query fails.

RESOLUTION

Service pack information for SQL Server 2008

To resolve this problem, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
968382  (http://support.microsoft.com/kb/968382/en-US/ ) How to obtain the latest service pack for SQL Server 2008
After you have applied this service pack to the SQL 2008 TSX server, the jobs are downloaded successfully.

Service pack information for SQL Server 2008 R2

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
After you have applied this service pack to the SQL 2008 R2 TSX server, the jobs are downloaded successfully.

STATUS

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 Service Pack 2 for SQL Server 2008.
This problem was first corrected in SQL Server 2008 R2 Service Pack 1 for SQL Server 2008 R2.

APPLIES TO
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
Keywords: 
kbprb kbsurveynew kbpubtypekc kbtshoot kbfix KB2216501
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support