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 |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2004-09-21 : 11:11:34
|
| We have a SQL Server 2000 Server that was recently migrated to AD.When I run the xp_logininfo 'US\jpotucek' (new AD Domain) It returns this: Server: Msg 8198, Level 16, State 34, Procedure xp_logininfo, Line 58Could not obtain information about Windows NT group/user 'us\jpotucek'.If I try to run a job where the owner is a Windows Authenticated SQL Server login from the New AD Domain, I get this error: Unable to determine if the owner (US\jpotucek) of job EmployeeDump has server access (reason: Could not obtain information about Windows NT group/user 'US\jpotucek'. [SQLSTATE 42000] (Error 8198)).[/b]I CAN run a query against my Domain Account from the old NT Domain (the Domain that this Server was migrated from) I have already Changed the Accounts that starts the SQL Server Services to a Domain Account in the new AD Domain to see if that would help.I found this KB article (and several others), not much help!KB Article 834124Any Ideas?? Also, can someone tell me when I run the xp_loginingo Query, is the SQL Server returning results or is the Server itself being queried and returning results? In other words, is there a way to script out exactly what the xp_logininfo is doing?? |
|
|
|
|
|
Migrating to AD (Active Directory)