question

I am trying to use powershell to connect to ReplicationServer and backup replication.The SQL Server Editition is 2008 SP2. It works fine with windows authentication but when I try to connect with sql authentication it shows error New-Object : Cannot find an overload for "ReplicationServer" and the argument count: "1". At .....\Experiment.ps1:34 char:74 + [Microsoft.SqlServer.Replication.ReplicationServer]$var_server=new-object <<<< ("Microsoft.SqlServer.Replication.ReplicationServer") $con + CategoryInfo : InvalidOperation: (:) [New-Object], MethodException + FullyQualifiedErrorId : ConstructorInvokedThrowException,Microsoft.PowerShell.Commands.NewObjectCommand Here is the code snippet [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo") [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Replication") | out-null [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Rmo") | out-null $script:servername="server1" $loginname="test" $passcode="test" [Microsoft.SqlServer.Management.Common.ServerConnection]$con=new-object ("Microsoft.SqlServer.Management.Common.ServerConnection") $servername,$loginname,$passcode [Microsoft.SqlServer.Replication.ReplicationServer]$var_server=new-object ("Microsoft.SqlServer.Replication.ReplicationServer") $con foreach($replicateddatabase in $var_server.ReplicationDatabases) { ................. } Any help is highly appreciated.