web
You’re offline. This is a read only version of the page.
close
Skip to main content
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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    Re: Solomon 6.5 SQL Error 18456

     Wow... that could be a slight problem.  Here's how I would go about it.

     1)  Does ACDOMAIN\melissa own any objects in the instance of SQL Server that Solomon is using?  I'd specifically check for triggers or possibly DTS/SSIS packages.  Pretty much anything that is triggered to run or scheduled to run.

    2)  When you say "customized installation", do you mean the previous "expert" created a lot of customized screens or did a lot of customized SQL in the database.  If we're just talking from a screen perspective then you should be fne by just exporting the screens one by one and the reimporting once you upgrade to 7.0 (with SP1 and all the hotfixes).  Also, you may want to make sure that the screen customizations were done with VBA and not BSL.  The VBA skillset is a lot easier to find than BSL (at least in my experience).

    3)  Your client will have no problem running on version 6.5 until Microsoft ends support of that product.  I'm not positive of the exact support end date but I do know you're not in any immediate danger of that happening since 7.0 is really just now starting to get traction among most of the install base.

     

    Arles

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

  • 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

  • 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

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

     

     

     

  • 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

     

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

     

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans