Windows PowerShell in SQL Server 2008 Environment, SQL Server PowerShell Provider - Professional SQL Server 2008 Administration with Windows PowerShell - page 255

Figure 11-26
Figure 11-27
Figure 11-28
In order to use SQL Server authentication to access the remote named instance, execute the
Invoke-Sqlcmd cmdlet using the -ServerInstance , -User ,and -Password parameters, as shown here
(see Figure 11-29):
Invoke-Sqlcmd -Query "SELECT @@servername + ': ' + @@version" -ServerInstance
"PowerServer3\SQL2008" -User "sa" -Password "P@ssw0rd"