Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Error Message when trying to Access Dynamics SL 2011

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I'm getting the following message when I try to Access the Dynamics SL application.

 

SQL Server error message 515

Microsoft SQL Server Native Cliente 10.0 Cannot insert the value NULL en the column AccessDate, Table "SYSVIPROCON.DBO.ACCESS" The column does not allow null values.

 

Does anybody knows why is this happening.

We are running Dynamics SL with the spanish overlay. And the reginal settings in the server is set to Spanish(México)

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error Message when trying to Access Dynamics SL 2011

    Blaine

    I did what you suggest and then we didn't get the problem any more.

    Thank you very much for your help

  • Verified answer
    RE: Error Message when trying to Access Dynamics SL 2011

    MMAAFS,

    We have seen this problem before. Please try the following:

    A.      If you use SQL Authentication follow these steps:

    1.       Open SQL Server Management Studio

    2.       Login as the SQL user ‘SA’

    3.       In the Object Explorer pane expand ‘Security’, then ‘Logins’

    4.       Right-Click ‘Master80’, select ‘Properties’

    5.       At the Bottom of the screen change the ‘Default Language:’ to ‘English’

    6.       Select ‘Ok’

    7.       Open and Login to Dynamics SL to test

    B.      If you use Windows Authentication follow these steps:

    1.       Open SQL Server Management Studio

    2.       Login as the SQL user ‘SA’

    3.       In the Object Explorer pane expand ‘Security’, then ‘Logins’

    4.       Right-Click a SL User Login, select ‘Properties’

    5.       At the Bottom of the screen change the ‘Default Language:’ to ‘English’

    6.       Select ‘Ok’

    7.       Repeat for all Dynamics SL users.

    8.       Open and Login to Dynamics SL with all users to test

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,289 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans