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

Stuart McLachlan stuart at lexacorp.com.pg
Sun Jan 23 07:33:41 CST 2011


I didn't mean a backup in SQL Server, that's why I said shut down the service first.  Just copy 
the database files somewhere else for safety.

-- 
Stuart

On 23 Jan 2011 at 8:01, jwcolby wrote:

> 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.
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 






More information about the dba-SQLServer mailing list