Windows Vista Tips

Windows Vista Tips > Newsgroups > Windows Server > Windows Small Business Server > MS SQL 2005 Express Broke VSS/SBS Backup

Reply
Thread Tools Display Modes

MS SQL 2005 Express Broke VSS/SBS Backup

 
 
Mark Crall
Guest
Posts: n/a

 
      07-21-2006
Hi,
I've had this problem now on two servers. The first time I installed SQL
2005 express on a SBS it caused the MSDE writer for VSS to stop working. I
resolved it by installing SQL 2005 Express SP1. This time, I installed SQL
2005 Express SP1 and I'm getting the same thing. Has anybody else seen this
issue.

Summary:
Installed MS SQL Express 2005 SP1 (in mixed authentication mode) on SBS 2003
SP1 standard and now the SBS backup will not run due to the following error:

Volume shadow copy creation: Attempt 1.
"MSDEWriter" has reported an error 0x800423f4. This is part of System State.
The backup cannot continue.

Error returned while creating the volume shadow copy:800423f4
Aborting Backup.


Per several KBs I ran vssadmin list writers but there were no errors. I
also set the logon for the sql services to a domain\admin.

Any help would be much appreciated.

--
Regards,
Mark Crall
Systems Engineer
Charlotte Tech Care Team / Carolina VoIP
Microsoft Small Business Specialist
Charlotte SBS Group Leader - www.sbs-charlotte.com
Direct: (704) 248-8328 x33

If you think installing patches and security updates is expensive, try not
installing them...


 
Reply With Quote
 
 
 
 
thejamie
Guest
Posts: n/a

 
      07-21-2006
Ditto here Mark. I'm not certain, but you may be able to reset the log on as
service rights for the VSS.

The VSS may not be able to start because it belongs to a service that
doesn't have "log on as service rights" in your Default Domain Controllers
Policy.

Check the values in the "Log on as a service" rights in Default Domain
Controllers Policy -> Computer Configuration -> Windows Settings -> Security
Settings -> Local Policies -> User Rights Assignment. They have all been set
to a SQL Server 2005 login.

Bear in mind that the wizards for SBS rely heavily on SQL Server 2000
databases and if the log on is adjusted incorrectly, the service will not be
able to start when needed.
--
Regards,
Jamie


"Mark Crall" wrote:

> Hi,
> I've had this problem now on two servers. The first time I installed SQL
> 2005 express on a SBS it caused the MSDE writer for VSS to stop working. I
> resolved it by installing SQL 2005 Express SP1. This time, I installed SQL
> 2005 Express SP1 and I'm getting the same thing. Has anybody else seen this
> issue.
>
> Summary:
> Installed MS SQL Express 2005 SP1 (in mixed authentication mode) on SBS 2003
> SP1 standard and now the SBS backup will not run due to the following error:
>
> Volume shadow copy creation: Attempt 1.
> "MSDEWriter" has reported an error 0x800423f4. This is part of System State.
> The backup cannot continue.
>
> Error returned while creating the volume shadow copy:800423f4
> Aborting Backup.
>
>
> Per several KBs I ran vssadmin list writers but there were no errors. I
> also set the logon for the sql services to a domain\admin.
>
> Any help would be much appreciated.
>
> --
> Regards,
> Mark Crall
> Systems Engineer
> Charlotte Tech Care Team / Carolina VoIP
> Microsoft Small Business Specialist
> Charlotte SBS Group Leader - www.sbs-charlotte.com
> Direct: (704) 248-8328 x33
>
> If you think installing patches and security updates is expensive, try not
> installing them...
>
>
>

 
Reply With Quote
 
Mark Crall
Guest
Posts: n/a

 
      07-21-2006
Thanks Jamie,
The policies are still set as Not Defined.

--
Regards,
Mark Crall
Systems Engineer
Charlotte Tech Care Team / Carolina VoIP
Microsoft Small Business Specialist
Charlotte SBS Group Leader - www.sbs-charlotte.com
Direct: (704) 248-8328 x33

If you think installing patches and security updates is expensive, try not
installing them...
"thejamie" <> wrote in message
news:02E419EB-4D5B-48BA-B0B3-...
> Ditto here Mark. I'm not certain, but you may be able to reset the log on
> as
> service rights for the VSS.
>
> The VSS may not be able to start because it belongs to a service that
> doesn't have "log on as service rights" in your Default Domain Controllers
> Policy.
>
> Check the values in the "Log on as a service" rights in Default Domain
> Controllers Policy -> Computer Configuration -> Windows Settings ->
> Security
> Settings -> Local Policies -> User Rights Assignment. They have all been
> set
> to a SQL Server 2005 login.
>
> Bear in mind that the wizards for SBS rely heavily on SQL Server 2000
> databases and if the log on is adjusted incorrectly, the service will not
> be
> able to start when needed.
> --
> Regards,
> Jamie
>
>
> "Mark Crall" wrote:
>
>> Hi,
>> I've had this problem now on two servers. The first time I installed SQL
>> 2005 express on a SBS it caused the MSDE writer for VSS to stop working.
>> I
>> resolved it by installing SQL 2005 Express SP1. This time, I installed
>> SQL
>> 2005 Express SP1 and I'm getting the same thing. Has anybody else seen
>> this
>> issue.
>>
>> Summary:
>> Installed MS SQL Express 2005 SP1 (in mixed authentication mode) on SBS
>> 2003
>> SP1 standard and now the SBS backup will not run due to the following
>> error:
>>
>> Volume shadow copy creation: Attempt 1.
>> "MSDEWriter" has reported an error 0x800423f4. This is part of System
>> State.
>> The backup cannot continue.
>>
>> Error returned while creating the volume shadow copy:800423f4
>> Aborting Backup.
>>
>>
>> Per several KBs I ran vssadmin list writers but there were no errors. I
>> also set the logon for the sql services to a domain\admin.
>>
>> Any help would be much appreciated.
>>
>> --
>> Regards,
>> Mark Crall
>> Systems Engineer
>> Charlotte Tech Care Team / Carolina VoIP
>> Microsoft Small Business Specialist
>> Charlotte SBS Group Leader - www.sbs-charlotte.com
>> Direct: (704) 248-8328 x33
>>
>> If you think installing patches and security updates is expensive, try
>> not
>> installing them...
>>
>>
>>



 
Reply With Quote
 
Nancy
Guest
Posts: n/a

 
      07-21-2006
By any chance is that Level Platforms?? If so I got smacked with the same
exact heartache you're having here.

As soon as the OM install created the SQL 2005 DB my backups died. I can
backup if I use NT Backup from the system tools menu and deselect System
State from my selelctions list. So long as it is selected I have the same
grief you do.

Please let me know if you make any head way!!

"Mark Crall" wrote:

> Thanks Cris,
> We use a managed services software the requires SQL 2005 on our customers servers so we often install the express version. Not much of a choice... You are right it has broken several different things like SharePoint, monitoring, etc but we've always been able to fix the issues.
>
> Thanks for the input.
>
> --
> Regards,
> Mark Crall
> Systems Engineer
> Charlotte Tech Care Team / Carolina VoIP
> Microsoft Small Business Specialist
> Charlotte SBS Group Leader - www.sbs-charlotte.com
> Direct: (704) 248-8328 x33
>
> If you think installing patches and security updates is expensive, try not installing them...
> "Cris Hanna (SBS-MVP)" < t> wrote in message news:%23yW%...
> Hi Mark
> I'm no SQL expert, but based on a meeting many of the MVPs had recently with MS folks both on the support and product dev team
> I wouldn't be putting any version of SQL on the SBS server other than what is included as a part of the product because they have had to take specific steps to cooridnate the integration between SQL and the flavors of MSDE. SQL2005 Workgroup Ed is what will come with R2 as I'm sure you know. But SQL2000 has to come off.
>
> --
> Cris Hanna [SBS-MVP]
> --------------------------------------
> Please do not respond directly to me, but only post in the newsgroup so all can take advantage
> "Mark Crall" <> wrote in message news:...
> Hi,
> I've had this problem now on two servers. The first time I installed SQL
> 2005 express on a SBS it caused the MSDE writer for VSS to stop working. I
> resolved it by installing SQL 2005 Express SP1. This time, I installed SQL
> 2005 Express SP1 and I'm getting the same thing. Has anybody else seen this
> issue.
>
> Summary:
> Installed MS SQL Express 2005 SP1 (in mixed authentication mode) on SBS 2003
> SP1 standard and now the SBS backup will not run due to the following error:
>
> Volume shadow copy creation: Attempt 1.
> "MSDEWriter" has reported an error 0x800423f4. This is part of System State.
> The backup cannot continue.
>
> Error returned while creating the volume shadow copy:800423f4
> Aborting Backup.
>
>
> Per several KBs I ran vssadmin list writers but there were no errors. I
> also set the logon for the sql services to a domain\admin.
>
> Any help would be much appreciated.
>
> --
> Regards,
> Mark Crall
> Systems Engineer
> Charlotte Tech Care Team / Carolina VoIP
> Microsoft Small Business Specialist
> Charlotte SBS Group Leader - www.sbs-charlotte.com
> Direct: (704) 248-8328 x33
>
> If you think installing patches and security updates is expensive, try not
> installing them..

 
Reply With Quote
 
Chad A. Gross [SBS-MVP]
Guest
Posts: n/a

 
      07-23-2006
Hi Guys -

First - I wish I could comment on the SQL 2005 hosing up SBS issue - but I
pesonally haven't seen it. Granted, I only have about a half-dozen servers
that have been new installs of LPI's Onsite Manager since v5 was released -
but they are all running SQL 2005 Express without issue.

The good news is that LPI's Onsite Manager doesn't *require* SQL 2005
Express - that's just what comes bundled with it when you download the
install package. I've got about another 30+ sites all running Onsite
Manager 5.1 with either full SQL 2000 or MSDE as the data backend. When you
run the OM install, you have the option to use an existing SQL instance,
which could be SQL2k or 2005. On our SBS Premium networks, we always
install a default instance of SQL, and have OM use that versus MSDE / SQL
Express. For your standard networks - you can work around these issues by
installing a new instance of MSDE first - then having Onsite Manager use
that existing MSDE instance instead of installing SQL 2005 Express.

--

Chad A. Gross [SBS-MVP]
SBS ROCKS!
www.msmvps.com/blogs/cgross
www.mobitech.biz

"Mark Crall" <> wrote in message
news:...
It is Level Platforms OM install. We manage about 20 SBS servers and are
adding 1 a week. This is making it a real pain in the #$!

--
Regards,
Mark Crall
Systems Engineer
Charlotte Tech Care Team / Carolina VoIP
Microsoft Small Business Specialist
Charlotte SBS Group Leader - www.sbs-charlotte.com
Direct: (704) 248-8328 x33

