Word.  We see this issue all the time.  Make sure that the MSSQLSERVER
service and SQL Service Helper AND the Legato NSREXEC service are ALL
running under the same user.  On a side note if you have any MSSQL Clusters
make sure all of the user's match up as well.

Regards,


Chad Smykay, RHCE, LCNA
Systems Storage Administrator
Rackspace Managed Hosting (TM) - The Managed Hosting Specialist (TM)
210-892-4025 ext 1603
Cell: 210-273-2344

-----Original Message-----
From: Legato NetWorker discussion [mailto:NETWORKER AT LISTMAIL.TEMPLE DOT EDU] 
On
Behalf Of f_x
Sent: Thursday, June 17, 2004 1:31 PM
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Subject: Re: [Networker] SQL backup problems

run the networker client under same account as the mssql server.

Narkinsky, Brian schrieb:

> I keep getting the following errors while doing a scheduled backup of
> a SQL server (tried both 3.1.1 and 4.01 NW SQL client) Any ideas?
> Interestingly a manual backup seems to work OK.
>
> Thanks,
>
> Brian Narkinsky
>
> System Manager
>
> Department of Environmental Protection
>
> for nsrsqlsv.log
>
> [2128] Start time Thu Jun 17 11:33:07 2004
>
> [2128] Computer Name: TLHMOM2 User Name: FLORIDADEP\schedule
> (schedule)
>
> [2128] System Version: 5.0 Build 2195 Service Pack 4
>
> [2128] Microsoft Data Access Component(MDAC) version: 2.71.9030.9
>
> [2128] Microsoft SQL Server version (from registry) : 8.00.194
>
> [2128] Local host has following SQL Server online:
>
> [2128] MSSQL server : TLHMOM2
>
> [2128] Use Legato Networker Server : tlhbu1.floridadep.net
>
> [2128] Legato Networker Server Version: NetWorker 6.1.3.Build.428
> Power Edition/60
>
> [2128] nsrexecd.exe Version: 6.1.3.Build.428
>
> [2128] nsrsqlsv.exe Version: 4.0.1.294 Supporting SQL 7.0 and SQL 2000
>
> [2128] Command line:
>
> [2128] C:\Program Files\nsr\bin\nsrsqlsv.exe -s tlhbu1.floridadep.net
> -g MOM -LL -m tlhmom2 -t 1085384300 -l incr -q -W 78 -N MSSQL: MSSQL:
>
> [2128] Microsoft SQL Server Provider error:
>
> [2128] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user
> default database. Login failed..
>
> [2128]
>
> Cannot login to SQL Server null.
>
> [2128] Completion time Thu Jun 17 11:33:29 2004
>
>
> Brian Narkinsky
>
> System Manager
>
> Department of Environmental Protection
>
> MS 6520
>
> 2600 Blairstone RD
>
> Tallahassee, FL 32399
>
> phone (850)245-8314
>
> fax (850)412-0400
>
>
>
> --
> Note: To sign off this list, send a "signoff networker" command via
> email to listserv AT listmail.temple DOT edu or visit the list's Web site at
> http://listmail.temple.edu/archives/networker.html where you can also
> view and post messages to the list.
> =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
>

--
Note: To sign off this list, send a "signoff networker" command via email to
listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can also view
and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=