SQL Server Agent Scheduled Job Error 0x6ba


hi,

does know caused error, , more importantly can prevent error occuring again?

date  10/02/2010 18:30:00
log  job history (dataqualityhist)

step id  0
server  myserver
job name  dataqualityhist
step name  (job outcome)
duration  00:00:11
sql severity  0
sql message id  0
operator emailed  
operator net sent  
operator paged  
retries attempted  0

message
the job failed.  unable determine if owner (mydomain\mylogin) of job dataqualityhist has server access (reason: not obtain information windows nt group/user 'mydomain\mylogin', error code 0x6ba. [sqlstate 42000] (error 15404)).

thanks,

kieran.

if have found of posts helpful please vote them helpful. kieran wood pgd softdev (open), mbcs http://uk.linkedin.com/in/bileeds

this error sometime happens when sql server not able connect / interact ad , domain username / password validated. might due various networking reasons , can happen intermittently (like 2 sec once in everyday) , have seen error years company’s network poor , decided change owner sql server logins sa.

 

if still keen retain owner domain user, talk network admins , troubleshoot intermittent connectivity issue exact time job has failed.

thanks, leks


SQL Server  >  SQL Server Tools



Comments

Post a Comment

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Image
hi, i have situation want color label on vertical axis of graph depending on condition. when values positive color black , when negative color red. i tried following condition but not working.   =iif(fields!myfield.value < 0 , "red", "black") i know there few threads mentioning feature not supported in ssrs 2008 wanted know if adddressed in ssrs 2012 or later? thanks , regards, oliver d'mello hi oliver, according description, want use expression specify different color axis labels based on values in chart. as tested in our environment, when apply condition in expression give dynamic color axis labels, color setting applies labels based on condition. issue happens in both sql server 2012 , 2014. please refer screenshots below: in scenario, recommend submit issue microsoft connect @ link https://connect.microsoft.com/sqlserver/feedback . connect site serve connecting point between , microsoft, , large community , microsoft intera
Read more

Register with Power BI failed

hi all, i've running local report server , want configure power bi integration. sign in azure active directory , registering power bi clientapp validated, fails following error: microsoft.reportingservices.wmiprovider.wmiproviderexception: unknown error has occurred in wmi provider. error code 80131500  ---> system.exception: exception of type 'system.exception' thrown.    --- end of inner exception stack trace ---    at microsoft.reportingservices.wmiprovider.rswmiadmin.throwonerror(managementbaseobject mo)    at microsoft.reportingservices.wmiprovider.rswmiadmin.savepowerbiinformation(string clientid, string clientsecret, string appobjectid, string tenantname, string tenantid, string resourceurl, string authurl, string tokenurl, string redirecturls)    at reportservicesconfigui.wmiprovider.rsreportserveradmin.savepowerbiinformation(powerbiappconfiguration appconfig) i tried sql server agent solution  ( https://social.msdn.microsoft.com/forums/en-us/58
Read more

SSISDBBackup.bak error. Trying to create a catalog on Mircosoft Windows 2012 Server

Image
hello, i'm, trying create integration services catalogs folder on server , right click(for reason enable clr integration button is in grey color), , reason ssisdbbackup.bak missing in pass( microsoft windows 2012 server clustered server): d:\program files\microsoft sql server\110\dts\binn i tried reinstall integration services on server , out success if have ideas it'll great. best regads daniel hi daniel, the issue may occur due factor sql server integration services not cluster-aware , doesn’t support failover 1 cluster node another. address issue, can copy ssisdbbackup.bak file node current node, , recreate ssisdb catalog. reference: http://blog.patricknielsen.net/2012/12/ssis-catalog-creation-cprogram.html   regards, mike yin technet community support SQL Server  > 
Read more