October 29, 2009 at 12:52 pm
I am receiving the following error stack on an SQLServer 2005 SP2 server:
"10/20/2009 5:18:24PM Logon Login failed for user 'ictlan\MSSQLSERVICE'.[client:10.1.22.4] SQLSERVER current - 10/28/2009 5:18:00PM"
"10/28/2009:5:18:24PM Logon Error 18456, Severity 14, State 16. SQLSERVER Current 10/28/2009:5:18:00PM"
The Application event log has the following entry:
"Failure Audit 10/28/2009:5:18:00PM MSSQLSERVICE (4) 18456 MSSQLSERVICE Fiona"
This exact sequence of errors repeats every 10 to 20 seconds 24 hours a day and has been doing so for the last week.
A little about the user MSSQLSERVICE -
1. Is a domain account with domain administrator rights
2. Is a member of the local server administrators group
3. Is the logon for the SQLServer service as well as the agent service
4. Has been granted Sysadmin rights in SQLServer
5. Has the Master database as its default database
6. This user is used for the same purpose and has the same rights on other SQLServer machines with no problems logging or other wise.
When I look at the activity log MSSQLSERVICE has two SQLAgent jobs - Generic Refresher and Job invocation engine.
This server is restarted once a week and this problem seems to have started after the last restart.
Has anyone any experience with this sort of thing? Thanks in advance for your help.
Ken
October 29, 2009 at 1:45 pm
- It is a very bad habit to use a domain admin account for sqlserver service account.
Always aim for minimal rights for any service account to keep doors as closed as possible !!
- Can it be someone changed the accounts password ?
- What kind of computer is on address 10.1.22.4
That's where your issue comes from !
(Maybe someone specified a wrong password or forgot to update the password)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 29, 2009 at 4:32 pm
ALZDBA,
Thanks for your reply and thanks for the tip about the domain admin account. In reference to the domain user what is a better way of starting the services? Should I use a local admin account on the server itself?
As for my problem the computer is not a virtual server it is a Dell Poweredge 1750 used as a database server only. The account MSSQLSERVICE is used as the log on for all the sql server services and they all start and run as they should. This particular account is used to only start SQLServer services and is not used as a login by anyone. The password has not been changed as only myself and two other people know the password, I spoke with them and they did not change the password. We have restarted the machine which made no difference at all and I really have no idea what the account is attempting to log on for. As stated above the account is not used for any other purpose other than starting SQLServer services.
October 29, 2009 at 4:40 pm
I'm not sure about the issue, but for the service account. Use a domain user, normal user. They do not need to be a domain admin, or a local admin. If you use the configuration manager, it will set the proper rights.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 29, 2009 at 5:14 pm
Take a look at the following article: http://www.eraofdata.com/blog/2009/01/loginfailures/
What is stated here is that most likely the problem is this user does not have permissions on the default database. This could be caused by an explicit deny - or the fact that someone has removed sysadmin rights on the BUILTIN\Administrators group and/or the SQL Server specific groups.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
October 30, 2009 at 1:27 am
or maybe someone just dropped the database that had been set for default database of the service account.
Solution:
ALTER LOGIN [ictlan\MSSQLSERVICE] WITH DEFAULT_DATABASE=[master]
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 30, 2009 at 1:20 pm
Thank you all for your help, I will give all this a try and let you know what happens....
Ken
October 30, 2009 at 2:38 pm
Found the problem, using the article SSCrazy suggested I ran SSP and discovered Reporting services missconfigured. Thanks again for all your help!
Ken
October 30, 2009 at 2:53 pm
SSCrazy = Jeff
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 30, 2009 at 2:56 pm
Ok thanks Jeff!
October 30, 2009 at 2:57 pm
CirquedeSQLeil (10/30/2009)
SSCrazy = Jeff
How do you know I'm not crazy? :w00t:
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
October 30, 2009 at 3:02 pm
Well don't know but I have always found keeping a healthy level of insanity helps keep me sane dealing with this job at times!
Ken
October 30, 2009 at 3:04 pm
Jeffrey Williams-493691 (10/30/2009)
CirquedeSQLeil (10/30/2009)
SSCrazy = JeffHow do you know I'm not crazy? :w00t:
Aren't we all who are SQL DBA's? 😉
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 30, 2009 at 3:07 pm
You said it Jason - yep, we are all crazy....:-)
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
October 31, 2009 at 4:35 am
it isn't mandatory, but it helps for sure :-P:-D
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply