Error: Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection

Last week, when testing Extended Demo Database, when logging to SQL server with Dynamics NAV client, I received error message saying: “Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection.” This got me thinking… what did I do differentlly? I was able to login just a minute ago and nothing really changed since then… but the error message was there, starring at me:

The following SQL server error or errors occurred - The user is not associated with a trusted SQL Server connection

Then (while making a cup of coffee), it hit me – I was trying to login with “Database Logins” user and previously I have been working with Windows Logins. Which must mean, that my SQL server has been configured to operate in “Windows Authentication Mode” only and it didn’t allow
the use of SQL (Database Logins) accounts.

So, all I needed to do, was to change the Authentication Mode of the SQL server from “Windows Authentication Mode”
to “Mixed Mode” (Windows Authentication and SQL Server Authentication).

How do you change the Authentication Mode of the SQL server?

Start SQL Server Management Studio. Connect to your SQL server and right-click on the server and select Properties.
SQL Error - Properties

Click on the “Security” tab. You will notice that “Windows Authenication mode” has been selected.
SQL Error - Windows Authentication mode

Click on “SQL Server and Windows Authentication mode”. Click OK.
SQL Error - SQL Server Authenticationn

You will get a message saying that, you should restart SQL server. Click OK.
SQL Error - Configuration Changes Require Restart

Then, to restart the SQL server, just right-click on the server name again, and select “Restart” option.
SQL Error - Restart Server

Sorted. Now, you should be able to login to your Dynamics NAV using Database Logins.

Technorati Tags: , , , ,

Posted in Dynamics NAV / Navision, errors | Tagged , , , , | Leave a comment

Error: You cannot print in a report where the property ProcessingOnly is set to Yes

I wanted to share a quick tip (or rather a possible solution for another Dynamics NAV erorr message). If you will ever receive error message saying:

—————————
Microsoft Dynamics NAV Classic
—————————
You cannot print in a report where the property ‘ProcessingOnly’ is set to ‘Yes’.

—————————
OK
—————————

Remember, that there are two things to check:
1. ProcessingOnly property for the report is set to Yes. Should it be?
2. There is at least one report’s section added to the report. Should it be there?

Usually, this issue is induced by someone changing existing report from normal report to ProcessingOnly report (and forgetting to delete existing sections). So, if you want to replicate the issue, just find any of your ProcessingOnly reports and add a new section for it, compile report and run it. Result… error, that is!

Therefore, if report should print some details (if it is NOT ProcessingOnly report), go to report designer and click on blank DataItem,
Report Designer - Blank Data Item
click View > Properties (or Shift+F4 on your keyboard),
Report Designer - View - Properties
find ProcessingOnly property (by the way, here you can search for a property similarly as searching for a field in Table Designer, just click the first letter of the property you are looking for – “P”),
Report Designer - ProcessingOnly YES
and delete the “Yes” value (which will set ProcessingOnly to default value)
Report Designer - ProcessingOnly NO

Result!

On the other hand, if report needs to be ProcessingOnly (if developer has printed some data for testing purposes only, but now, no output is required), you will need to leave ProcessingOnly property set to “Yes” and to delete all sections – go to report designer, click View > Sections,
Report Designer - View - Sections
click on each Section (to select it) and click F4 (or Edit > Delete),
Report Designer - Delete Section
and click OK to confirm deletion.
Report Designer - Confirm Deletion
Once all sections have been deleted,
Report Designer - No more sections
click ESC to go back to report designer and save changes.

If you will run your Dynamics NAV report again, you will not get same error message anymore.

Technorati Tags: , ,

Posted in Dynamics NAV / Navision, errors | Tagged , , | 1 Comment

Extended Demo Database Backups for Dynamics NAV has been released on PartnerSource

According to Про Navision, Алексей Финогенов, Microsoft has just released a new set of Dynamics NAV backups with more DEMO data in them – extended demo database backups. And by more, we mean a lot more – previously, CRONUS database was limited to only 26 days of real demo data. The extended demo database will add 5 years of additional data.

CRONUS EXT UK Ltd.

According to PartnerSource:

The extended demo data includes data for the following areas:

* Finance: Utility bills, rent expenses, bank entries, customer payments, vendor payments, end of year postings and many more required to simulate a real company. A simple financial budget has also been included to ensure a good way to compare actual to budget.
* Sales: Sales orders, items, G/L accounts. Additional customers and ship-to addresses have been added to give a more realistic number of customers. Address information works with geo-features in Business Intelligence solutions.
* Purchase: Orders, items and G/L accounts
* Inventory: Adjust cost, journal adjustments and physical Inventory, 7xxxx and 19xx-x items are being used.

