VERITAS Backup Exec 9.1 SP5

Hi All,

Has anyone been able to backup the WSUS 3.0 database using Veritas
BackupExec 9.1 SP5 /w Advance Open File Agent & SQL Agent ?

I was able to backup the WSUS 2.0; but now, I get an error when selecting
the MSSQL$MICROSOFT##SSEE database in the Veritas Backup Job -> Selections.

"An error was encountered while attempting to browse the contents of
WSUSSERVER\MICROSOFT##SSEE. Microsoft SQL Server does not appear to be
running or network connections are preventing access to it."


The Event Log reports:

Event Type: Failure Audit
Event Source: MSSQL$MICROSOFT##SSEE
Event Category: (4)
Event ID: 18452

Login failed for user 'DOMAIN\VeritasAdmin'. The user is not associated with
a trusted SQL Server connection. [CLIENT: <named pipe>]


Event Type: Error
Event Source: Backup Exec
Event Category: None
Event ID: 57860

An error occurred while attempting to log in to the following server:
"WSUSSERVER\MICROSOFT##SSEE".
SQL error number: "4814".
SQL error message: "Login failed for user 'DOMAIN\VeritasAdmin'. The user
is not associated with a trusted SQL Server connection."


Any insights would be appreciated.

Cheers,

HilaireG

"hilaireg" <hilaireg@discussions.microsoft.com> wrote in message
news:AC7C6E68-23D3-4C50-A8B1-F92E24323CEC@microsoft.com...
> Hi All,
>
> Has anyone been able to backup the WSUS 3.0 database using Veritas
> BackupExec 9.1 SP5 /w Advance Open File Agent & SQL Agent ?
>
> I was able to backup the WSUS 2.0; but now, I get an error when selecting
> the MSSQL$MICROSOFT##SSEE database in the Veritas Backup Job ->
> Selections.
>
> "An error was encountered while attempting to browse the contents of
> WSUSSERVER\MICROSOFT##SSEE. Microsoft SQL Server does not appear to be
> running or network connections are preventing access to it."

Well, the first question would be: Does Veritas BackupExec 9.1 support SQL
Server =2005= as a backup source?

> Login failed for user 'DOMAIN\VeritasAdmin'. The user is not associated
> with
> a trusted SQL Server connection. [CLIENT: <named pipe>]

Or, it could simply be that you need to create the missing account in the
database.

--
Lawrence Garvin, M.S., MCTS, MCP
Independent WSUS Evangelist
MVP-Software Distribution (2005-2007)
https://mvp.support.microsoft.com/pr...2-D095EB07B36E

Everything you need for WSUS is at
http://technet2.microsoft.com/window...s/default.mspx

And, almost everything else is at
http://wsusinfo.onsitechsolutions.com
.....

Veritas 9.1 does NOT support SQL 2005 and never will according to Symantec.


"Lawrence Garvin (MVP)" <onsitech@community.nospam> wrote in message
news:OPQfnKMpHHA.3892@TK2MSFTNGP04.phx.gbl...
> "hilaireg" <hilaireg@discussions.microsoft.com> wrote in message
> news:AC7C6E68-23D3-4C50-A8B1-F92E24323CEC@microsoft.com...
>> Hi All,
>>
>> Has anyone been able to backup the WSUS 3.0 database using Veritas
>> BackupExec 9.1 SP5 /w Advance Open File Agent & SQL Agent ?
>>
>> I was able to backup the WSUS 2.0; but now, I get an error when selecting
>> the MSSQL$MICROSOFT##SSEE database in the Veritas Backup Job ->
>> Selections.
>>
>> "An error was encountered while attempting to browse the contents of
>> WSUSSERVER\MICROSOFT##SSEE. Microsoft SQL Server does not appear to be
>> running or network connections are preventing access to it."
>
> Well, the first question would be: Does Veritas BackupExec 9.1 support SQL
> Server =2005= as a backup source?
>
>> Login failed for user 'DOMAIN\VeritasAdmin'. The user is not associated
>> with
>> a trusted SQL Server connection. [CLIENT: <named pipe>]
>
> Or, it could simply be that you need to create the missing account in the
> database.
>
> --
> Lawrence Garvin, M.S., MCTS, MCP
> Independent WSUS Evangelist
> MVP-Software Distribution (2005-2007)
> https://mvp.support.microsoft.com/pr...2-D095EB07B36E
>
> Everything you need for WSUS is at
> http://technet2.microsoft.com/window...s/default.mspx
>
> And, almost everything else is at
> http://wsusinfo.onsitechsolutions.com
> ....
>
>

Thanks all for the responses.

This is correct ... will have to upgrade to an newer version of Backup Exec
(and its agents).

The Deployment Guide should probably contain more information regarding 3rd
Party vendor backups as it would assist folks who may not have the luxury of
a "test" environment.

Cheers,

HilaireG

"John Sulko" wrote:

> Veritas 9.1 does NOT support SQL 2005 and never will according to Symantec.
>
>
> "Lawrence Garvin (MVP)" <onsitech@community.nospam> wrote in message
> news:OPQfnKMpHHA.3892@TK2MSFTNGP04.phx.gbl...
> > "hilaireg" <hilaireg@discussions.microsoft.com> wrote in message
> > news:AC7C6E68-23D3-4C50-A8B1-F92E24323CEC@microsoft.com...
> >> Hi All,
> >>
> >> Has anyone been able to backup the WSUS 3.0 database using Veritas
> >> BackupExec 9.1 SP5 /w Advance Open File Agent & SQL Agent ?
> >>
> >> I was able to backup the WSUS 2.0; but now, I get an error when selecting
> >> the MSSQL$MICROSOFT##SSEE database in the Veritas Backup Job ->
> >> Selections.
> >>
> >> "An error was encountered while attempting to browse the contents of
> >> WSUSSERVER\MICROSOFT##SSEE. Microsoft SQL Server does not appear to be
> >> running or network connections are preventing access to it."
> >
> > Well, the first question would be: Does Veritas BackupExec 9.1 support SQL
> > Server =2005= as a backup source?
> >
> >> Login failed for user 'DOMAIN\VeritasAdmin'. The user is not associated
> >> with
> >> a trusted SQL Server connection. [CLIENT: <named pipe>]
> >
> > Or, it could simply be that you need to create the missing account in the
> > database.
> >
> > --
> > Lawrence Garvin, M.S., MCTS, MCP
> > Independent WSUS Evangelist
> > MVP-Software Distribution (2005-2007)
> > https://mvp.support.microsoft.com/pr...2-D095EB07B36E
> >
> > Everything you need for WSUS is at
> > http://technet2.microsoft.com/window...s/default.mspx
> >
> > And, almost everything else is at
> > http://wsusinfo.onsitechsolutions.com
> > ....
> >
> >
>
>
>

"John Sulko" <JSulko@nospam.com> wrote in message
news:%23XOXCyrpHHA.208@TK2MSFTNGP05.phx.gbl...

>>> "An error was encountered while attempting to browse the contents of
>>> WSUSSERVER\MICROSOFT##SSEE. Microsoft SQL Server does not appear to be
>>> running or network connections are preventing access to it."

>> Well, the first question would be: Does Veritas BackupExec 9.1 support
>> SQL Server =2005= as a backup source?

> Veritas 9.1 does NOT support SQL 2005 and never will according to
> Symantec.

That was my gut feeling. Thank you for the confirmation, John.

--
Lawrence Garvin, M.S., MCTS, MCP
Independent WSUS Evangelist
MVP-Software Distribution (2005-2007)
https://mvp.support.microsoft.com/pr...2-D095EB07B36E

Everything you need for WSUS is at
http://technet2.microsoft.com/window...s/default.mspx

And, almost everything else is at
http://wsusinfo.onsitechsolutions.com
.....

"hilaireg" <hilaireg@discussions.microsoft.com> wrote in message
news:E5978059-B5EA-4F53-82AF-DBB4E91283D5@microsoft.com...

> The Deployment Guide should probably contain more information regarding
> 3rd
> Party vendor backups as it would assist folks who may not have the luxury
> of
> a "test" environment.

Humor me, please?

Why do you feel it's the responsibility of Microsoft to provide detailed
guidance on the use of third-party backup products, when NTBACKUP is
perfectly capable of backing up the full WSUS environment as good as, or
better than, any other third-party product on the market? The Deployment
Guide provides detailed instructions on how to use NTBACKUP for this very
purpose.


--
Lawrence Garvin, M.S., MCTS, MCP
Independent WSUS Evangelist
MVP-Software Distribution (2005-2007)
https://mvp.support.microsoft.com/pr...2-D095EB07B36E

Everything you need for WSUS is at
http://technet2.microsoft.com/window...s/default.mspx

And, almost everything else is at
http://wsusinfo.onsitechsolutions.com
.....

"Lawrence Garvin (MVP)" <onsitech@community.nospam> wrote in message
news:O21T#expHHA.3736@TK2MSFTNGP03.phx.gbl...
> "John Sulko" <JSulko@nospam.com> wrote in message
> news:%23XOXCyrpHHA.208@TK2MSFTNGP05.phx.gbl...
>
>>>> "An error was encountered while attempting to browse the contents of
>>>> WSUSSERVER\MICROSOFT##SSEE. Microsoft SQL Server does not appear to be
>>>> running or network connections are preventing access to it."
>
>>> Well, the first question would be: Does Veritas BackupExec 9.1 support
>>> SQL Server =2005= as a backup source?
>
>> Veritas 9.1 does NOT support SQL 2005 and never will according to
>> Symantec.
>
> That was my gut feeling. Thank you for the confirmation, John.
>
> --
> Lawrence Garvin, M.S., MCTS, MCP
> Independent WSUS Evangelist
> MVP-Software Distribution (2005-2007)
> https://mvp.support.microsoft.com/pr...2-D095EB07B36E
>
> Everything you need for WSUS is at
> http://technet2.microsoft.com/window...s/default.mspx
>
> And, almost everything else is at
> http://wsusinfo.onsitechsolutions.com
> ....
>
>

Hi,

I will just add that Symantec stopped supporting VERITAS Backup Exec 9.1 on
January 18 2007.

Craig

"Craig Brown" <broca002@yahoo.com> wrote in message
news:OfSgjS2pHHA.3644@TK2MSFTNGP02.phx.gbl...

>>>>> "An error was encountered while attempting to browse the contents of
>>>>> WSUSSERVER\MICROSOFT##SSEE. Microsoft SQL Server does not appear to
>>>>> be
>>>>> running or network connections are preventing access to it."

>>>> Well, the first question would be: Does Veritas BackupExec 9.1 support
>>>> SQL Server =2005= as a backup source?

>>> Veritas 9.1 does NOT support SQL 2005 and never will according to
>>> Symantec.

>> That was my gut feeling. Thank you for the confirmation, John.

> I will just add that Symantec stopped supporting VERITAS Backup Exec 9.1
> on January 18 2007.

Yeah.. I knew it was an *older* version.... just didn't know exactly how
old, and whether it predated SQL 2005.

--
Lawrence Garvin, M.S., MCTS, MCP
Independent WSUS Evangelist
MVP-Software Distribution (2005-2007)
https://mvp.support.microsoft.com/pr...2-D095EB07B36E

Everything you need for WSUS is at
http://technet2.microsoft.com/window...s/default.mspx

And, almost everything else is at
http://wsusinfo.onsitechsolutions.com
.....