If you think installing patches and security updates is expensive, try not
installing them...
"Cris Hanna (SBS-MVP)" < t>
wrote in message news:...
Actually if it is Level Platforms, one of the other MVP's, Chad Gross, has
done of lot of work with them...so if it is, I'll ask him to pop in here as
well.

--
Cris Hanna [SBS-MVP]
--------------------------------------
Please do not respond directly to me, but only post in the newsgroup so
all can take advantage
"Nancy" <> wrote in message
news:A7458A90-315B-4AD4-86A8-...
By any chance is that Level Platforms?? If so I got smacked with the
same
exact heartache you're having here.

As soon as the OM install created the SQL 2005 DB my backups died. I can
backup if I use NT Backup from the system tools menu and deselect System
State from my selelctions list. So long as it is selected I have the
same
grief you do.

Please let me know if you make any head way!!

"Mark Crall" wrote:

> Thanks Cris,
> We use a managed services software the requires SQL 2005 on our

customers servers so we often install the express version. Not much of a
choice... You are right it has broken several different things like
SharePoint, monitoring, etc but we've always been able to fix the issues.
>
> Thanks for the input.
>
> --
> Regards,
> Mark Crall
> Systems Engineer
> Charlotte Tech Care Team / Carolina VoIP
> Microsoft Small Business Specialist
> Charlotte SBS Group Leader - www.sbs-charlotte.com
> Direct: (704) 248-8328 x33
>
> If you think installing patches and security updates is expensive, try

not installing them...
> "Cris Hanna (SBS-MVP)"

< t> wrote in message
news:%23yW%...
> Hi Mark
> I'm no SQL expert, but based on a meeting many of the MVPs had

recently with MS folks both on the support and product dev team
> I wouldn't be putting any version of SQL on the SBS server other

than what is included as a part of the product because they have had to take
specific steps to cooridnate the integration between SQL and the flavors of
MSDE. SQL2005 Workgroup Ed is what will come with R2 as I'm sure you know.
But SQL2000 has to come off.
>
> --
> Cris Hanna [SBS-MVP]
> --------------------------------------
> Please do not respond directly to me, but only post in the newsgroup

so all can take advantage
> "Mark Crall" <> wrote in message

news:...
> Hi,
> I've had this problem now on two servers. The first time I

installed SQL
> 2005 express on a SBS it caused the MSDE writer for VSS to stop

working. I
> resolved it by installing SQL 2005 Express SP1. This time, I

installed SQL
> 2005 Express SP1 and I'm getting the same thing. Has anybody else

seen this
> issue.
>
> Summary:
> Installed MS SQL Express 2005 SP1 (in mixed authentication mode)

on SBS 2003
> SP1 standard and now the SBS backup will not run due to the

following error:
>
> Volume shadow copy creation: Attempt 1.
> "MSDEWriter" has reported an error 0x800423f4. This is part of

System State.
> The backup cannot continue.
>
> Error returned while creating the volume shadow copy:800423f4
> Aborting Backup.
>
>
> Per several KBs I ran vssadmin list writers but there were no

errors. I
> also set the logon for the sql services to a domain\admin.
>
> Any help would be much appreciated.
>
> --
> Regards,
> Mark Crall
> Systems Engineer
> Charlotte Tech Care Team / Carolina VoIP
> Microsoft Small Business Specialist
> Charlotte SBS Group Leader - www.sbs-charlotte.com
> Direct: (704) 248-8328 x33
>
> If you think installing patches and security updates is expensive,

try not
> installing them..



 
Reply With Quote
 
Nancy
Guest
Posts: n/a

 
      07-24-2006
The problem is that it wouldn't take my MSDE 2000 installation which already
existed. We do not have full SQL server installed on this SBS Server. So when
I ran the install of LPI I got a slew of errors with the existing DB Desktop
Engine. So I did the only thing that I could seem to do to go forward with
the install.

At this point I would uninstall the OM and the SQL 2005 and start over with
LPI support but I'm afraid this will not fix the issue. I'm game to trying
anything. This client is the only 5.1 OM I have. My Service Center is 5.04
and we'll be updating it this week. So OM isn't even reporting to our
dashboard yet therefore I'm not opposed to starting over.

"Chad A. Gross [SBS-MVP]" wrote:

