This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.
FSMainFolder is a tool I developed to create a folder structure in a controlled and standardized way.
1) Download the command line version of SetACL (https://helgeklein.com/download) and extract to a folder on your file server. The tool will be updated to the use and include the COM version if the author allows me.
2) Download FSMainFolder tool (http://blog.ittelligence.com/wp-content/uploads/2018/06/FSMainFolder.zip) and extract to a folder on your file server.
3) Run Configurator.exe (Configurator Editor).
a) On the Encrypt tab, enter the password for the account that will be performing the cleanup task. Encrypt it with key 9s7P353RJAUrHSVe and record the encrypted password.
b) On the Settings tab, enter the distinguished name, fully qualified domain name, NetBIOS, and username and the encrypted password recorded in step 3a.
c) Specify option for how to name groups. This includes the organizational unit, prefix, suffix and tiebreaker length.
d) Specify the path where you extracted SetACL.exe to.
Command parameters are supplied to control the main folder creation process
FSMainFolder.exe PARENTFOLDER MAINFOLDERNAME MAINFOLDERDESCRIPTION MAINFOLDEROWNER ROOTFOLDER CHANGEGROUP EXECUTEGROUP
For example, the following will create a main folder D:\CorporateData\Sales, a change, and a read-only group and assign the correct permissions. The groups created will have JDOE as the owner and the description will be "This folder is assigned to the Sales Team"
FSMainFolder.exe "D:\CorporateData" Sales "This folder is assigned to the Sales Team" JDOE TRUE TRUE TRUE
I hope you found this tutorial useful. You are encouraged to ask questions, report any bugs or make any other comments about it below.
Note: If you need further "Support" about this topic, please consider using the Ask a Question feature of Experts Exchange. I monitor questions asked and would be pleased to provide any additional support required in questions asked in this manner, along with other EE experts...
Please do not forget to press the "Thumb's Up" button if you think this article was helpful and valuable for EE members.
It also provides me with positive feedback. Thank you!