[dba-SQLServer] Deleted my own user, can't log in

jwcolby jwcolby at colbyconsulting.com
Sun Jan 23 07:01:52 CST 2011


I can't even do a backup.  It gives me a "login failed - error 4064"

John W. Colby
www.ColbyConsulting.com

On 1/23/2011 12:52 AM, Stuart McLachlan wrote:
> When you delete a use and create a new one with the same name, that is NOT the same
> user. It has a different Security ID (SID).
>
> You will need to give rights to the new user all over again.
>
> One solution would be to shut down the SQL Server service, backup the database files then
> create a new instance and attach the databases to it.
>



More information about the dba-SQLServer mailing list