Martin Reid
mwp.reid at qub.ac.uk
Thu Dec 17 02:32:57 CST 2009
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