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

jwcolby jwcolby at colbyconsulting.com
Tue Jan 25 20:54:42 CST 2011


Not specifically.  I did have an issue where I could not install SQL Server 2008 because the server 
was Windows 2000 and it can't use the .net version required.  SQL Server 2005 runs just fine.

John W. Colby
www.ColbyConsulting.com

On 1/25/2011 7:17 PM, Francisco Tapia wrote:
> 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
>>
> _______________________________________________
> 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