今天收到一封信,是从ATOS数据库服务器代理那儿发来的,说发现服务器运行有错误:
The job failed. Unable to determine if the owner (域\用户) of job Replication agents checkup has server access (reason: Could not obtain information about Windows NT group/user '域\用户', error code 0x5. [SQLSTATE 42000] (Error 15404)).
I did not find any login by the name 域\用户 on the server, but there was user on database PVTxxxx05 by the same name and it mapped on to login mySQLLOGINNAME which had dbo rights on the database.
The error [SQLSTATE 42000] (Error 15404) most likely means the machine account doesn't have permission to query the Active directory, cause generally the local service does not have any rights to query / check the identity of the connecting user.
Changing the job owner to sa might solve the issue.
Kindly look into it and suggest on it.
家里的服务器安装的WINDOWS 2008一直只是做为文件共享服务使用,这几天心血来潮想装个ACTIVE DIRECTORY来玩玩,安装完毕后新添用户时,却被报错说密码不符安全策略.安全当然重要,不过在自己家里,这个策略对自己无所谓,对老婆孩子老人来说就太麻烦了,去掉比较好.
可是进入”本地安全策略”进行管理时,发现密码策略已经被锁定,无法更改.
经过查阅资料,在此情况下要改密码策略的过程如下:
1. 进入组策略管理
2. 右键点击/编辑Default Domain Policy
3. 在这里, 可以对密码复杂性要求进行禁用.
4. 禁用并确定后, 此策略并没有被立即应用, 还要运行一下gpupdate /force 应用一下方能生效
5. 可以看到,当组策略管理器中对密码策略都取消定义后,本地密码策略即可以被更改,在本地安全策略中随意简化密码约束.
