Re: [Networker] SQL backup problems
2004-06-17 21:21:42
That is what it turned out to be. I had the nsrexecd service running under a
Domain account. It had been that way for so long I can't remember why I did
it. Not sure why it broke now, but I guess its is fixed.
Thanks for the help.
Brian
-----Original Message-----
From: Legato NetWorker discussion on behalf of Chad Smykay
Sent: Thu 6/17/2004 5:40 PM
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Cc:
Subject: Re: [Networker] SQL backup problems
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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
|
|
|