Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Solomon 6.5 SQL Error ...
Microsoft Dynamics SL (Archived)

Solomon 6.5 SQL Error 18456

(0) ShareShare
ReportReport
Posted on by pcteamadmin 50

My client had contracted a Dymanics specialist to install and configure Solon 6.5 for them. Now that he is gone, I'm stuck having to support this.

 I get constant errors in the Windows event log stating:

 Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date:  9/18/2008
Time:  10:28:54 AM
User:  ACDOMAIN\melissa
Computer: ACRS004
Description:
Login failed for user ACDOMAIN\melissa'. [CLIENT: 192.168.1.71]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00   .H......
0008: 09 00 00 00 41 00 43 00   ....A.C.
0010: 4d 00 52 00 53 00 30 00   R.S.0.
0018: 30 00 34 00 00 00 07 00   0.4.....
0020: 00 00 6d 00 61 00 73 00   ..m.a.s.
0028: 74 00 65 00 72 00 00 00   t.e.r...

I get them on the Solom server for each of the Solomon users, contantly throughout the day. It fills my event logs. Does anyone know why?

 Also, they Solomon guy didn't want to upgrade to Dynamics 7 until a service pack was eleased. Now that he's gone, I may be forced to upgrade his customized installation. I have great concerns with this. Should I and simply let my client run 6.5 forever, or will the upgrade not harm any customizations he's done?

 Thanks for you help.
 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Re: Re: Re: Re: Solomon 6.5 SQL Error 18456
    Raj... I've been briefly following this thread. What version of SQL Server and Dynamics SL are you running? Also, which service pack do you have installed? Please, email me directly at arles.wells@gmail.com. I hardly ever check this site. Thanks! Arles
  • Hemraj Profile Picture
    Hemraj 590 on at
    Re: Re: Re: Re: Re: Re: Solomon 6.5 SQL Error 18456

    Hi

     it's not for 1 user, it's for all users who have solomon access.

    I believe all users are trying to login as windows authentication and then using Master60SP user.

    Thanks

     

     

  • Nayan Mansinha Profile Picture
    Nayan Mansinha 1,245 on at
    Re: Re: Re: Re: Re: Solomon 6.5 SQL Error 18456

    So, the same AD user is showing up in the log? May be there are jobs that are running under this AD account that are failing?

    HTH

  • Hemraj Profile Picture
    Hemraj 590 on at
    Re: Re: Re: Re: Solomon 6.5 SQL Error 18456

    Hi

    If you refer my first mail, you will get complete message.

    It's pointing to AD users(domain\user).

    I ran sql profiler also but no clue.

    Thanks

    Raj 

     

     

  • Nayan Mansinha Profile Picture
    Nayan Mansinha 1,245 on at
    Re: Re: Re: Solomon 6.5 SQL Error 18456

    Are you seeing such messages?

    Event Type:    Failure Audit
    Event Source:    MSSQLSERVER
    Event Category:    (4)
    Event ID:    18456
    Date:        1/17/2008
    Time:        1:29:00 PM
    User:        DOMAIN\User
    Computer:    SERVERNAME
    Description:
    Login failed for user 'DOMAIN\user'. [CLIENT: <local machine>]

    What user and computer entries are showing up?  Are they pointing to Solomon user?

    This might give some clue as to what is going on. And also, you may want to use SQL Profiler trace to track down the source of this error.

    HTH

  • Hemraj Profile Picture
    Hemraj 590 on at
    Re: Re: Solomon 6.5 SQL Error 18456

    User dont have any issue, but my concern is why SQL server is getting audit faliure.

    SQL server also setup as mixed mode and I believe solomon use Master60SP user to access SL database.

    Thanks

     

  • Hemraj Profile Picture
    Hemraj 590 on at
    Re: Re: Re: Solomon 6.5 SQL Error 18456

    Yes

     I changed server reference in domain table.

    People are working fine, but only in SQL event viewer is faliure audit.

     

     

     

  • Nayan Mansinha Profile Picture
    Nayan Mansinha 1,245 on at
    Re: Re: Solomon 6.5 SQL Error 18456

    [quote user="Hemraj"]I am also in same condition.[/quote] 

    Is Solomon working for you after the move?

    When you moved your DBs to different server, have you changed server references in your Domain table?

    HTH

  • Nayan Mansinha Profile Picture
    Nayan Mansinha 1,245 on at
    Re: Solomon 6.5 SQL Error 18456

    [quote user="pcteamadmin"]

    I get them on the Solom server for each of the Solomon users, contantly throughout the day. It fills my event logs. Does anyone know why?

    [/quote]

    Are your users experiencing issues while working in Solomon due to these errors in event log?  If not, you may want to look at your sql server or other programs that may be talking to this server. Look for sql logs and see if anything you can spot in there.

    HTH

  • Hemraj Profile Picture
    Hemraj 590 on at
    Re: Solomon 6.5 SQL Error 18456

    Hi

    I am also in same condition.

    I have solomon 6.5 SP2 and running on SQL server 2005.

    I created new database server and moved all the SL database to new server, my SQL server is also setup as Mixed mode, but not sure why I am getting message 18456 ( Failure Audit)

     Event Type: Failure Audit
    Event Source: MSSQLSERVER
    Event Category: (4)
    Event ID: 18456
    Date:  7/28/2010
    Time:  9:15:48 AM
    User:  HERSHA\tracie.slotwinski
    Computer: H099-DB002
    Description:
    Login failed for user 'HERSHA\tracie.slotwinski'. [CLIENT: 10.0.2.74]

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    Data:
    0000: 18 48 00 00 0e 00 00 00   .H......
    0008: 0b 00 00 00 48 00 30 00   ....H.0.
    0010: 39 00 39 00 2d 00 44 00   9.9.-.D.
    0018: 42 00 30 00 30 00 32 00   B.0.0.2.
    0020: 00 00 07 00 00 00 6d 00   ......m.
    0028: 61 00 73 00 74 00 65 00   a.s.t.e.
    0030: 72 00 00 00               r...   

    Is any resolution available ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans