RE: SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesn't WORK

Tech-Archive recommends: Speed Up your PC by fixing your registry



Hello,

Thanks for posting in our newsgroup.

From your description, I know that you got an error when trying to save a
Maintenance Plan in SQL Server 2005. If I am off-base, please don't
hesitate to let me know.

I am sorry that is a pure SQL issue, please open a new thread in
Microsoft.public.sql newsgroup. Thanks for your understanding.

If you need further assistance, please don't hesitate to let me know.

Best regards,

Robert Li(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================

This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
<From: plutz <thelutzs@xxxxxxxxx>
<Newsgroups: microsoft.public.windows.server.sbs
<Subject: SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesn't WORK
<Date: Mon, 09 Jul 2007 19:49:38 -0000
<Organization: http://groups.google.com
<Lines: 30
<Message-ID: <1184010578.302556.145800@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
<NNTP-Posting-Host: 207.191.112.2
<Mime-Version: 1.0
<Content-Type: text/plain; charset="iso-8859-1"
<X-Trace: posting.google.com 1184010578 17384 127.0.0.1 (9 Jul 2007
19:49:38 GMT)
<X-Complaints-To: groups-abuse@xxxxxxxxxx
<NNTP-Posting-Date: Mon, 9 Jul 2007 19:49:38 +0000 (UTC)
<User-Agent: G2/1.0
<X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4,gzip(gfe),gzip(gfe)
<Complaints-To: groups-abuse@xxxxxxxxxx
<Injection-Info: k79g2000hse.googlegroups.com; posting-host=207.191.112.2;
< posting-account=-rTQdQ0AAAB0BTDdt7eTV2r0q4Fz5W4A
<Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!msrtrans!
msrn-in!newshub.sdsu.edu!postnews.google.com!k79g2000hse.googlegroups.com!no
t-for-mail
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:49259
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<I get an error when I try to save a Maintenance Plan in SQL Server
<2005 that was installed with SBS2003R2 Premium.
<
<TITLE: Maintenance Plan Wizard Progress
<------------------------------
<
<Create maintenance plan failed.
<
<------------------------------
<ADDITIONAL INFORMATION:
<
<Create failed for JobStep 'Subplan'.
<(Microsoft.SqlServer.MaintenancePlanTasks)
<
<An exception occurred while executing a Transact-SQL statement or
<batch. (Microsoft.SqlServer.ConnectionInfo)
<
<The specified '@subsystem' is invalid (valid values are returned by
<sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
<
<Everywhere I search see discussion of SQL Server 2005 Integration
<Services (SSIS). I have found a
<<a href="http://support.microsoft.com/kb/909036";>MSKB</a> that
<discusses how to install SSIS, but I have also read that the SQL
<Server 2005 Workgroup does not support SSIS.
<
<What am I to do?
<
<Philip
<
<

.



Relevant Pages

  • RE: Exchange Notifications
    ... What is the "notification system" you use? ... please don't hesitate to let me know. ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • RE: dcdiag problems
    ... Where do you run the dcdiag command, on SBS server or addition DC? ... please don't hesitate to let me know. ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • RE: Domain User fails to registerdns
    ... The problem occurs if user has on permission visiting TCPIP, ... please don't hesitate to let me know. ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • RE: 0x80040115 prompt when connecting with outlook2003 to exchange2007 (windows 2003 server)
    ... please don't hesitate to let me know. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • Re: Is the SBS Enterprise Server ISA 2000 now up to the equivalent of SP4
    ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ... |> the recent information I've provided you, please don't hesitate to let ... | Actually, all the pieces finally arrived, so I took the server in to the ...
    (microsoft.public.windows.server.sbs)