motioneye
asked on
error msg ERROR: 8198, SEVERITY: 16, STATE: 24 with sql server permission
Hi,
I'm getting an error as below from sql server:
KingConnect: ERROR: 8198, SEVERITY: 16, STATE: 24 COULD NOT OBTAIN INFORMATION ABOUT WINDOWS NT GROUP/USER 'APKL\BDCTR
and from the sqlserver KB this is the point I found:
State= 24 When the SQL Server engine queried the Windows operating system to retrieve information about a Windows account name, access was denied.
so what is that mean with SQL Server engine ? is it a background sql services or user process
I'm getting an error as below from sql server:
KingConnect: ERROR: 8198, SEVERITY: 16, STATE: 24 COULD NOT OBTAIN INFORMATION ABOUT WINDOWS NT GROUP/USER 'APKL\BDCTR
and from the sqlserver KB this is the point I found:
State= 24 When the SQL Server engine queried the Windows operating system to retrieve information about a Windows account name, access was denied.
so what is that mean with SQL Server engine ? is it a background sql services or user process
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>so what is that mean with SQL Server engine ? is it a background sql services or user process
it's the Windows service running the database process (sqlsrvr.exe)
the error is pointing to a permissions error - see here:
Could not obtain information about Windows NT group/user
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=542041&SiteID=1
it's the Windows service running the database process (sqlsrvr.exe)
the error is pointing to a permissions error - see here:
Could not obtain information about Windows NT group/user
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=542041&SiteID=1
ASKER
Yes I already go thru the KB before submitted the post, but I'm not sure what is that mean with SQL Server engine ? is it a background sql services or user process