Change SQL Server Service Accounts with Powershell
If you need to change multiple SQL Server Services accounts across your environment, Powershell can do that for you.
2016-02-24 (first published: 2016-02-19)
4,130 reads
SQL Server Service Accounts
SQL server, SMS, and BUILTIN\Administrator
Hi,We have installed SMS on SQL server2000.After the install, as usual, I removed BUILTIN\Administrators from the SQL server and ... SMS failed to connect to SQL Server.I found Microsoft TechNet article( http://www.microsoft.com/technet/prodtechnol/sms/sms2003/security/spsecsms03/spsec_10.mspx that describes how to remove BUILTIN\Administrators with SMS:exec sp_grantlogin '<computer account>' exec sp_changedbowner '<computer account>' exec sp_grantlogin 'NT AUTHORITY\SYSTEM' exec sp_addrolemember 'db_owner', 'NT AUTHORITY\SYSTEM' exec […]
2004-09-21
27 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers