October 22, 2007 at 10:12 am
Don't ask why (becauase I don't know) but a server name was changed. On this server, within SQL Server, there are local users setup as logins.
Lets say, before the computer name was changed from OLDNAME, there was a user named OLDNAME\USER who had sa priviledges and owned jobs/databases.
Now, after the computer name changed to NEWNAME, the login remains OLDNAME\USER.
How do I update this login to reflect the new computer name? When I try to add the login NEWNAME\USER I get the error:
Error 15401: Windows NT user or group not found. Check the name again.
But the user exists and is actually in the local Administrators group.
October 23, 2007 at 1:14 am
Do you give computerName\userName or DomainName\userName?
Just a workaround..just activate your builtin administrator..let us see how it works.
binu john
October 23, 2007 at 5:26 am
Have you tried to recreate the group from the O/S level (via Computer Management).
October 23, 2007 at 7:53 am
The problem was that the SID was the same for the accounts. I ended up changing the database ownership to SA, dropping and recreating the account with the new computer name, and dropping all the old jobs, since they weren't needed anymore - which I was unaware of before. RESOLVED. Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply