Answered

Error Message when trying to Access Dynamics SL 2011

(0) Share

Report

Posted on by Community Member 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)

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

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

Blaine Bryant on at

Like (0)

Report

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