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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=