Jump to content


Recommended Posts

I always enabled Names Pipes. However, if you have an open ticket with MS, I strongly recommend that you don't continue with troubleshooting in the forums. Items I guess might conflict with item CSS suggest. This will increase the time it takes to solve the problem and may cause new problems. 

Share this post


Link to post
Share on other sites


issue got resolved after solving SQL server configuration manager issues.

 

Open a command prompt as administrator

Navigate to your SQL version’s shared directory (cd <version path>):

SQL 2008:  C:\Program Files (x86)\Microsoft SQL Server\90\Shared\
SQL 2008 R2:  C:\Program Files (x86)\Microsoft SQL Server\100\Shared\
SQL 2012:  C:\Program Files (x86)\Microsoft SQL Server\110\Shared\
SQL 2014:  C:\Program Files (x86)\Microsoft SQL Server\120\Shared\

Then run the following command:

mofcomp sqlmgmproviderxpsp2up.mof

1802 Upgrade successfully completed.

  • Thanks 1

Share this post


Link to post
Share on other sites

thanks for posting the solution, your SQL server configuration was well messed up though.

Share this post


Link to post
Share on other sites

did Microsoft CSS explain why they thought your SQL was in such a bad state ?

Share this post


Link to post
Share on other sites
26 minutes ago, amit paul said:

Unfortunately I tried all troubleshooting however CSS failed to provide any possible solution after two days troubleshooting.

Make sure that CSS credits your account for the failed case. 

Share this post


Link to post
Share on other sites
4 hours ago, amit paul said:

issue got resolved after solving SQL server configuration manager issues.

 

Open a command prompt as administrator

Navigate to your SQL version’s shared directory (cd <version path>):

SQL 2008:  C:\Program Files (x86)\Microsoft SQL Server\90\Shared\
SQL 2008 R2:  C:\Program Files (x86)\Microsoft SQL Server\100\Shared\
SQL 2012:  C:\Program Files (x86)\Microsoft SQL Server\110\Shared\
SQL 2014:  C:\Program Files (x86)\Microsoft SQL Server\120\Shared\

Then run the following command:

mofcomp sqlmgmproviderxpsp2up.mof

1802 Upgrade successfully completed.

The funning is I have a rough draft blog post mostly written on how to install the SQL WMI providers. The WMI providers seem to be removed when you applied some of the SQL SU. It wasn't something I thought of when you posted here. 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...