Integration to AD login broke when we recovered the AD
pdj
Member Posts: 643
We have had a server crash with our domain controller, so we had to restore the server and recover the AD from tape backup. Now we even have a backup domain controller ;-) Everything seems to work ok, except for our SQL servers. They somehow seem to have “lost” the trusted connection to the AD. We can still login to our NAV databases with Windows Authentication, but the Windows Logins forms are not showing the login ids. Instead it shows the SID in both the SID column and the ID column. Except for the current user, where it shows it correctly as <domain>\<userid>.
We also can’t create new users, unless we login using a DB login, and then insert the current user as a Windows User. We can use F6 in the ID column, and it shows a list of Windows users and groups. But when I pick one, it just stays in the ID column with the SID of the selected user, and say “Unknown Windows user.” So we are not panicking (yet) but this is rather annoying and I guess some trusts between the servers are gone.
The only problems I can find I the Event Log which might be related are theses entries:
“The configuration information of the performance library "C:\WINDOWS\system32\perf-MSSQL$SQL2008-sqlctr10.0.1600.22.dll" for the "MSSQL$SQL2008" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted.”
It guides me to use this command: “lodctr/t servicename” to fix the problem. However; I couldn’t get lodctr to load directly from the service. Then I found a guide to find the prober files directly, so now they are updated for one of the SQL servers, but the AD problem is not fixed.
We are using a mix of SQL2005 and SQL2008 servers, and clients are NAV4SP3, NAV5SP1 and NAV6SP1. The problem is the same all across…
Does anyone have any ideas?
Thanks in advance…
We also can’t create new users, unless we login using a DB login, and then insert the current user as a Windows User. We can use F6 in the ID column, and it shows a list of Windows users and groups. But when I pick one, it just stays in the ID column with the SID of the selected user, and say “Unknown Windows user.” So we are not panicking (yet) but this is rather annoying and I guess some trusts between the servers are gone.
The only problems I can find I the Event Log which might be related are theses entries:
“The configuration information of the performance library "C:\WINDOWS\system32\perf-MSSQL$SQL2008-sqlctr10.0.1600.22.dll" for the "MSSQL$SQL2008" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted.”
It guides me to use this command: “lodctr/t servicename” to fix the problem. However; I couldn’t get lodctr to load directly from the service. Then I found a guide to find the prober files directly, so now they are updated for one of the SQL servers, but the AD problem is not fixed.
We are using a mix of SQL2005 and SQL2008 servers, and clients are NAV4SP3, NAV5SP1 and NAV6SP1. The problem is the same all across…
Does anyone have any ideas?
Thanks in advance…
Regards
Peter
Peter
0
Comments
-
Have you tried rebooting the SQL Servers since the AD was brought back up. Think SQL Server may have cached some of the AD values...0
-
yes but it did not help.Regards
Peter0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions