Login issue

  • 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

  • - 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

  • 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.

  • 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.

  • 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
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • 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

  • Thank you all for your help, I will give all this a try and let you know what happens....

    Ken

  • Found the problem, using the article SSCrazy suggested I ran SSP and discovered Reporting services missconfigured. Thanks again for all your help!

    Ken

  • 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

  • Ok thanks Jeff!

  • CirquedeSQLeil (10/30/2009)


    SSCrazy = Jeff

    How do you know I'm not crazy? :w00t:

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • 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

  • Jeffrey Williams-493691 (10/30/2009)


    CirquedeSQLeil (10/30/2009)


    SSCrazy = Jeff

    How 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

  • You said it Jason - yep, we are all crazy....:-)

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • 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