> Hi Guys -
>
> First - I wish I could comment on the SQL 2005 hosing up SBS issue - but I
> pesonally haven't seen it. Granted, I only have about a half-dozen servers
> that have been new installs of LPI's Onsite Manager since v5 was released -
> but they are all running SQL 2005 Express without issue.
>
> The good news is that LPI's Onsite Manager doesn't *require* SQL 2005
> Express - that's just what comes bundled with it when you download the
> install package. I've got about another 30+ sites all running Onsite
> Manager 5.1 with either full SQL 2000 or MSDE as the data backend. When you
> run the OM install, you have the option to use an existing SQL instance,
> which could be SQL2k or 2005. On our SBS Premium networks, we always
> install a default instance of SQL, and have OM use that versus MSDE / SQL
> Express. For your standard networks - you can work around these issues by
> installing a new instance of MSDE first - then having Onsite Manager use
> that existing MSDE instance instead of installing SQL 2005 Express.
>
> --
>
> Chad A. Gross [SBS-MVP]
> SBS ROCKS!
> www.msmvps.com/blogs/cgross
> www.mobitech.biz
>
> "Mark Crall" <> wrote in message
> news:...
> It is Level Platforms OM install. We manage about 20 SBS servers and are
> adding 1 a week. This is making it a real pain in the #$!
>
> --
> Regards,
> Mark Crall
> Systems Engineer
> Charlotte Tech Care Team / Carolina VoIP
> Microsoft Small Business Specialist
> Charlotte SBS Group Leader - www.sbs-charlotte.com
> Direct: (704) 248-8328 x33
>
> If you think installing patches and security updates is expensive, try not
> installing them...
> "Cris Hanna (SBS-MVP)" < t>
> wrote in message news:...
> Actually if it is Level Platforms, one of the other MVP's, Chad Gross, has
> done of lot of work with them...so if it is, I'll ask him to pop in here as
> well.
>
> --
> Cris Hanna [SBS-MVP]
> --------------------------------------
> Please do not respond directly to me, but only post in the newsgroup so
> all can take advantage
> "Nancy" <> wrote in message
> news:A7458A90-315B-4AD4-86A8-...
> By any chance is that Level Platforms?? If so I got smacked with the
> same
> exact heartache you're having here.
>
> As soon as the OM install created the SQL 2005 DB my backups died. I can
> backup if I use NT Backup from the system tools menu and deselect System
> State from my selelctions list. So long as it is selected I have the
> same
> grief you do.
>
> Please let me know if you make any head way!!
>
> "Mark Crall" wrote:
>
> > Thanks Cris,
> > We use a managed services software the requires SQL 2005 on our

> customers servers so we often install the express version. Not much of a
> choice... You are right it has broken several different things like
> SharePoint, monitoring, etc but we've always been able to fix the issues.
> >
> > Thanks for the input.
> >
> > --
> > Regards,
> > Mark Crall
> > Systems Engineer
> > Charlotte Tech Care Team / Carolina VoIP
> > Microsoft Small Business Specialist
> > Charlotte SBS Group Leader - www.sbs-charlotte.com
> > Direct: (704) 248-8328 x33
> >
> > If you think installing patches and security updates is expensive, try

> not installing them...
> > "Cris Hanna (SBS-MVP)"

> < t> wrote in message
> news:%23yW%...
> > Hi Mark
> > I'm no SQL expert, but based on a meeting many of the MVPs had

> recently with MS folks both on the support and product dev team
> > I wouldn't be putting any version of SQL on the SBS server other

> than what is included as a part of the product because they have had to take
> specific steps to cooridnate the integration between SQL and the flavors of
> MSDE. SQL2005 Workgroup Ed is what will come with R2 as I'm sure you know.
> But SQL2000 has to come off.
> >
> > --
> > Cris Hanna [SBS-MVP]
> > --------------------------------------
> > Please do not respond directly to me, but only post in the newsgroup

> so all can take advantage
> > "Mark Crall" <> wrote in message

> news:...
> > Hi,
> > I've had this problem now on two servers. The first time I

> installed SQL
> > 2005 express on a SBS it caused the MSDE writer for VSS to stop

> working. I
> > resolved it by installing SQL 2005 Express SP1. This time, I

> installed SQL
> > 2005 Express SP1 and I'm getting the same thing. Has anybody else

> seen this
> > issue.
> >
> > Summary:
> > Installed MS SQL Express 2005 SP1 (in mixed authentication mode)

> on SBS 2003
> > SP1 standard and now the SBS backup will not run due to the

> following error:
> >
> > Volume shadow copy creation: Attempt 1.
> > "MSDEWriter" has reported an error 0x800423f4. This is part of

> System State.
> > The backup cannot continue.
> >
> > Error returned while creating the volume shadow copy:800423f4
> > Aborting Backup.
> >
> >
> > Per several KBs I ran vssadmin list writers but there were no

> errors. I
> > also set the logon for the sql services to a domain\admin.
> >
> > Any help would be much appreciated.
> >
> > --
> > Regards,
> > Mark Crall
> > Systems Engineer
> > Charlotte Tech Care Team / Carolina VoIP
> > Microsoft Small Business Specialist
> > Charlotte SBS Group Leader - www.sbs-charlotte.com
> > Direct: (704) 248-8328 x33
> >
> > If you think installing patches and security updates is expensive,

> try not
> > installing them..

>
>
>

 
Reply With Quote
 
Chad A. Gross [SBS-MVP]
Guest
Posts: n/a

 
      07-24-2006
Hi Nancy -

Considering that we're now officially moving OT - let's take this offline.
Email me directly - cgross <at> mobitech <dot> biz I'm pretty sure that
upgrading your Service Center to 5.1 will resolve a lot of issues.
Historically speaking, LPI always works better when your OMs are not running
a newer version than your SC . . .

--

Chad A. Gross [SBS-MVP]
SBS ROCKS!
www.msmvps.com/blogs/cgross
www.mobitech.biz

"Nancy" <> wrote in message
news6A19945-02F7-47A0-9D73-...
> The problem is that it wouldn't take my MSDE 2000 installation which
> already
> existed. We do not have full SQL server installed on this SBS Server. So
> when
> I ran the install of LPI I got a slew of errors with the existing DB
> Desktop
> Engine. So I did the only thing that I could seem to do to go forward with
> the install.
>
> At this point I would uninstall the OM and the SQL 2005 and start over
> with
> LPI support but I'm afraid this will not fix the issue. I'm game to trying
> anything. This client is the only 5.1 OM I have. My Service Center is 5.04
> and we'll be updating it this week. So OM isn't even reporting to our
> dashboard yet therefore I'm not opposed to starting over.
>
> "Chad A. Gross [SBS-MVP]" wrote:
>
>> Hi Guys -
>>
>> First - I wish I could comment on the SQL 2005 hosing up SBS issue - but
>> I
>> pesonally haven't seen it. Granted, I only have about a half-dozen
>> servers
>> that have been new installs of LPI's Onsite Manager since v5 was
>> released -
>> but they are all running SQL 2005 Express without issue.
>>
>> The good news is that LPI's Onsite Manager doesn't *require* SQL 2005
>> Express - that's just what comes bundled with it when you download the
>> install package. I've got about another 30+ sites all running Onsite
>> Manager 5.1 with either full SQL 2000 or MSDE as the data backend. When
>> you
>> run the OM install, you have the option to use an existing SQL instance,
>> which could be SQL2k or 2005. On our SBS Premium networks, we always
>> install a default instance of SQL, and have OM use that versus MSDE / SQL
>> Express. For your standard networks - you can work around these issues
>> by
>> installing a new instance of MSDE first - then having Onsite Manager use
>> that existing MSDE instance instead of installing SQL 2005 Express.
>>
>> --
>>
>> Chad A. Gross [SBS-MVP]
>> SBS ROCKS!
>> www.msmvps.com/blogs/cgross
>> www.mobitech.biz
>>
>> "Mark Crall" <> wrote in message
>> news:...
>> It is Level Platforms OM install. We manage about 20 SBS servers and are
>> adding 1 a week. This is making it a real pain in the #$!
>>
>> --
>> Regards,
>> Mark Crall
>> Systems Engineer
>> Charlotte Tech Care Team / Carolina VoIP
>> Microsoft Small Business Specialist
>> Charlotte SBS Group Leader - www.sbs-charlotte.com
>> Direct: (704) 248-8328 x33
>>
>> If you think installing patches and security updates is expensive, try
>> not
>> installing them...
>> "Cris Hanna (SBS-MVP)"
>> < t>
>> wrote in message news:...
>> Actually if it is Level Platforms, one of the other MVP's, Chad Gross,
>> has
>> done of lot of work with them...so if it is, I'll ask him to pop in here
>> as
>> well.
>>
>> --
>> Cris Hanna [SBS-MVP]
>> --------------------------------------
>> Please do not respond directly to me, but only post in the newsgroup so
>> all can take advantage
>> "Nancy" <> wrote in message
>> news:A7458A90-315B-4AD4-86A8-...
>> By any chance is that Level Platforms?? If so I got smacked with the
>> same
>> exact heartache you're having here.
>>
>> As soon as the OM install created the SQL 2005 DB my backups died. I
>> can
>> backup if I use NT Backup from the system tools menu and deselect
>> System
>> State from my selelctions list. So long as it is selected I have the
>> same
>> grief you do.
>>
>> Please let me know if you make any head way!!
>>
>> "Mark Crall" wrote:
>>
>> > Thanks Cris,
>> > We use a managed services software the requires SQL 2005 on our

>> customers servers so we often install the express version. Not much of a
>> choice... You are right it has broken several different things like
>> SharePoint, monitoring, etc but we've always been able to fix the issues.
>> >
>> > Thanks for the input.
>> >
>> > --
>> > Regards,
>> > Mark Crall
>> > Systems Engineer
>> > Charlotte Tech Care Team / Carolina VoIP
>> > Microsoft Small Business Specialist
>> > Charlotte SBS Group Leader - www.sbs-charlotte.com
>> > Direct: (704) 248-8328 x33
>> >
>> > If you think installing patches and security updates is expensive,

>> try
>> not installing them...
>> > "Cris Hanna (SBS-MVP)"

>> < t> wrote in message
>> news:%23yW%...
>> > Hi Mark
>> > I'm no SQL expert, but based on a meeting many of the MVPs had

>> recently with MS folks both on the support and product dev team
>> > I wouldn't be putting any version of SQL on the SBS server other

>> than what is included as a part of the product because they have had to
>> take
>> specific steps to cooridnate the integration between SQL and the flavors
>> of
>> MSDE. SQL2005 Workgroup Ed is what will come with R2 as I'm sure you
>> know.
>> But SQL2000 has to come off.
>> >
>> > --
>> > Cris Hanna [SBS-MVP]
>> > --------------------------------------
>> > Please do not respond directly to me, but only post in the

>> newsgroup
>> so all can take advantage
>> > "Mark Crall" <> wrote in message

>> news:...
>> > Hi,
>> > I've had this problem now on two servers. The first time I

>> installed SQL
>> > 2005 express on a SBS it caused the MSDE writer for VSS to stop

>> working. I
>> > resolved it by installing SQL 2005 Express SP1. This time, I

>> installed SQL
>> > 2005 Express SP1 and I'm getting the same thing. Has anybody

>> else
>> seen this
>> > issue.
>> >
>> > Summary:
>> > Installed MS SQL Express 2005 SP1 (in mixed authentication

>> mode)
>> on SBS 2003
>> > SP1 standard and now the SBS backup will not run due to the

>> following error:
>> >
>> > Volume shadow copy creation: Attempt 1.
>> > "MSDEWriter" has reported an error 0x800423f4. This is part of

>> System State.
>> > The backup cannot continue.
>> >
>> > Error returned while creating the volume shadow copy:800423f4
>> > Aborting Backup.
>> >
>> >
>> > Per several KBs I ran vssadmin list writers but there were no

>> errors. I
>> > also set the logon for the sql services to a domain\admin.
>> >
>> > Any help would be much appreciated.
>> >
>> > --
>> > Regards,
>> > Mark Crall
>> > Systems Engineer
>> > Charlotte Tech Care Team / Carolina VoIP
>> > Microsoft Small Business Specialist
>> > Charlotte SBS Group Leader - www.sbs-charlotte.com
>> > Direct: (704) 248-8328 x33
>> >
>> > If you think installing patches and security updates is

>> expensive,
>> try not
>> > installing them..

>>
>>
>>



 
Reply With Quote
 
Mark Crall
Guest
Posts: n/a

 
      07-26-2006
Hi Chad and Nancy,
Nancy has expressed exactly the same dilemma we are having. The SBS boxes
we are putting OM on are STD. It won't install so we have to put on SQL
2005 but as I said, it breaks things. Please cc me on thread if you don't
mind.

--
Regards,
Mark Crall
Systems Engineer
Charlotte Tech Care Team / Carolina VoIP
Microsoft Small Business Specialist
Charlotte SBS Group Leader - www.sbs-charlotte.com
Direct: (704) 248-8328 x33

If you think installing patches and security updates is expensive, try not
installing them...
"Chad A. Gross [SBS-MVP]" <> wrote in
message news:...
> Hi Nancy -
>
> Considering that we're now officially moving OT - let's take this offline.
> Email me directly - cgross <at> mobitech <dot> biz I'm pretty sure
> that upgrading your Service Center to 5.1 will resolve a lot of issues.
> Historically speaking, LPI always works better when your OMs are not
> running a newer version than your SC . . .
>
> --
>
> Chad A. Gross [SBS-MVP]
> SBS ROCKS!
> www.msmvps.com/blogs/cgross
> www.mobitech.biz
>
> "Nancy" <> wrote in message
> news6A19945-02F7-47A0-9D73-...
>> The problem is that it wouldn't take my MSDE 2000 installation which
>> already
>> existed. We do not have full SQL server installed on this SBS Server. So
>> when
>> I ran the install of LPI I got a slew of errors with the existing DB
>> Desktop
>> Engine. So I did the only thing that I could seem to do to go forward
>> with
>> the install.
>>
>> At this point I would uninstall the OM and the SQL 2005 and start over
>> with
>> LPI support but I'm afraid this will not fix the issue. I'm game to
>> trying
>> anything. This client is the only 5.1 OM I have. My Service Center is
>> 5.04
>> and we'll be updating it this week. So OM isn't even reporting to our
>> dashboard yet therefore I'm not opposed to starting over.
>>
>> "Chad A. Gross [SBS-MVP]" wrote:
>>
>>> Hi Guys -
>>>
>>> First - I wish I could comment on the SQL 2005 hosing up SBS issue - but
>>> I
>>> pesonally haven't seen it. Granted, I only have about a half-dozen
>>> servers
>>> that have been new installs of LPI's Onsite Manager since v5 was
>>> released -
>>> but they are all running SQL 2005 Express without issue.
>>>
>>> The good news is that LPI's Onsite Manager doesn't *require* SQL 2005
>>> Express - that's just what comes bundled with it when you download the
>>> install package. I've got about another 30+ sites all running Onsite
>>> Manager 5.1 with either full SQL 2000 or MSDE as the data backend. When
>>> you
>>> run the OM install, you have the option to use an existing SQL instance,
>>> which could be SQL2k or 2005. On our SBS Premium networks, we always
>>> install a default instance of SQL, and have OM use that versus MSDE /
>>> SQL
>>> Express. For your standard networks - you can work around these issues
>>> by
>>> installing a new instance of MSDE first - then having Onsite Manager use
>>> that existing MSDE instance instead of installing SQL 2005 Express.
>>>
>>> --
>>>
>>> Chad A. Gross [SBS-MVP]
>>> SBS ROCKS!
>>> www.msmvps.com/blogs/cgross
>>> www.mobitech.biz
>>>
>>> "Mark Crall" <> wrote in message
>>> news:...
>>> It is Level Platforms OM install. We manage about 20 SBS servers and
>>> are
>>> adding 1 a week. This is making it a real pain in the #$!
>>>
>>> --
>>> Regards,
>>> Mark Crall
>>> Systems Engineer
>>> Charlotte Tech Care Team / Carolina VoIP
>>> Microsoft Small Business Specialist
>>> Charlotte SBS Group Leader - www.sbs-charlotte.com
>>> Direct: (704) 248-8328 x33
>>>
>>> If you think installing patches and security updates is expensive, try
>>> not
>>> installing them...
>>> "Cris Hanna (SBS-MVP)"
>>> < t>
>>> wrote in message news:...
>>> Actually if it is Level Platforms, one of the other MVP's, Chad Gross,
>>> has
>>> done of lot of work with them...so if it is, I'll ask him to pop in here
>>> as
>>> well.
>>>
>>> --
>>> Cris Hanna [SBS-MVP]
>>> --------------------------------------
>>> Please do not respond directly to me, but only post in the newsgroup
>>> so
>>> all can take advantage
>>> "Nancy" <> wrote in message
>>> news:A7458A90-315B-4AD4-86A8-...
>>> By any chance is that Level Platforms?? If so I got smacked with the
>>> same
>>> exact heartache you're having here.
>>>
>>> As soon as the OM install created the SQL 2005 DB my backups died. I
>>> can
>>> backup if I use NT Backup from the system tools menu and deselect
>>> System
>>> State from my selelctions list. So long as it is selected I have the
>>> same
>>> grief you do.
>>>
>>> Please let me know if you make any head way!!
>>>
>>> "Mark Crall" wrote:
>>>
>>> > Thanks Cris,
>>> > We use a managed services software the requires SQL 2005 on our
>>> customers servers so we often install the express version. Not much of
>>> a
>>> choice... You are right it has broken several different things like
>>> SharePoint, monitoring, etc but we've always been able to fix the
>>> issues.
>>> >
>>> > Thanks for the input.
>>> >
>>> > --
>>> > Regards,
>>> > Mark Crall
>>> > Systems Engineer
>>> > Charlotte Tech Care Team / Carolina VoIP
>>> > Microsoft Small Business Specialist
>>> > Charlotte SBS Group Leader - www.sbs-charlotte.com
>>> > Direct: (704) 248-8328 x33
>>> >
>>> > If you think installing patches and security updates is expensive,
>>> try
>>> not installing them...
>>> > "Cris Hanna (SBS-MVP)"
>>> < t> wrote in message
>>> news:%23yW%...
>>> > Hi Mark
>>> > I'm no SQL expert, but based on a meeting many of the MVPs had
>>> recently with MS folks both on the support and product dev team
>>> > I wouldn't be putting any version of SQL on the SBS server other
>>> than what is included as a part of the product because they have had to
>>> take
>>> specific steps to cooridnate the integration between SQL and the flavors
>>> of
>>> MSDE. SQL2005 Workgroup Ed is what will come with R2 as I'm sure you
>>> know.
>>> But SQL2000 has to come off.
>>> >
>>> > --
>>> > Cris Hanna [SBS-MVP]
>>> > --------------------------------------
>>> > Please do not respond directly to me, but only post in the
>>> newsgroup
>>> so all can take advantage
>>> > "Mark Crall" <> wrote in message
>>> news:...
>>> > Hi,
>>> > I've had this problem now on two servers. The first time I
>>> installed SQL
>>> > 2005 express on a SBS it caused the MSDE writer for VSS to
>>> stop
>>> working. I
>>> > resolved it by installing SQL 2005 Express SP1. This time, I
>>> installed SQL
>>> > 2005 Express SP1 and I'm getting the same thing. Has anybody
>>> else
>>> seen this
>>> > issue.
>>> >
>>> > Summary:
>>> > Installed MS SQL Express 2005 SP1 (in mixed authentication
>>> mode)
>>> on SBS 2003
>>> > SP1 standard and now the SBS backup will not run due to the
>>> following error:
>>> >
>>> > Volume shadow copy creation: Attempt 1.
>>> > "MSDEWriter" has reported an error 0x800423f4. This is part of
>>> System State.
>>> > The backup cannot continue.
>>> >
>>> > Error returned while creating the volume shadow copy:800423f4
>>> > Aborting Backup.
>>> >
>>> >
>>> > Per several KBs I ran vssadmin list writers but there were no
>>> errors. I
>>> > also set the logon for the sql services to a domain\admin.
>>> >
>>> > Any help would be much appreciated.
>>> >
>>> > --
>>> > Regards,
>>> > Mark Crall
>>> > Systems Engineer
>>> > Charlotte Tech Care Team / Carolina VoIP
>>> > Microsoft Small Business Specialist
>>> > Charlotte SBS Group Leader - www.sbs-charlotte.com
>>> > Direct: (704) 248-8328 x33
>>> >
>>> > If you think installing patches and security updates is
>>> expensive,
>>> try not
>>> > installing them..
>>>
>>>
>>>

