mibuso.com

Microsoft Business Solutions online community
It is currently Fri Jul 25, 2014 5:37 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: Adding Users in Navision with SQL Database
PostPosted: Tue Dec 06, 2005 10:39 pm 
Offline

Joined: Thu Jul 28, 2005 8:12 pm
Posts: 27
Location: Montreal
Country: Canada (ca)
How do you add new users to Navision if you're using a SQL Backend? Do you add the Users as SQL Users or do you add them inside NAvision?


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 06, 2005 10:53 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 6:37 pm
Posts: 7989
Location: Howell, MI
Country: United States (us)
You need to do both. First you add the SQL user, then you add the user to Navision. Read the intallation guide in the doc folder on the product cd, that explains it better than I can :).

_________________
Daniel Rimmelzwaan
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 07, 2005 8:08 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12433
Location: Brno
Country: Czech Republic (cz)
This is true, if you want to use Database Logins. In this case you need to add the user to the MS SQL for example through Enterprise Manager, after that you are able to add this user into Navision. If you want use Windows Logins, it is not problem and you can add the user only through Navision...

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Wed Dec 07, 2005 2:38 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 6:37 pm
Posts: 7989
Location: Howell, MI
Country: United States (us)
Are you sure about that Kamil? I thought even if you use Windows login you still have to add them to SQL Server before you can use them in Navision.

_________________
Daniel Rimmelzwaan
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 07, 2005 3:25 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12433
Location: Brno
Country: Czech Republic (cz)
Yes, I am 120% sure with this... ;-)

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Fri Dec 09, 2005 9:48 am 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7682
Location: Milan
Country: Italy (it)
kine wrote:
This is true, if you want to use Database Logins. In this case you need to add the user to the MS SQL for example through Enterprise Manager, after that you are able to add this user into Navision. If you want use Windows Logins, it is not problem and you can add the user only through Navision...

What I remember about this, is that it is possible to give SQL-access to a Windows group. So this you have only to do once and then every user of that Windows group has access to SQL.
I tried to see how it is done, but I can't do it on my portable. Probably because I am not connected to a domain-network at the moment.

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 09, 2005 9:57 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12433
Location: Brno
Country: Czech Republic (cz)
Yes, it can be done through security group, but with some limitations:

1) This group must contain the users, not another groups (nested groups will not work)
2) In 4.00 you still need to create account in Navision for each user which will have access to Navision else the user will not be able to login.


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 11 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: