Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
Weird SID in Windows Login (can't get rid of it)
jwilder
Member Posts: 263
We had a user with user domain\userid = test\jtest and sid = ending in-2875.
The user jtest was completely deleted from Active Directory and then reset up in active directory with a different user id. The new id is test\jtest1 and sid = ending in -2908.
I reset up the user id in NAV and it pulled in the correct sid (2908) in NAV. But in SQL the login is still pointing toward the original sid ending in -2875. We have gone through the set up a few times and have completely removed the user out of NAV, SQL Logins, SQL Database and even the Master Database but as soon as we put the user back in it always pulls the -2875 sid not the -2908 one. We don't even know where the -2875 sid is still stored anymore since it was deleted.
Has anyone ever come across this and what can we do to fix?
The user jtest was completely deleted from Active Directory and then reset up in active directory with a different user id. The new id is test\jtest1 and sid = ending in -2908.
I reset up the user id in NAV and it pulled in the correct sid (2908) in NAV. But in SQL the login is still pointing toward the original sid ending in -2875. We have gone through the set up a few times and have completely removed the user out of NAV, SQL Logins, SQL Database and even the Master Database but as soon as we put the user back in it always pulls the -2875 sid not the -2908 one. We don't even know where the -2875 sid is still stored anymore since it was deleted.
Has anyone ever come across this and what can we do to fix?
Jason Wilder
jwilder@stonewallkitchen.com
jwilder@stonewallkitchen.com
0