This post is part of “Overview of NAV-specific SQL features for application consultants”. Before you can set up a user in Microsoft Dynamics NAV on SQL Server, you must create the user on SQL Server ...

All right, we are good to go with continuing to create some users on the SQL server. First off, let's take a quick look at the existing users and see how many of the users are sqllogons and which ones ...

This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.

SQL: CREATE USER [<Name>] FOR LOGIN [<Name>] Possible Reason of the Error: In this NAV Version when a new user is created in NAV Database it is also added in Master Database, but when deleting the ...

Ok, for SQL server 2000, ... Yeah, it works but it isn't secure.<BR><BR>Create a local user on that box, call it SQLserviceaccount or SQLadmin or whatever seems appropriate to you.

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...