Windows 2008 Server R2 provides software level support for the network load balancing of various servers like Web Server, Print Server, Database Server etc. The feature of multicast communication has to be resolved by putting an arp entry into the router/switch which ever we are using. The ping to the Virtual IP will not happen by default, unless we put the physical address of the Virtual IP as a static entry in the arp table of the router/switch.
SQLServer Error: 15404, Could not obtain information about Windows NT group/user Error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
If we encounter this error "SQLServer Error: 15404, Could not obtain information about Windows NT group/user Error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)" in SQL Server in which the job fails because of the user account related problem, then we need to take the following steps to make it work: a. Go to SQL Server Agent. b. Then select the job which is giving error and not running successfully. c. Then choose properties and in the General Tab, change the owner to "SA" or any account that has the administrative privileges. The problem will be resolved.
Comments