Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
confident119
Starting Member
12 Posts |
 Posted - 2011-02-07 : 18:15:36
|
| we have moved the sql server 2008 to different domain, none of the domain users able logon to sql. Error with below message in log file2011-02-07 16:04:50.18 Logon Error: 18456, Severity: 14, State: 11.2011-02-07 16:04:50.18 Logon Login failed for user 'ADom\kuser'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]2011-02-07 16:05:50.78 Logon Error: 18456, Severity: 14, State: 11.2011-02-07 16:05:50.78 Logon Login failed for user 'ADom\kuser'. with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]i checked the setspn -l command, sql server is registered with new domain name and sql port. Unable login to SSMS run as administrationunfortunately we lost the SA password also. All the sql server services running under local system account and also tried with change to network service account.i tried to restart the sql server in single user mode and error with below message2011-02-07 17:39:10.22 Server Error: 17058, Severity: 16, State: 1.2011-02-07 17:39:10.22 Server initerrlog: Could not open error log file ''. Operating system error = 3(failed to retrieve text for this error. Reason: 15105).Any solution please, with out reinstall? Appreciate your reply. |
|
|
|
|
|
Reason: Token-based server access validation faile