TechOps1
asked on
Powershell script to create users in SQL Server Management Studio
We have standalone servers that are not a part of the domain with SQL Server 2012 installed. We have created a number of local user accounts on the server, and now we need to create those same users in SQL Server Management Studio with the sysadmin Server Role.
The original accounts that were created on the server were done so using a Powershell script so the account creation will be consistent across multiple standalone servers.
Is there a way through powershell this can be done?
The original accounts that were created on the server were done so using a Powershell script so the account creation will be consistent across multiple standalone servers.
Is there a way through powershell this can be done?
Did you checked this: https://cmatskas.com/create-sql-login-with-powershell-and-t-sql/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
TechOps1, do you still need help with this question?
ASKER
Thank you kulboy
Welcome TechOps1!