Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Nav 4SP3 SQL Server 2005 Logins not working
Methos
Member Posts: 46
Hi.
I have a Navision 4 SP3 database running on SQL server 2005.
I was able to get one user , me ,to log into the database.
Now none of the new users I create in SQL can open the navision database. I Added the users to the Navision Logins and Syncronizing but navision says the users does not exist SQL.
Anny help please?
I have a Navision 4 SP3 database running on SQL server 2005.
I was able to get one user , me ,to log into the database.
Now none of the new users I create in SQL can open the navision database. I Added the users to the Navision Logins and Syncronizing but navision says the users does not exist SQL.
Anny help please?
0
Answers
RIS Plus, LLC
MVP - Business Apps
2) If you are using DB logins, you need to create the users on SQL first and add them PUBLIC rights to the DB. After that you can add them in NAV.
3) If you are using Windows auth. you do not have this problem, it means see point 2... :-)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Not sure if it was that i did not grant the public rights on the DB, pritty sure I did.
Started over, made logins on server, and seperately added users to the DB. added the users to NAV and it syncronized.
Could it maybe have been that I used the mapping from the server logins to add the database to a login?
Thanks for the help.