October 8, 2007 at 4:39 pm
I have SQLExpress installed on local box along with VS2005. I then attempted to install SQL2005 components (SSMS, BOL, etc..) so this box can access dedicated SQL 2005 server. It seems like I need to unistall Express on local box. Prefer to keep it (Express on local machine). Is this possible, or should I just uninstall express.
-Thanks
October 8, 2007 at 5:21 pm
You should be able to install components with Express there. Are you getting an error?
October 8, 2007 at 5:44 pm
The error message I get is:
Error Message for Native SQL Client:
"Installation of Microsoft SQL Server Native Client failed because a higher version already exists on the machine. To proceed, unistall the higher version and then run Microsoft SQL server Native Client Setup again."
October 8, 2007 at 10:14 pm
Ah, that stinks. Perhaps you can uninstall the SQL Native Client only? Not sure if that's separate with Express.
October 10, 2007 at 1:04 pm
I ran into the same problem since the version number for SQL express is higher than the original SQL 2005 install. To get SQL Server 2005 Server componenets to install you will need to uninstall SQL Express and go into the system registry and manually delete the registry entries for SQL Express HKEY_Local_Machine\Software\Microsoft\SQL Server and MSSQLClient. After this and a reboot I could get the Server components to install. I still couldn't get SSMS to install properly. After 6 months I finally had the IT dept. rebuild the machine completely and I was able to restore the databases with the full install of SQL 2005
October 10, 2007 at 1:32 pm
Am I missing something - SQLExpress has alerady installed the Native client components on your machine - why are you needing to reinstall them? BOL and SQLNative client are from what I know of them the same, no matter what install you use.
that error message is likely due to using a SQL2005 (no patch) disk to install, while SQLExpress on your own machine is already patched up to SP1 or 2. If you had slip-streamed version of SQL 2005 SP2, I don't imagine you would not be seeing that error.
Native Client setup is a separate installation item in my add/remove here - so is SSMSE. The only thing looks to me to be needing uninstall/reinstall would likely be SSMS.
If it still does whine at you, then yes - uninstall all SQLExpress components, then install SQL2005 client components, and then SQL Express again. THEN patch.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
October 10, 2007 at 7:48 pm
I believe you have assessed my situation correctly.
My goal is to install SSMS onto my local box but can't due to my non-patched components (from a Developers SQL2005 CD) onto a local box that already has a patched SQLExpress. Uninstalling/re-installing SQLExpress and its patches is a little risky right now. I have Microsoft Office Accountant install which also uses SQLexpress. I am remoting into server box to use SSMS, its ugly but it works.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply