MSDE 2000: Authentication failed despite BLANKSAPWD

Hi!
We're having troubles on a Windows 2003 Server. MSDE 1.0 does not
install (even though we already have this setup at other customers).
So I downloaded MSDE 2000. Unfortunately, somebody else just executed the
installation procedure without setup-parameters. I wanted to have an empty
password (I know, I know. But it is a closed system) and I need SQL
security mode and network protocols.
Thus I uninstalled MSDE 2000 again and launched setup.exe this way:
setup DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL BLANKSAPWD=1
The installation went fine and I did *no* receive the error about the
trusted connections. However, I received "Authentication for user sa
failed" when simply doing this
osql -Usa -P -dmaster
Any clues?
Stefan
On Thu, 28 Oct 2004 10:31:15 +0200, Stefan M. Huber <looseleaf@.gmx.net>
wrote:

> The installation went fine and I did *no* receive the error about the
> trusted connections. However, I received "Authentication for user sa
> failed" when simply doing this
> osql -Usa -P -dmaster
> Any clues?
The only thing that I can tell you is that the MSDE instance accepts the
administrator password as sa password...So the problem is solved but not
the circumstances that produced this setup.
Stefan

msde 2000 sp4 - configuration failed

There is a bugfix in sp4 that I need for a customer machine. I have
been unsuccesful in getting service pack 4 installed on a test machine.
configuration:
windows 2000, msde 2000 sp2
setup command line:
setup /upgradesp sqlrun SECURITYMODE=SQL
UPGRADEUSER=myadminacct UPGRADEPWD=mypassword /L*v
C:\MSDELog.log
The setup runs for a couple minutes, then dialog progress bar winds
down. I have a 3.7 MB log, at the end I have:
=== Logging stopped: 7/7/2005 15:30:34 ===
MSI (c) (44:BC): Note: 1: 1729
MSI (c) (44:BC): Product: Microsoft SQL Server Desktop Engine --
Configuration failed.
MSI (c) (44:BC): Grabbed execution mutex.
MSI (c) (44:BC): Cleaning up uninstalled install packages, if
any exist
MSI (c) (44:BC): MainEngineThread is returning 1603
=== Verbose logging stopped: 7/7/2005 15:30:34 ===
After this happens, sqlserver agent will no longer start. I re-imaged
the machine and ran it again with the same result.
Anyone else have similar problems installing sp4? Anyone have a
solution?
Thanks!
hi,
slide@.backpacker.com wrote:
> === Logging stopped: 7/7/2005 15:30:34 ===
> MSI (c) (44:BC): Note: 1: 1729
> MSI (c) (44:BC): Product: Microsoft SQL Server Desktop Engine --
> Configuration failed.
> MSI (c) (44:BC): Grabbed execution mutex.
> MSI (c) (44:BC): Cleaning up uninstalled install packages, if
> any exist
> MSI (c) (44:BC): MainEngineThread is returning 1603
> === Verbose logging stopped: 7/7/2005 15:30:34 ===
please search for
RETURN VALUE 3
entries... about 10/15 lines before each entry you should find some
(sometime cryptic) description...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea, thanks for the response! I found a 3:
<first>
Starting custom action SetFileAndRegACLs()
Beginning modification of directory Security Descriptor (SD).
SQL Path: C:\Program Files\Microsoft SQL Server\MSSQL\\
SQL Data Path: C:\Program Files\Microsoft SQL Server\MSSQL\\
SQL Service Account: .\dbservice
Agent Service Account: .\dbservice
Error:
No mapping between account names and security IDs was done.
Error Code = 1332
Ending modification of directory Security Descriptor (SD).
Ending custom action SetFileAndRegACLs().
Action ended 15:30:03: InstallFinalize. Return value 3.
</first>
<second>
Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (14:20): Executing op: End(Checksum=0,ProgressTotal=0)
MSI (s) (14:20): Error in rollback skipped. Return: 5
MSI (s) (14:20): FEATURECACHE: Entering Invalidate
MSI (s) (14:20): Unlocking Server
Action ended 15:30:33: INSTALL. Return value 3.
</second>
This last one was right after a property dump after the second one:
<third>
MSI (s) (14:20): MainEngineThread is returning 1603
MSI (c) (44:BC): Back from server. Return value: 1603
MSI (c) (44:BC): Decrementing counter to disable shutdown. If counter
>= 0, shutdown will be denied. Counter after decrement: -1
Action ended 15:30:34: INSTALL. Return value 3.
</third>
Any ideas?
-Chris
Andrea Montanari wrote:
> hi,
> slide@.backpacker.com wrote:
> please search for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry you should find some
> (sometime cryptic) description...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
|||hi,
slide@.backpacker.com wrote:
> Andrea, thanks for the response! I found a 3:
> <first>
> Starting custom action SetFileAndRegACLs()
> Beginning modification of directory Security Descriptor (SD).
> SQL Path: C:\Program Files\Microsoft SQL Server\MSSQL\\
> SQL Data Path: C:\Program Files\Microsoft SQL Server\MSSQL\\
> SQL Service Account: .\dbservice
> Agent Service Account: .\dbservice
> Error:
> No mapping between account names and security IDs was done.
> Error Code = 1332
> Ending modification of directory Security Descriptor (SD).
> Ending custom action SetFileAndRegACLs().
> Action ended 15:30:03: InstallFinalize. Return value 3.
> </first>
unfortunately I only found information like http://tinyurl.com/cs39o , and
really do not know if can help... the answers are not very consistent, but
at the very end of the thread there's a note... perhaps...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||> unfortunately I only found information like http://tinyurl.com/cs39o , and
> really do not know if can help... the answers are not very consistent, but
> at the very end of the thread there's a note... perhaps...
Thanks for the "value 3" tip. This was some problem with the account
that sqlserveragent and mssqlserver were running under. Changed to
LocalSystem and installation succeeded.

MSDE 2000 SP3 fails to install

MSDE 2000 SP3 fails to install on a windows 2000 terminal server. The error
message I get is "MSDE 200 SP3 installation failed with exit code 1603" and
“A strong password is required for security reasons. Please use SAPWD switch
to supply the same. Refer to read me for more details. Setup will now exit.”
I have come across this once before and removed the server from the domain,
in this case that is not an option. I have denied the read right to the
default domain policy which is the only policy that is applying. Anybody have
any ideas on how I can install this.
hi bob,
bob wrote:
> MSDE 2000 SP3 fails to install on a windows 2000 terminal server. The
> error message I get is "MSDE 200 SP3 installation failed with exit
> code 1603" and "A strong password is required for security reasons.
> Please use SAPWD switch to supply the same. Refer to read me for more
> details. Setup will now exit." I have come across this once before
> and removed the server from the domain, in this case that is not an
> option. I have denied the read right to the default domain policy
> which is the only policy that is applying. Anybody have any ideas on
> how I can install this.
as indicated by the error description, you have to provide a strong password
for "sa" login as a parameter, in the form of
c:\...\>setup.exe ... SAPWD="your strong password" ...
all available parameters for the setup.exe bootstrap installer are provided
at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
or, if you really are sure (please don't) you do not need a strong sa
password, you have to provide the
BLANKSAPWD=1
parameter
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea
I tried BLANKSAPWD=1 and I even tried setting a strong password, neither one
worked. Do you have any other suggestions?
"Andrea Montanari" wrote:

> hi bob,
> bob wrote:
> as indicated by the error description, you have to provide a strong password
> for "sa" login as a parameter, in the form of
> c:\...\>setup.exe ... SAPWD="your strong password" ...
> all available parameters for the setup.exe bootstrap installer are provided
> at
> http://msdn.microsoft.com/library/de...stsql_84xl.asp
> or, if you really are sure (please don't) you do not need a strong sa
> password, you have to provide the
> BLANKSAPWD=1
> parameter
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Bob,
bob wrote:
> Andrea
> I tried BLANKSAPWD=1 and I even tried setting a strong password,
> neither one worked. Do you have any other suggestions?
>
can you please post your paramenters?
what kind of error do you get?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

msde 2000 odbc connection failed

i have msde 2000 running on a server i am able to create an odbc connection to my db on that pc. when i try to create anpther odbc connection on another pc on that network i get the following error:

sql state '01000'
server error 2
[microsoft][odbc sql server driver][named pipes] connectionopen (connect()).
connection failed
sql state '08001'
server error 17
[microsoft][odbc sql server driver][named pipes]server does not exist or access denied.

what do i have to do to get this odbc connection on this pc working?

Thank You,
ThomasHave you enabled network protocols? If not try this. Easier to do this by uninstalling and then reinstalling.|||True, and take help of this KBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328306 to overcome the issue.

MSDE 2000 installation fails on Windows Vista 64-bit

Installation of MSDE 2000 fails on 64-bit Windows Vista (Build 5308).

The error message is "Setup failed to configure the server.Please refer the error logs for more information". No error log can be found on the machine at the time of installation. Please let me know if anyone else has encountered this problem?

Is it possible to install MSDE 2000 on 64-bit Windows Vista(Build 5308)?

Thanks in advance.

I don't believe any version of SQL Server or MSDE prior to SQL Server 2005 is supported on Vista. Someone else on the team who works on SQL Server 2000 should reply with a definitive answer...

Paul

|||Vista is still under development, so the right place to post your questions is Vista Newsgroups under "Application Compatibility" issues. I think the OS group has a AppCompat team that should be able to help you.|||

"Earlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a MSDE), SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server "Longhorn" or Windows Vista."

from http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx

sql

MSDE 2000 installation fails on Windows Vista 64-bit

Installation of MSDE 2000 fails on 64-bit Windows Vista (Build 5308).

The error message is "Setup failed to configure the server.Please refer the error logs for more information". No error log can be found on the machine at the time of installation. Please let me know if anyone else has encountered this problem?

Is it possible to install MSDE 2000 on 64-bit Windows Vista(Build 5308)?

Thanks in advance.

I don't believe any version of SQL Server or MSDE prior to SQL Server 2005 is supported on Vista. Someone else on the team who works on SQL Server 2000 should reply with a definitive answer...

Paul

|||Vista is still under development, so the right place to post your questions is Vista Newsgroups under "Application Compatibility" issues. I think the OS group has a AppCompat team that should be able to help you.|||

"Earlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a MSDE), SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server "Longhorn" or Windows Vista."

from http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx

MSDE 2000 install problem - Setup failed to configure the server

Hi,
I keep getting a "Setup failed to configure the server" message everytime i
try to install MSDE 2000. I have entered a strong pasword, as that was
required, removed any instances of previous msde installations and it makes
no difference.
I have read and followed instructions from various web sites and still no
installation.
Any help/advice appreciated.
Thanks
Jen
P.S. I am running XP SP2
Hello,
When you say that you removed every msde instance, did you remove the
Microsoft SQL Server directory?
My custommers have problems when they uninstall msde and they don't delete
the directory by hand after
Marc Allard
Allcomp
"JenC" <JenC@.discussions.microsoft.com> a crit dans le message de news:
EB81AD99-9F73-4731-B15F-BA1624075E9A@.microsoft.com...
> Hi,
> I keep getting a "Setup failed to configure the server" message everytime
> i
> try to install MSDE 2000. I have entered a strong pasword, as that was
> required, removed any instances of previous msde installations and it
> makes
> no difference.
> I have read and followed instructions from various web sites and still no
> installation.
> Any help/advice appreciated.
> Thanks
> Jen
> P.S. I am running XP SP2
|||If you setup is failing, specify a command line parameter DISABLEROLLBACK =
1, this would stop MSDE Installer from rolling back in case of failure.
Also specify /L*v <log file patch with name>. This would enable setup to
write logs into the specified file. Try to search "return value 3" and
check where did it fail.
Once we know where it is failing we can help better. Also add the logfile
when you reply next.
|||Try changing the parameters you use for setup.exe. For example, I removed the
DISABLENETWORKPROTOCOLS =1 and INSTANCENAME=MSDE2 parameters and it worked
fine after that.
Good luck.
"JenC" wrote:

> Hi,
> I keep getting a "Setup failed to configure the server" message everytime i
> try to install MSDE 2000. I have entered a strong pasword, as that was
> required, removed any instances of previous msde installations and it makes
> no difference.
> I have read and followed instructions from various web sites and still no
> installation.
> Any help/advice appreciated.
> Thanks
> Jen
> P.S. I am running XP SP2
sql

MSDE 2000 and ODBC (Connection failed)

Hi
I Installed MSDE 2000 and try to connect with it via ODBC.
I want the connection with SQL Server authentication using a login ID "sa" and blank password
But it is dispaly this message:
====================
Connection failed:
SQLState:'28000'
SQL Server Error:18456
[Microsoft][ODBC Sql Server Driver][SQL Server]Login failed for user 'sa'
====================check what authentication method your msde is using and make sure that standard security is available.|||Thanks ms_sql_dba

My MSDE use both WINDOWS/SQL Server authentication
I check "LoginMode" value in REGISTRY it's = Zero which mean both|||Thanks ms_sql_dba

My MSDE use both WINDOWS/SQL Server authentication
I check "LoginMode" value in REGISTRY it's = Zero which mean both|||Up 4 Help|||I found the Solution in Archive which guide me to this link:
http://www.dbforums.com/showthread.php?threadid=711306

The Solution is very simple:
Change "SA" password

use this command line in DOS:
osql -Q"exec sp_password null,'newpassword','sa'" -E

MSDE 2000

I'm trying to install this application but i get an error
Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
I'm running Windows XP SP2.
Could my SP2 be causing me problems considering I successfully installed it previously.
Many thanksWhat do the error logs say? That will be the key to solving theproblem. You might consider using the verbose setup log fileswitch on your SETUP.EXE command:

/L*v [filename]

sql

MSDE - Failed to configure server

I've been looking into this all day and haven't gotten anywhere. I'm using
InstallShield to install a .Net application, the application uses MSDE as
its database. I've added InstallShield's MSDE object to the install, works
fine sometimes but most of the time I get the following error message when
the MSDE is almost installed.
"Setup failed to configure the server. Refer to the server error logs and
setup errors for more information."
I've scoured the internet looking into this error and nothing seems to
correct this issue. I've remove all files, registry keys and anything
related to MSDE and I still get the same error.
Thanks in advance,
Dave
Have you tried installing MSDE using the file available for download from
Microsoft?
Linda
"Dave" <dave.golightly@.stgutah.com> wrote in message
news:uDSjGMDzEHA.2568@.TK2MSFTNGP10.phx.gbl...
> I've been looking into this all day and haven't gotten anywhere. I'm
> using
> InstallShield to install a .Net application, the application uses MSDE as
> its database. I've added InstallShield's MSDE object to the install,
> works
> fine sometimes but most of the time I get the following error message when
> the MSDE is almost installed.
> "Setup failed to configure the server. Refer to the server error logs and
> setup errors for more information."
> I've scoured the internet looking into this error and nothing seems to
> correct this issue. I've remove all files, registry keys and anything
> related to MSDE and I still get the same error.
> Thanks in advance,
> Dave
>
>
|||Have you tried installing MSDE using the file available for download from
Microsoft?
Linda
"Dave" <dave.golightly@.stgutah.com> wrote in message
news:uDSjGMDzEHA.2568@.TK2MSFTNGP10.phx.gbl...
> I've been looking into this all day and haven't gotten anywhere. I'm
> using
> InstallShield to install a .Net application, the application uses MSDE as
> its database. I've added InstallShield's MSDE object to the install,
> works
> fine sometimes but most of the time I get the following error message when
> the MSDE is almost installed.
> "Setup failed to configure the server. Refer to the server error logs and
> setup errors for more information."
> I've scoured the internet looking into this error and nothing seems to
> correct this issue. I've remove all files, registry keys and anything
> related to MSDE and I still get the same error.
> Thanks in advance,
> Dave
>
>

msdb log backup failed

Hello guys,
I am sorry if I insist but I am still having this error about msdb log
file failed.
BACKUP failed to complete the command BACKUP LOG [msdb] TO [systemLo
g]
WITH NOINIT , NOUNLOAD , NAME = N'msdb backup', NOSKIP , STATS =
10, NOFORMAT
I do not understand why.
Could someone help me on solve this problem.
InaHi,
Can you verify the recovery model of MSDB database by executing below
command:-
select databasepropertyex('msdb','recovery')
If the result return SIMPLE then you can not perform a transaction log
backup. Incase if you need to do a log backup then change the recovery
model to FULL using below command
ALTER DATABASE MSDB SET RECOVERY FULL
After to regroup the backup chain; perform a FULL MSDB backup and then then
start the log backup.,
Thanks
Hari
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1159778124.630986.307670@.h48g2000cwc.googlegroups.com...
> Hello guys,
> I am sorry if I insist but I am still having this error about msdb log
> file failed.
> BACKUP failed to complete the command BACKUP LOG [msdb] TO [system
Log]
> WITH NOINIT , NOUNLOAD , NAME = N'msdb backup', NOSKIP , STATS =
> 10, NOFORMAT
>
> I do not understand why.
> Could someone help me on solve this problem.
> Ina
>|||Thanks Hari,
It was set to simple. I changed as you advice me. One question when I
schedule the schedule log backup do you thing i can do something
between 4 Am until 10 Pm (every hour) because the backup of MSDB is 23
PM ?
ina
Hari Prasad wrote:[vbcol=seagreen]
> Hi,
> Can you verify the recovery model of MSDB database by executing below
> command:-
> select databasepropertyex('msdb','recovery')
> If the result return SIMPLE then you can not perform a transaction log
> backup. Incase if you need to do a log backup then change the recovery
> model to FULL using below command
> ALTER DATABASE MSDB SET RECOVERY FULL
> After to regroup the backup chain; perform a FULL MSDB backup and then the
n
> start the log backup.,
> Thanks
> Hari
>
> "ina" <roberta.inalbon@.gmail.com> wrote in message
> news:1159778124.630986.307670@.h48g2000cwc.googlegroups.com...

msdb log backup failed

Hello guys,
I am sorry if I insist but I am still having this error about msdb log
file failed.
BACKUP failed to complete the command BACKUP LOG [msdb] TO [systemLog]
WITH NOINIT , NOUNLOAD , NAME = N'msdb backup', NOSKIP , STATS =
10, NOFORMAT
I do not understand why.
Could someone help me on solve this problem.
Ina
Hi,
Can you verify the recovery model of MSDB database by executing below
command:-
select databasepropertyex('msdb','recovery')
If the result return SIMPLE then you can not perform a transaction log
backup. Incase if you need to do a log backup then change the recovery
model to FULL using below command
ALTER DATABASE MSDB SET RECOVERY FULL
After to regroup the backup chain; perform a FULL MSDB backup and then then
start the log backup.,
Thanks
Hari
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1159778124.630986.307670@.h48g2000cwc.googlegr oups.com...
> Hello guys,
> I am sorry if I insist but I am still having this error about msdb log
> file failed.
> BACKUP failed to complete the command BACKUP LOG [msdb] TO [systemLog]
> WITH NOINIT , NOUNLOAD , NAME = N'msdb backup', NOSKIP , STATS =
> 10, NOFORMAT
>
> I do not understand why.
> Could someone help me on solve this problem.
> Ina
>
|||Thanks Hari,
It was set to simple. I changed as you advice me. One question when I
schedule the schedule log backup do you thing i can do something
between 4 Am until 10 Pm (every hour) because the backup of MSDB is 23
PM ?
ina
Hari Prasad wrote:[vbcol=seagreen]
> Hi,
> Can you verify the recovery model of MSDB database by executing below
> command:-
> select databasepropertyex('msdb','recovery')
> If the result return SIMPLE then you can not perform a transaction log
> backup. Incase if you need to do a log backup then change the recovery
> model to FULL using below command
> ALTER DATABASE MSDB SET RECOVERY FULL
> After to regroup the backup chain; perform a FULL MSDB backup and then then
> start the log backup.,
> Thanks
> Hari
>
> "ina" <roberta.inalbon@.gmail.com> wrote in message
> news:1159778124.630986.307670@.h48g2000cwc.googlegr oups.com...

msdb log backup failed

Hello guys,
I am sorry if I insist but I am still having this error about msdb log
file failed.
BACKUP failed to complete the command BACKUP LOG [msdb] TO [systemLog]
WITH NOINIT , NOUNLOAD , NAME = N'msdb backup', NOSKIP , STATS = 10, NOFORMAT
I do not understand why.
Could someone help me on solve this problem.
InaHi,
Can you verify the recovery model of MSDB database by executing below
command:-
select databasepropertyex('msdb','recovery')
If the result return SIMPLE then you can not perform a transaction log
backup. Incase if you need to do a log backup then change the recovery
model to FULL using below command
ALTER DATABASE MSDB SET RECOVERY FULL
After to regroup the backup chain; perform a FULL MSDB backup and then then
start the log backup.,
Thanks
Hari
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1159778124.630986.307670@.h48g2000cwc.googlegroups.com...
> Hello guys,
> I am sorry if I insist but I am still having this error about msdb log
> file failed.
> BACKUP failed to complete the command BACKUP LOG [msdb] TO [systemLog]
> WITH NOINIT , NOUNLOAD , NAME = N'msdb backup', NOSKIP , STATS => 10, NOFORMAT
>
> I do not understand why.
> Could someone help me on solve this problem.
> Ina
>|||Thanks Hari,
It was set to simple. I changed as you advice me. One question when I
schedule the schedule log backup do you thing i can do something
between 4 Am until 10 Pm (every hour) because the backup of MSDB is 23
PM ?
ina
Hari Prasad wrote:
> Hi,
> Can you verify the recovery model of MSDB database by executing below
> command:-
> select databasepropertyex('msdb','recovery')
> If the result return SIMPLE then you can not perform a transaction log
> backup. Incase if you need to do a log backup then change the recovery
> model to FULL using below command
> ALTER DATABASE MSDB SET RECOVERY FULL
> After to regroup the backup chain; perform a FULL MSDB backup and then then
> start the log backup.,
> Thanks
> Hari
>
> "ina" <roberta.inalbon@.gmail.com> wrote in message
> news:1159778124.630986.307670@.h48g2000cwc.googlegroups.com...
> > Hello guys,
> >
> > I am sorry if I insist but I am still having this error about msdb log
> > file failed.
> >
> > BACKUP failed to complete the command BACKUP LOG [msdb] TO [systemLog]
> > WITH NOINIT , NOUNLOAD , NAME = N'msdb backup', NOSKIP , STATS => > 10, NOFORMAT
> >
> >
> > I do not understand why.
> >
> > Could someone help me on solve this problem.
> >
> > Ina
> >