September 22, 2008 at 1:17 pm
I've found out that a SQL Server is currently installed on the C: drive with the OS instead of the proper drive. It appears that the Reporting Services and Integration are in the correct place.
Without going through a ton of details about the process I plan to implement in a little over 2 hours to fix this, I have one concern that I'm not sure about.
SQL Server is currently installed to C:\Program Files\Microsoft SQL Server\MSSQL.1\.
The registry hive is created under HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.n for instance-aware components. For example,
* HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.1
The registry also maintains a mapping of instance ID to instance name. Instance ID to instance name mapping is maintained as follows:
* [HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL] "InstanceName"="MSSQL.1"
So...that brings me to my question.
I don't believe a straight uninstall/reinstall will get it for the SQL Server Engine. If MSSQL.1 is still there then and there's already a MSSQL.2 for Reporting Services I'm assuming it will just to MSSQL.3.
Anyone have any insight into covering my bases to help me get home to be with my family a little earlier and make sure I don't have major issues. I believe I'll have most of my bases covered as there aren't a ton of db's on there right now.
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
September 22, 2008 at 4:19 pm
you can do a clean uninstall but it's tricky ( uninstalled 2005 to install 2008 ) What tends to happen is that when you go to re-install it puts in an instance although you don't have a default.
Yes I think you'd possibly need to delete the folders - I'm very wary of making chnages to the regstry.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
September 22, 2008 at 4:23 pm
funny thing is, the registry didn't show the expected entries but the folders did even after uninstall.
I'm in the middle of it now.
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply