jwcolby
jwcolby at colbyconsulting.com
Thu Dec 17 09:15:16 CST 2009
LOL. I found those workarounds and typed in exactly what they said to type in but it didn't work. There is a part of that command that went something like <somethinghere.Administrator> or something similar, which I believe was telling me to replace what was between the < > with the ACTUAL user name, which I did not know. In the end I did an uninstall and then a reinstall. As you can imagine, for me that isn't the biggest problem in the world because my setup is so basic. The biggest impact is simply that I had to go setup the server instance with the amount of RAM, CPU binding and such, as well as reconnect all of the databases. I appear to be back up and running, though I will probably find issues with trying to connect from another machine (surface area IIRC), small stuff like that. As of this morning I had created another 200 indexes on the table from hell, with about 150 left to go. John W. Colby www.ColbyConsulting.com Martin Reid wrote: > John > > Not much use to you now but its a know issue not very well know but know. There is a work around using the command line. The SA account is hard coded into some areas of the upgrade script > > martin > > > Martin WP Reid > Information Services > The Library at Queen's > Tel : 02890976174 > Email : mwp.reid at qub.ac.uk > Sharepoint Training Portal > ________________________________________ > From: dba-sqlserver-bounces at databaseadvisors.com [dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby [jwcolby at colbyconsulting.com] > Sent: 16 December 2009 22:03 > To: Discussion concerning MS SQL Server > Subject: Re: [dba-SQLServer] Trials and tribulations - Install of SQL Server 2008 > > Holding my breath... it apears that the clean install is going to go just fine. > > I didn't particularly want to do a clean install, but when do we ever get what we want? > > > > John W. Colby > www.ColbyConsulting.com > > > Mike Mattys wrote: >> Hi John, >> >> I can't tell if this will help but I did at one point post this link >> http://www.sqldbatips.com/showarticle.asp?ID=46 >> This allows you to set the active instance of SQL >> I often can have 4 versions alive on my laptop at the same time >> >> Also, note that SQL Mgmt Studio 2005 had to be uninstalled in order >> to install the 2008 version. >> >> - >> Michael R Mattys >> MapPoint and Database Dev >> www.mattysconsulting.com >> - >> >> ----- Original Message ----- >> From: "jwcolby" <jwcolby at colbyconsulting.com> >> To: "Dba-Sqlserver" <dba-sqlserver at databaseadvisors.com> >> Sent: Wednesday, December 16, 2009 4:40 PM >> Subject: [dba-SQLServer] Trials and tribulations - Install of SQL Server >> 2008 >> >> >>> What a pita this is. Two failures. >>> >>> I had renamed the sa account and the install failed IN THE MIDDLE because >>> somewhere along the line >>> it needed to use that user in the install process. You would think they >>> would check for that user >>> BEFORE starting the upgrade. >>> >>> Then the Visual Studio install of the compact edition is named something >>> that throws the SQL Server >>> 2008 install for a loop. >>> >>> It turns out that the "sa user missing" was just insurmountable. I was >>> apparently supposed to know >>> what the sa had been renamed to, but I didn't use that account and so had >>> no clue. I ended up just >>> deleting sql server entirely and started from scratch. Which is a royal >>> pita because I had done >>> some major tweaking to get the old "server hangs" issue to go away. I >>> THINK I MIGHT know what to >>> tweak if I ever get this thing to install correctly. >>> >>> 5 hours later and I am just finishing the uninstall and beginning a new >>> install. >>> >>> I do so love this job sometimes. >>> >>> -- >>> John W. Colby >>> 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 > >