This recipe shows how you can create a SQL login using PowerShell and SMO.
For this recipe, we will create a SQL login called eric. Here's the T-SQL equivalent of what we are trying to accomplish:
CREATE LOGIN [eric] WITH PASSWORD=N'YourSuperStrongPassword', CHECK_EXPIRATION=OFF GO
These are the steps to create a login:
Open PowerShell ISE as an administrator.
Import the
SQLPSmodule and create a new SMO Server Object as follows:#import SQL Server module Import-Module SQLPS -DisableNameChecking #replace this with your instance name $instanceName = "localhost" $server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName
Add the following script and run:
$loginName = "eric" #for our recipe #drop login if it exists if ($server.Logins.Contains($loginName)) { $server.Logins[$loginName].Drop() } $login = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Login -ArgumentList $server, $loginName #specify SQL...