Hi All
i am new to Sql server, i created a Maintenance task for Backup. when i execute the task i get below error.
Message
[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'Mydomain\Mylogin', error code 0x6e. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
i tried to changing the MSSQLSERVER and SQL SERVER AGENT server built in accounts to 'Local Account', 'Local Services' and 'Network services' but all are giving the same error messages.
i tried changing to Log on as 'This Account' and gave my 'Mydomain\Mylogin' account and password still it failed with same error.
'Mydomain\Mylogin' has Admin rights.
please help
Thanks
Nagananda
View Complete Post