SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Theophilus

Add to Technorati Favorites Add to Google
Browse by Tag : SQL Server 2008 (RSS)

First Uninstall / Second Install of 2008 RC0

By David Benoit in Theophilus | 06-18-2008 5:37 PM | Categories: Filed under:
Rating: (not yet rated) Rate this |  Discuss | 2,133 Reads | 119 Reads in Last 30 Days |no comments

Well, I am now on my second install of RC0 on my laptop. I wish it was in another location but things didn't work out that way. Ultimately I was very impressed with the way things were going up until today when I had an odd occurrence where somehow in the process of setting up a replication test between a 2005 instance (on my laptop as well) and the 2008 instance I dropped all my logins except one that I had created for a linked server. Everything was gone including NT Authority\SYSTEM and in the process sa was set to disabled. Makes it pretty hard to change things around when that happens. I can't even begin to imagine what I could have done that would have set sa as disabled but, there it was. So, having no access to alter anything within the instance as the login that I created for the linked server had minimal permissions to a specific database, I went ahead and did the uninstall / reinstall.

 I was able to uninstall / reinstall successfully and all is now well again. A bit more time at it than I cared for though and I still haven't had the time to get to the replication testing I wanted to accomplish. Maybe tomorrow.....

One side note to this, SQL Server 2008 install / uninstall process is MUCH better than that in SQL Server 2005. This alone may be enough reason for an upgrade. : )

 Screenshot