DB Maintenance Plan - SQL Server Agent job failing due to incompatible version??

Question

DB Maintenance Plan - SQL Server Agent job failing due to incompatible version??

brossin

SSC Enthusiast

Points: 159
More actions
May 4, 2016 at 7:45 am

#313711

We have a database server on which I created a DB Maintenance Plan for to create Full and Log Backups. Unfortunately, the SQL Agent job does not run successfully. The error reported is:
The process could not be created for step 1 of job 0xBE102EC199E6D24A90F336014BA10306 (reason: This version of %1 is not compatible with the version of Windows you're running. Check your computer's system information to see whether you need a x86 (32-bit) or x64 (64-bit) version of the program, and then contact the software publisher). The step failed.
SQL server is running as 64-bit and the Windows 2008 server is 64-bit as well so I am at a loss as to how to fix this. Any suggestions on how to get this Backup Maintenance Plan running?
In case it helps, the SQL Server version (using @@VERSION) is:
(Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

I think the issue is you developed/created the package in a higher version of BIDs (or potentially 2012/2013 SSDT), right?

Pretty sure you created it in Visual Studio 2010, but the SQL servers's DTS compatibility is for VS2008, right?

you'll want to recreate the plan in VS2008 for the 2008/2008R2 instances.

here's the first link for similar issues i found when searching for VS2010 SQL 2008R2

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/63a39741-be26-4c40-94d7-ab8626438e5a/visual-studio-2010-sql-2008-or-sql-2008-r2?forum=sqlgetstarted

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

brossin SSC Enthusiast Points: 159 More actions · Answer 2

Lowell,

I am not using Visual Studio to create a package. I am creating a maintenance plan directly in SQL Server Management Studio. That maintenance plan creates SQL Agent jobs automatically. Any other suggestions/thoughts?

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 3

Was the SQL Server Management Studio you used installed on the server when SQL was installed or is it on another system connecting remotely? Is the version of SSMS running the same version of SQL as the db engine?

Joie Andrew
"Since 1982"

brossin SSC Enthusiast Points: 159 More actions · Answer 4

Joie,

My PC has SSMS v10.50.1617.0. The server has SSMS v10.50.1600.1. I had created two different Maintenance Plan - one using SSMS on the server and the other using SSMS on my PC . Both maintenance plans failed with the same error message. Any other thoughts?