How to change the SQL Server password programmatically

Every now and the question comes up how to programmatically modify the service account or password of SQL Server. There basically two ways to accomplish this, using SMO, or WMI. This article shows you how to use WMI and VBScript to accomplish this task.   There are a couple of things you need to know….


Starting with SQL Server 2005 WMI with help of Scriptomatic

SQL Server 2005 introduces a new WMI Provider that allows configuration of Services, Client Network Protocols, and Server Protocols. This is a great improvement for DBA that are managing many SQL Servers, as WMI allows you to query and modify SQL Server configuration settings remotely. Now, everyone who has worked with WMI knows it’s not easy…