November 12, 2015 at 3:20 am
Hi,
Is it true that passwords changed using SQL Server Configuration Manager, SMO, or WMI take affect immediately without restarting the service.
November 12, 2015 at 3:30 am
Yes it's true there's no need to restart the service
https://msdn.microsoft.com/en-GB/library/ms365941.aspx
Although for the agent account on a stand-alone instance of SQL Server, the password takes effect immediately, without restarting SQL Server. On a clustered instance, SQL Server might take the SQL Server resource offline, and require a restart.
November 12, 2015 at 3:45 am
Does this holds true for older versions of SQL Server also like 2012, 2008, 2005.
November 12, 2015 at 3:47 am
From 2005 on-wards yes
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply