Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
whichedge
Starting Member
3 Posts |
 Posted - 2009-05-22 : 06:27:52
|
| Hi all, please can someone offer me some giudance.I have SQL 2005 standard installed on a Vista Ultimate box, with a second named instance installed. The installation was from an old DVD with no services packs, I do have a disk with SP1 on it. So after installing the default instance and a named instance, I ran the SP1 update and then collected the remaining updates from the Windows update service. Everything is fine no prblems.However I now need to remove the second named instance. So I went to Add/Remove programs selected the SQL 2005 uninstall and followed the instructions, selecting only the named instance that I needed to remove. Everything seems to go well until I tried to connect to the default instance then everything went pear shaped on me. Nothing could connect to the default instance, the error message was long and unfortunately I didn't make a note of it, but the jist of it was that the server name wasn't recognised, or there was a problem with the connection. I even uninstalled the whole shooting match and tried to re-install just the default instance but that failed with the same error message.Fortunately I had a disk image so I have restored the box to the state prior to uninstalling the instance, and am now looking for some giudance to remove the second named instance. I have tried everything that I can think of. The second named instance cannot be removed via Add/Remove as this renders the default instance in operable.I have done some rooting around and lots of thinking, can someone tell me if I am on the right tracks here.When I installed the updates for SQL 2005 via the Windows update service, the update makes changes to both the system files and the application files, correct?When I uninstalled the second instance the uninstall was performed by the 'Microsoft Server Setup Support Files', correct?Now from what I have read these files seem to very import in the uninstall process, so could it be that these files are only complatible with the original installation (with no service packs added) and that during the uninstall of the second instance they over wrote some of the Service Pack files, which could, or did make it impossible to connect to the server, after uninstalling the second instance.If this is indeed the case can these files be Removed safely with the Windows 'Add/Remove' function and where can I download new ones that will work with SP3?Thanks in advance |
|
|
whichedge
Starting Member
3 Posts |
Posted - 2009-05-22 : 08:10:11
|
| Sorted now - had to reregister dmo after uninstalling instance. |
 |
|
|
kishore_pen
Starting Member
49 Posts |
Posted - 2009-05-22 : 08:28:24
|
| use "ARPWrapper.exe", found in "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap". for more info see SQL BOL. |
|
|
|
|
|
|
|
|
Uninstalling a second instance problems