Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

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
ASKER CERTIFIED SOLUTION
Avatar of MOA81
MOA81
Flag of Jordan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of motioneye

ASKER

Hi MOA81,
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
Avatar of Sham Haque
>>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