The extended demo data are NOT extended with:

* Item tracking, Kitting, WMS, Manufacturing, Service Management, Job, Fixed Assets, Check, Bank Reconciliation and other advanced features not mentioned above.

Some facts about the extended demo data:

* 76 new Customers and 32 Ship-to Addresses have been added.
* 11,000+ Sales Orders and 800+ Purchase Orders have been processed.
* 88,000 G/L Entries have been added.
* 32,000 Item Ledger Entries have been added.
* 2.4 million records have been added, the original demo company had 61210 records.

 

Related Links

Technorati Tags: , , ,

Posted in Dynamics NAV / Navision | Tagged , , , | Leave a comment

Error: You do not have permission to read the table

Dynamics NAV permissions can be either a very simple topic (if you need to add a table permissions to existing security setup), or a very complex one (if you need to create security roles/permissions from scratch for the first time).

In case of missing Dynamics NAV permissions, users will be getting error messages saying “You do not have permission to read/modify … table”:
Permissions - Error - You do not have permission to read the table

And it is quite easy to resolve such issue. All you need to do, is –
1) find which roles already have this permission and
2) add the missing role to user roles.

Find which roles already have this permission.

Click Tools > Security > Roles.
Permissions - Tools - Security - Roles

Click Role > Permissions.
Permissions - Role - Permissions

Click Show All (or Shift+Ctrl+F7).
Permissions - Show All

Click on Object Name column, then click Field Filter (or F7)
Permissions - Field Filter

and enter the table name (in our example, it was General Ledger Setup)
Permissions - Filter on General Ledger Setup

This will show us a screen of all permissions/roles where table has been used. You will notice, that ROLE column is not visible by default, but we can add it by right-clicking on the “Object Type” column, and clicking on Show Column
Permissions - Show Column

Click on “Role ID” to put a checkmark (to select the field) and
Permissions - Click on Role ID

click OK to come back to the list of permissions.
Permissions - Role List

So, you have found out which roles already have the permission to read “General Ledger Setup” table. Now, we need to add the missing role for the user who was getting the error message.

Add the missing role to user roles.
Click Tools > Security > Database Logins (or Windows Logins)
Permissions - Tools - Security - Database Logins

Find your user who reported that he is getting permissions error. Click Roles.
Permissions - Database Login USER1

Add the missing role. In this example, User1 had only 1 role, and did not have ALL role, so we will add “ALL” to user roles. Please note, that every user you create in Dynamics NAV, should have ALL role added to their security settings.
Permissions - Add Role ALL

After adding missing roles, click Tools > Security > Synchronize All Logins
Permissions - Tools - Security - Synchronize All Logins

and ask user to try running through the same functionality again, to see if permission error issue has been fixed.

Technorati Tags: , , , ,

Posted in Dynamics NAV / Navision, errors | Tagged , , , , | 1 Comment

Error: Item Entry Relation Item Entry No. 0 does not exist

You must love Dynamics NAV error messages! Once in a while (yes, I am using this expression again!) you get error message in Dynamics NAV which does not make any sense and it does not seem to be related to what you were doing. For example, let’s take error message “Item Entry Relation Item Entry No. 0 does not exist“:

Item Entry Relation Item Entry No 0 does not exist

Could you guess what I (or your accountant) was doing in Dynamics NAV when the error message was displayed? Well, neither could I (at least, I could not untill a few days ago, when I decided to troubleshoot the issue further and to find out more about it).

But, before you trying anything smart (or not), I would suggest to check Item Tracking Lines (yes, regardless, of what document you are trying to post, Item Tracking Lines could be causing this error message!):

1. Move down the error message, in order to see on which line error message originates.
2. Go to that purchase line and click Line > Item Tracking Lines.
Line - Item Tracking Lines
3. Check if there are any values in “Undefined” column on the header (these would be caused by undefined “Qty. to Invoice (Base)” field values).
Item Tracking Lines - Undefined
4. Define “Qty. to Invoice (Base)” fields (this will transfer values from “Undefined” column to “Item Tracking” column on the header).
Item Tracking Lines - Defined
5. Click ESC to go back to document and try invoicing it.

Result!

Technorati Tags: , , , ,

Posted in Dynamics NAV / Navision, errors | Tagged , , , , | 7 Comments