>
>



 
Reply With Quote
 
Nancy
Guest
Posts: n/a

 
      07-26-2006
Mine are also set to Not Defined.
I am also running 5.1.1 OM and 5.1.1 Service Center to respond to a previous
response.


"Mark Crall" wrote:

> Thanks Jamie,
> The policies are still set as Not Defined.
>
> --
> Regards,
> Mark Crall
> Systems Engineer
> Charlotte Tech Care Team / Carolina VoIP
> Microsoft Small Business Specialist
> Charlotte SBS Group Leader - www.sbs-charlotte.com
> Direct: (704) 248-8328 x33
>
> If you think installing patches and security updates is expensive, try not
> installing them...
> "thejamie" <> wrote in message
> news:02E419EB-4D5B-48BA-B0B3-...
> > Ditto here Mark. I'm not certain, but you may be able to reset the log on
> > as
> > service rights for the VSS.
> >
> > The VSS may not be able to start because it belongs to a service that
> > doesn't have "log on as service rights" in your Default Domain Controllers
> > Policy.
> >
> > Check the values in the "Log on as a service" rights in Default Domain
> > Controllers Policy -> Computer Configuration -> Windows Settings ->
> > Security
> > Settings -> Local Policies -> User Rights Assignment. They have all been
> > set
> > to a SQL Server 2005 login.
> >
> > Bear in mind that the wizards for SBS rely heavily on SQL Server 2000
> > databases and if the log on is adjusted incorrectly, the service will not
> > be
> > able to start when needed.
> > --
> > Regards,
> > Jamie
> >
> >
> > "Mark Crall" wrote:
> >
> >> Hi,
> >> I've had this problem now on two servers. The first time I installed SQL
> >> 2005 express on a SBS it caused the MSDE writer for VSS to stop working.
> >> I
> >> resolved it by installing SQL 2005 Express SP1. This time, I installed
> >> SQL
> >> 2005 Express SP1 and I'm getting the same thing. Has anybody else seen
> >> this
> >> issue.
> >>
> >> Summary:
> >> Installed MS SQL Express 2005 SP1 (in mixed authentication mode) on SBS
> >> 2003
> >> SP1 standard and now the SBS backup will not run due to the following
> >> error:
> >>
> >> Volume shadow copy creation: Attempt 1.
> >> "MSDEWriter" has reported an error 0x800423f4. This is part of System
> >> State.
> >> The backup cannot continue.
> >>
> >> Error returned while creating the volume shadow copy:800423f4
> >> Aborting Backup.
> >>
> >>
> >> Per several KBs I ran vssadmin list writers but there were no errors. I
> >> also set the logon for the sql services to a domain\admin.
> >>
> >> Any help would be much appreciated.
> >>
> >> --
> >> Regards,
> >> Mark Crall
> >> Systems Engineer
> >> Charlotte Tech Care Team / Carolina VoIP
> >> Microsoft Small Business Specialist
> >> Charlotte SBS Group Leader - www.sbs-charlotte.com
> >> Direct: (704) 248-8328 x33
> >>
> >> If you think installing patches and security updates is expensive, try
> >> not
> >> installing them...
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
Nancy
Guest
Posts: n/a

 
      07-26-2006
