Re: SQL 2000 after upgrade to server 2003 from NT4

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

Date: Tue, 27 Apr 2004 19:16:25 +0200

Try to change the owner for each job to "sa". 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Maurice Reed" <anonymous@discussions.microsoft.com> wrote in message
news:4DBD65EE-81A6-40BF-B32F-767AC9F07ED5@microsoft.com...
> I had SQL2000 running fine on an NT4 BDC. I did an upgrade to Server 2003 and made the server a 'member
server' rather than a DC. Now the SQL is running fine but since the upgrade I have noticed that the overnight
maintenance job that I had set up is now failing.
>
> Within the SQL Enterprise Manager under Management->Database Maintenance
> Plans I had a job set up to check integrity and backup the DB and
> transaction logs. The message in the event log is:-
>
> Source SQLSERVERAGENT
> Event ID 208
>
> SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
> 'DB Maintenance Plan2'' (0xBF208E4DDF3B064BAF0A18CAF4F4E9B7) - Status:
> Failed - Invoked on: 2004-04-27 00:00:00 - Message: The job failed.  Unable
> to determine if the owner (mydomain\Administrator) of job Transaction
> Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan2' has server
> access (reason: Could not obtain information about Windows NT group/user
> 'mydomain\Administrator'. [SQLSTATE 42000] (Error 8198)).
>
> The other day I deleted the original
> maintenance job (No 1) and created a new one and also within Enterprise
> manager I went to Security-> Logins and added the Domain Administrator and
> set full access. Despite that the jobs are still failing.
>
> I do have daily tape backups but I would like to get these jobs working again. If anyone has a suggestion
I'd be most greatful.

Relevant Pages

  • Re: User names
    ... > With SP3 will tables created by upsizing from access also be dbo owned as ... >>dbo by default. ... byjust specifically giving the owner name in QA. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Orphan Indexes?
    ... >> Perhaps an owner issue for the table? ... >> Tibor Karaszi, SQL Server MVP ... >>> table is not the same as when I created the SP's in Query Analyzer. ... But now I have a major problem. ...
    (microsoft.public.sqlserver.programming)
  • Re: Cannot view DB properties
    ... # Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Server ... owner was NULL after the UPgraded finished successfully. ... The proposed new database owner is already a user or aliased in the ... Sorry, I don't understand, what do you mean by "In-Place Upgrade"? ...
    (microsoft.public.sqlserver.security)
  • Re: Advice on middleware products for TRUE Scaling out of SQL Server
    ... The Metaverse database scattering middleware prodcut is NOT ... The owner actually recommended the 2nd ... The PCTI Corp middleware product is available. ... The built in SQL Server 2005 tools for analyzing performance problems ...
    (comp.databases.ms-sqlserver)
  • Re: DBO Best Practices
    ... lines of always owner qualifying objects... ... someone who are just "a" dbo. ... > doesn't explicitly reference the object's owner (because SQL Server will ... The startup account defines the ...
    (microsoft.public.sqlserver.security)
Loading