February 6, 2011 at 10:49 pm
hi !
I have installed my SQL Server with "windows client admin" and "sa" user names . after 2 month my computer name changed and i forgotten the password of "sa" .
Now i see the server of SQL in login window and can select it. but i cant login by windows authentication.
How i can login to SQL Server or what is the best solution?
thanks.
mannai
February 28, 2011 at 3:35 pm
By default the local Windows security group "BUILTIN\Administrators" is part of the sysadmin Server Role. Check if your login is part of the local "Administrators" group. If it is not then can you get it added or can you log in as someone that is part of that group?
If the local instance was modified from its default config and "BUILTIN\Administrators" is no longer part of the sysadmin Server Role, and you cannot get the sa login, then I think you will need to uninstall the instance and start over from scratch.
All is not lost though...you will still be able to salvage the databases attached to the instance. If you need help with that let us know.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply