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

jwcolby jwcolby at colbyconsulting.com
Tue Jan 25 18:08:04 CST 2011


LOL, yep, pretty darned funny *after* I figured out how to get back in.

;)

John W. Colby
www.ColbyConsulting.com

On 1/25/2011 6:23 PM, Arthur Fuller wrote:
> 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
>>
>>
> _______________________________________________
> 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