Howto change SQL serevr startup options using SQL SMO

Question

Post reply

Howto change SQL serevr startup options using SQL SMO

aashish.lg

SSC Veteran

Points: 287
More actions
June 27, 2015 at 9:37 am

#301982

I would to change the SQL service start up params from my C# application,without touching any reg settings from my code.
SQL 2014 SDK has a dll named as "Microsoft.sqlserver.sqlwmimanagement.dll" which has SMO.WMI.Service class, by which we can modify the params.
It is working fine on my machine which has SQL 2014.
But when I take same application along with SQL 2014 SDK dll to new machine which has SQL 2012 installed, then I am getting an error saying that "WMI provider is not available on this machine".
Looks like this dll(specially SMO.WMI.Service class) is not backward compatible.
Please suggest any T-SQL command or any other way by which we can change the start up params which will be persistent.
Regards
Ashish

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

JManuelN SSCommitted Points: 1708 More actions · Answer 1

Hi,

I am not an expert so sorry if I mislead you. Did you check the reference on the BOL for this version?

Microsoft.SqlServer.Management.Smo.Wmi.ServerInstance

https://technet.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.wmi.serverinstance(v=sql.110).aspx

Managing Services and Network Settings by Using WMI Provider

https://technet.microsoft.com/en-us/library/ms162567(v=sql.110).aspx

I hope that helps

aashish.lg SSC Veteran Points: 287 More actions · Answer 2

I am sorry but both the links which you have suggested me above uses smo.wmi, which is not backward compatible. This is what the actual problem which I am facing.

Anyways thanks for your response.

JManuelN SSCommitted Points: 1708 More actions · Answer 3

Hi,

Could it be possible that the errors you are getting should be related to some WMI configuration issue rather than a compatibility issue? The links I posted before are explicit for SQL Server 2012.

I found this post with similar issues.

http://dbaspot.com/sqlserver-faq/471186-sql-server-configuration-wmi-provider-error.html

Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"

https://support2.microsoft.com/default.aspx?scid=kb%3bEN-US%3b956013