HOLY SMOKES I GOT IT:

http://support.microsoft.com/Default.aspx?kbid=912414

For me the following process had the .\username format:

SQL Server VSS Writer

I changed that, restarted ALL sql related services and then ran a backup
from the Server Manager. It hung for a while at "preparing to backup from
shadow copy services" but then suddenly it started to copy data over. I think
it's the fund raiser dollar candy bar I bought while taking a walk to clear
my head. That dollar donation changed my luck. That or my brain works better
on chocolate

I sure hope that works for you. Let me know if it does so I can submit the
fix to Level Platforms as I've been less than nice to them the past two days
over this!!!

Nancy

"Mark Crall" wrote:

> Thanks Jamie,
> The policies are still set as Not Defined.
>
> --
> Regards,
> Mark Crall
> Systems Engineer
> Charlotte Tech Care Team / Carolina VoIP
> Microsoft Small Business Specialist
> Charlotte SBS Group Leader - www.sbs-charlotte.com
> Direct: (704) 248-8328 x33
>
> If you think installing patches and security updates is expensive, try not
> installing them...
> "thejamie" <> wrote in message
> news:02E419EB-4D5B-48BA-B0B3-...
> > Ditto here Mark. I'm not certain, but you may be able to reset the log on
> > as
> > service rights for the VSS.
> >
> > The VSS may not be able to start because it belongs to a service that
> > doesn't have "log on as service rights" in your Default Domain Controllers
> > Policy.
> >
> > Check the values in the "Log on as a service" rights in Default Domain
> > Controllers Policy -> Computer Configuration -> Windows Settings ->
> > Security
> > Settings -> Local Policies -> User Rights Assignment. They have all been
> > set
> > to a SQL Server 2005 login.
> >
> > Bear in mind that the wizards for SBS rely heavily on SQL Server 2000
> > databases and if the log on is adjusted incorrectly, the service will not
> > be
> > able to start when needed.
> > --
> > Regards,
> > Jamie
> >
> >
> > "Mark Crall" wrote:
> >
> >> Hi,
> >> I've had this problem now on two servers. The first time I installed SQL
> >> 2005 express on a SBS it caused the MSDE writer for VSS to stop working.
> >> I
> >> resolved it by installing SQL 2005 Express SP1. This time, I installed
> >> SQL
> >> 2005 Express SP1 and I'm getting the same thing. Has anybody else seen
> >> this
> >> issue.
> >>
> >> Summary:
> >> Installed MS SQL Express 2005 SP1 (in mixed authentication mode) on SBS
> >> 2003
> >> SP1 standard and now the SBS backup will not run due to the following
> >> error:
> >>
> >> Volume shadow copy creation: Attempt 1.
> >> "MSDEWriter" has reported an error 0x800423f4. This is part of System
> >> State.
> >> The backup cannot continue.
> >>
> >> Error returned while creating the volume shadow copy:800423f4
> >> Aborting Backup.
> >>
> >>
> >> Per several KBs I ran vssadmin list writers but there were no errors. I
> >> also set the logon for the sql services to a domain\admin.
> >>
> >> Any help would be much appreciated.
> >>
> >> --
> >> Regards,
> >> Mark Crall
> >> Systems Engineer
> >> Charlotte Tech Care Team / Carolina VoIP
> >> Microsoft Small Business Specialist
> >> Charlotte SBS Group Leader - www.sbs-charlotte.com
> >> Direct: (704) 248-8328 x33
> >>
> >> If you think installing patches and security updates is expensive, try
> >> not
> >> installing them...
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
SBS Backup - Inconsistency Ariel Morg Windows Small Business Server 21 12-02-2005 11:03 AM
SBS Backup problems Tonton Windows Small Business Server 15 12-01-2005 08:07 AM
Re: Drive Size and Backup Les Connor [SBS Community Member - SBS MVP] Windows Small Business Server 1 11-29-2005 06:19 PM
SBS2003 Exchange Backup Problems (& musings) Macker Windows Small Business Server 9 04-19-2005 01:36 AM
backup error steven Windows Small Business Server 7 01-03-2005 02:40 AM



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59