Archive for June, 2010

SQL 2008 Sillyness

In server 2008 (and probably other versions as well) if you need to add a user or group local to the server as an SQL user, you get the following lovely error: “Error 15401: Windows NT user or group ‘%s’ not found. Check the name again. ” Domain accounts add fine, but not local accounts. Well, SOME local accounts add fine but other ones don’t Now isn’t that silly? Turns out that any predefined local accounts or groups like “administrators” or “system” need to use the domain “BUILTIN” and not the server name as the domain preface. Problem solv-ed.


No Comments