I have a DBA who is getting this error from sql 2012
SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'DOMAIN\USER', error code 0x6e. [SQLSTATE 42000] (ConnIsLoginSysAdmin
This is the error from the applications log on Windows 2008 R2 SP1
Log Name: Application
Date: 5/8/2013 1:00:00 AM
Event ID: 208
Task Category: Job Engine
SQL Server Scheduled Job 'Backup.Transaction Log Backup' (0x73F40EB3D55EFB47A865552850B3A8B7) - Status: Failed - Invoked on: 2013-05-08 01:00:00 - Message: The job failed. Unable to determine if the owner (DOMAIN\USER) of job Backup.Transaction Log Backup has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\USER', error code 0x6e. [SQLSTATE 42000] (Error 15404)).
After further investigation He had updated SLQ 2012 to SP1 on May 7th and added the Hotfix the day after. He did not restarted the server after installing these updates. He did restarted the server on May 10th. When the errors occurred he switched the job from using his account to the account used to run the sqlagent which now works. This used to work before he applied SP1.
Do you have an explanation why this happened in order to give a better explanation to the DBA. Mind you I am not a SQL expert.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days.
Lets' understand the Au…