October 6, 2009 at 12:42 pm
I have a a/p cluster I need to install ssms on (one of the nodes). the SQL server version is sp3. The problem is, once I install client tools and connect to the local instance, I can't access any job properties in the agent. every attempt seems to result in create new job window. When I try to upgrade client components with sp3, the installation fails with a generic error message (just send/don't send report type of message).
I installed ssms on a different system without upgrading client components, and exact same thing keeps happening: whenever you double-click (or select properties) on a job, it opens new job dialog window.
Does anybody have any ideas how I can upgrade client components to sp3?
thanks in advance!
October 6, 2009 at 2:19 pm
I ran into the same issue on a Windows clustered environment. When you apply SP3, it patches the database engine and the client tools for whatever node that you're running the install on. It does NOT patch the client tools on the inactive node. To fix the issue, you're going to need to find a way to get the SP3 patch to install on the inactive node of the cluster. When you run the SP3 install on the inactive node, make sure that you're only patching the client workstation components and not the database engine. That's what I did and it fixed the issue with the job properties not coming up correctly. HTH
October 8, 2009 at 8:16 am
George Parker-378530 (10/6/2009)
I ran into the same issue on a Windows clustered environment. When you apply SP3, it patches the database engine and the client tools for whatever node that you're running the install on. It does NOT patch the client tools on the inactive node. To fix the issue, you're going to need to find a way to get the SP3 patch to install on the inactive node of the cluster. When you run the SP3 install on the inactive node, make sure that you're only patching the client workstation components and not the database engine. That's what I did and it fixed the issue with the job properties not coming up correctly. HTH
thanks, George.
My issue is in that SP3 now won't upgrade client tools after installing them. It fails with a very generic message. I'll try the update again (today) and will post the exact message i'm getting.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply