RE: SBS_Database_Cleanup Failed
- From: Alexander <Alexander@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 15 Sep 2005 02:13:12 -0700
Thank you for getting cack to me.
Could you please let me know how I launch SQL Enterprise Manager.
Thx
Alexander
"Crina Li (MSFT)" wrote:
> Hi Alexander,
>
> From the description, I understand that you received warning event 208 from
> the application log on the SBS server. If I have misunderstood your
> concerns, please do not hesitate to let me know.
>
> To troubleshoot this issue, would you please let me know if you have
> recently changed the name or password of administrator account? The default
> services and scheduled tasks are all run as System and Network (Local)
> Service account and you do not need to manually change them.
>
> If so, you may need to recheck the administrators account name by following
> information.
>
> You can either manually rename the Administrator account on the computer
> running SBS 2003, or, using GPMC, you can automatically rename all the
> Administrator account names in the network (including the server). So, if
> you just want to rename the Administrator account on the server itself, you
> can just use the manual listed below:
>
> To complete this procedure, you must be logged on as a member of the Domain
> Admins security group.
>
> 1. Open Server Management.
> 2. In the console tree, click Users.
> 3. In the details pane, right-click Administrator, and then click
> Properties.
> 4. On the General tab, in the Display text box, replace the previous name
> (Administrator) with a new name.
> 5. On the Account tab, in the User logon name box, type the new name.
> 6. In the User logon name (pre-Windows 2000) box, replace the previous
> user logon name (Administrator) with the new name, and then click OK.
> 7. After changing the Administrator account name, you need to restart the
> server and then use the new name to log back on as an administrator on the
> server.
>
> If the problem cannot be resolved, please let me know if you have SQL
> server installed? If so, can you find the Job ID
> {0xA756C0DDBD7A314E8DC180EA31610AAB} in the SQL Agents node? What's the
> owner of this job? Can you change it to other system/administrator account?
>
> If the problem still persists, we can try the following action plan:
>
> I. Restart the server
>
> II. Rerun Backup wizard to reschedule your backup task
>
> III. Change the Monitoring clean up job.
>
> 1. Start SQL Enterprise Manager
> 2. Expand Microsoft SQL Servers -> SQL Server Group
> 3. If you did not find the "YourServerName\SBSMONITORING (Windows NT)"
> instance is listed, please use the following steps to add it.
>
> a. Right click on the SQL Server Group and select New SQL Server
> Registration
> b. On the available server, please DO NOT choose local server. You should
> manually input SERVERNAME\INSTANCENAME, i.e. SERVERNAME\SBSMONITORING
> c. Follow the wizard and finish settings.
>
> 4. Then, expand YourServerName\SBSMONITORING (Windows NT) -> Management ->
> SQL Server Agent -> Jobs
> 5. There should be a job named with SBS_Database_Cleanup
> 6. Double click to open it
> 7. Please change the Owner to the correct Administrator account. You could
> also run it under a new account created by administrator template in add
> user wizard.
> 8. Click OK. If possible, I would suggest you to restart the server.
>
> If it does not work, please send the entire event log to me at
> v-crinal@xxxxxxxxxxxxx
>
> If you have any questions or concerns related to this issue, please let me
> know.
>
> I appreciate your time and look forward to hearing from you.
>
> Best regards,
>
> Crina Li (MSFT)
>
> Microsoft CSS Online Newsgroup Support
>
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> This newsgroup only focuses on SBS technical issues. If you have issues
> regarding other Microsoft products, you'd better post in the corresponding
> newsgroups so that they can be resolved in an efficient and timely manner.
> You can locate the newsgroup here:
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
>
> When opening a new thread via the web interface, we recommend you check the
> "Notify me of replies" box to receive e-mail notifications when there are
> any updates in your thread. When responding to posts via your newsreader,
> please "Reply to Group" so that others may learn and benefit from your
> issue.
>
> Microsoft engineers can only focus on one issue per thread. Although we
> provide other information for your reference, we recommend you post
> different incidents in different threads to keep the thread clean. In doing
> so, it will ensure your issues are resolved in a timely manner.
>
> For urgent issues, you may want to contact Microsoft CSS directly. Please
> check http://support.microsoft.com for regional support phone numbers.
>
> Any input or comments in this thread are highly appreciated.
>
> =====================================================
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --------------------
> | Thread-Topic: SBS_Database_Cleanup Failed
> || From: =?Utf-8?B?QWxleGFuZGVy?= <Alexander@xxxxxxxxxxxxxxxxxxxxxxxxx>
> | Subject: SBS_Database_Cleanup Failed
> | Date: Wed, 14 Sep 2005 03:14:03 -0700
> | | Newsgroups: microsoft.public.windows.server.sbs
> | |
> | Hi,
> |
> | I get the following message in the Event Viewer.
> |
> | Category: Job Engine
> | Event ID: 208
> |
> | SQL Server Scheduled Job 'SBS_Database_Cleanup'
> | (0xA756C0DDBD7A314E8DC180EA31610AAB) - Status: Failed - Invoked on:
> | 2005-09-14 03:00:00 - Message: The job failed. The owner () of job
> | SBS_Database_Cleanup does not have server access.
> |
> | Has anyone got any thoughts?
> |
> | Thanks
> |
> | Alexander
> |
> |
>
>
.
- References:
- RE: SBS_Database_Cleanup Failed
- From: Crina Li (MSFT)
- RE: SBS_Database_Cleanup Failed
- Prev by Date: RE: SBS 2003 Firewall Failure
- Next by Date: RE: SBS 2003 Firewall Failure
- Previous by thread: RE: SBS_Database_Cleanup Failed
- Next by thread: RE: SBS_Database_Cleanup Failed
- Index(es):
Relevant Pages
|
