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

Arthur Fuller fuller.artful at gmail.com
Tue Jan 25 17:23:25 CST 2011


ROFL! I guess I'd call this SQL Suicide. (Can't wipe the grin off my face,
sorry:)
Arthur

On Sun, Jan 23, 2011 at 12:07 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> Well this is annoying.  It seems I deleted the user that I created the
> instance of sql server with SSMS Security Logins object.  Now I have no
> authority to do anything.
>
> Is there a way to put it back in?  I tried to create it over again but I
> cannot seem to do so.  In fact I recreated the vmDev\jwcolby user but I
> can't even see the properties of that user, even though that is me...
>
> I think...
>
> Am I just screwed?
>
> Can I even delete the server instance?
>
> Luckily I wasn't all that far along in defining databases but I have
> probably a dozen hours involved in two specific databases.
>
> --
> John W. Colby
> www.ColbyConsulting.com <http://www.colbyconsulting.com/>
> _______________________________________________
> 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