RE: SQL Server Agent Logon Issue (SBS 2003)
- From: v-yanniw@xxxxxxxxxxxxxxxxxxxx ("Jenny wu [MSFT]")
- Date: Thu, 17 Aug 2006 08:05:15 GMT
Hi Barry,
Thanks for using the SBS newsgroup. Many thanks for Bassplayer's input.
From your description, I understand the issue is that when you started SQLServer Agent, you received the following error message:
Error 1069: The service did not start due to a logon failure.
If I am off base, please don't hesitate to let me know.
Yes, as Bassplayer said, the issue may occur due to that the password for
the SQL Server startup service account or the SQL Server Agent startup
service account is not correct. Let us refer to the following steps to
trouble shoot the issue:
1. Open services console (Start -> Control panel -> Administrative Tools ->
services windows).
2. Selected the specific MSSQLserver service instance (For a named instance
of SQL Server, the instance name should be like as MSSQL$YourInstanceName)
and open its properties page.
3. Under LOG ON tab, please ensure log on AS --> LOCAL SYSTEM ACCOUNT
option is checked. If not, you can check the option and reboot the service
to see if the issue resolved.
4. If you would like to logon some instances with a account, you can check
the option "This account" and input correct domain admin user account and
password. Restart the service to see if the issue resolved.
More information:
Logging onto a Secure SQL Server Database Using SQL Authentication
http://msdn2.microsoft.com/ms227700.aspx
How to use Kerberos authentication in SQL Server
http://support.microsoft.com/kb/319723
You cannot use the Fax service on a Windows Server 2003-based domain
controller or you receive a "Permissions could not be properly configured
for Fax Operators" error message when you run the Windows Small Business
Server 2003 Setup program
http://support.microsoft.com/?id=842207
Have a nice day!
Sincerely,
Jenny Wu
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: SQL Server Agent Logon Issue (SBS 2003)as
thread-index: AcbBMe6DZCCeKYwiR1yndtDtDFy2Pw==
X-WBNR-Posting-Host: 203.118.53.2
From: =?Utf-8?B?YmFzc19wbGF5ZXI=?= <bassplayer@xxxxxxxxxxxxxxxxxxxxxxxxx>
References: <12e6182mbnqssa2@xxxxxxxxxxxxxxxxxx>
Subject: RE: SQL Server Agent Logon Issue (SBS 2003)
Date: Wed, 16 Aug 2006 05:46:02 -0700
Lines: 25
Message-ID: <65D242B6-E0BF-4D17-90B2-FF71DEC71335@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.windows.server.sbs
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:290328
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.windows.server.sbs
This is a service account problem. You do not use the SA account for this
this requires a Windows account. Check out
http://support.microsoft.com/kb/282254/EN-US/
--
MCP MCDBA MCAD MCSD MCT MCTS:SQL Server 2005
"Helping people grow and develop their full potential as God has plan for
them"
"Barry McConomy" wrote:
Hi
SQL Server
When I try the access the SQL Server Agent, I get a logon error message
(Error 1069).
Can some body advise where I can change/reset the SA account password
Regards
Barry
.
- References:
- SQL Server Agent Logon Issue (SBS 2003)
- From: Barry McConomy
- SQL Server Agent Logon Issue (SBS 2003)
- Prev by Date: RE: Fax Problem (Not all attachments can be rendered)
- Next by Date: Re: Client cannot logon to domain - unavailable
- Previous by thread: SQL Server Agent Logon Issue (SBS 2003)
- Next by thread: Adding a citrix server to SBS 2003
- Index(es):
Relevant Pages
|
