Re: Backup SQL Server DB on Network Drive Big Problem. Please help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 12/31/04 

Date: Fri, 31 Dec 2004 12:52:10 +0100

Try to change the job owner to sa. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Tai Kelvin" <kelvinweb@gmail.com> wrote in message news:ORQOrBy7EHA.3696@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> When I change the owner to "Domain Administrator" to execute the T-SQL
> to backup database to the network drive.
> It display the following error:
>
> The job failed.  Unable to determine if the owner (Domain\Administrator)
> of job Test Backup has server access (reason: Could not obtain
> information about Windows NT group/user 'Domain\Administrator'.
> [SQLSTATE 42000] (Error 8198)).
>
> But the Shared Network Drive PC haven't connect Domain, runing on
> workgroup only. I can't directly to access that PC. Please advise.
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Backup SQL Server DB on Network Drive Big Problem. Please help
    ... When I change the owner to "Domain Administrator" to execute the T-SQL ... to backup database to the network drive. ... of job Test Backup has server access (reason: ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 dbo user issue
    ... Who does it say is the owner on the files page of the properties dialog? ... > but I still get the same error when clicking the Database Diagrams folder: ... >> Kalen Delaney, SQL Server MVP ... >>> The problem is the dbo account that came over appears to be incomplete. ...
    (microsoft.public.sqlserver.security)
  • Re: Sql Maintenance Plans
    ... You can change the owner of the job in EM, ... Tibor Karaszi, SQL Server MVP ... "Ale S." ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Error when trying to schedule job in SQL 2008
    ... job Sostenuto AD Import has server access (reason: ... information about Windows NT group/user 'NICE-PAK\SVC_Sostenuto', ... Have you tried to change the job owner? ...
    (microsoft.public.sqlserver.server)
  • Re: who is the owner..
    ... GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.tablename TO myuser ... SQL Server MVP ... > 1> if using SQL Authentication then instead of using the sa login to ... > 3> that the owner of the database is the user who created it. ...
    (microsoft.public.sqlserver.msde)