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

Francisco Tapia fhtapia at gmail.com
Tue Jan 25 18:17:01 CST 2011


Had a weird issue with a db from an operating system we use here, the
db is 2005 express my coworker loaded the ss2008 management studio and
he was unable to manage the db, he then installed ss2005 and all went
well.

I hadn't ran into that issue, just curious if you had a similar issue...

Sent from my mobile

On Jan 25, 2011, at 4:08 PM, jwcolby <jwcolby at colbyconsulting.com> wrote:

> 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
>>
>>
> _______________________________________________
> 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