i need to make connection to the sql  server which is in different forest for which i have creds how do i make connection to remote sql server and query the database

 (remote sql server = sql24567-000.outerspace.net)

$SQLServer = 'SQL87630004-002.innerspace.net';
$Database = 'origindb';
$SqlQuery = @'
SELECT TOP 1000 [SecretId]
      ,[SecretName]
      ,[SecretType]
      ,[SecretKey]
      ,[FarmId]
      ,[State]
      ,[Scope]
      ,[ObjectId]
      ,[Version]
      ,[CreationTime]
      ,[WinAuth]
  FROM [origindb].[dbo]
   where Name like '%spo%'
'@;

## - Connect to SQL Server using non-SMO class 'System.Data':
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection;
$SqlConnection.ConnectionString = `
"Server = $SQLServer; Database = $Database; Integrated Security = True";

$SqlCmd = New-Object System.Data.SqlClient.SqlCommand;
$SqlCmd.CommandText = $SqlQuery;
$SqlCmd.Connection = $SqlConnection;

## - Extract and build the SQL data object '$DataSetTable':
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter;
$SqlAdapter.SelectCommand = $SqlCmd;
$DataSet = New-Object System.Data.DataSet;
$SqlAdapter.Fill($DataSet);

$DataSetTable = $DataSet.Tables["Table"];
$DataSetTable

• Edited by Ajit663 Thursday, February 12, 2015 6:57 PM

i found the answer i used invoke command to query the sl server

$session = New-PSSession -ComputerName sql24567-000.outerspace.net -Credential "innerspace\ajmaur"
Invoke-command  -Session $session  -ScriptBlock

$SQLServer = 'sql24567-000.outerspace.net';
$Database = 'origindb';
$SqlQuery = @'
SELECT TOP 1000 [SecretId]
      ,[SecretName]
      ,[SecretType]
      ,[SecretKey]
      ,[FarmId]
      ,[State]
      ,[Scope]
      ,[ObjectId]
      ,[Version]
      ,[CreationTime]
      ,[WinAuth]
  FROM [origin].[dbo]
   where Name like '%spo%'
'@;

## - Connect to SQL Server using non-SMO class 'System.Data':
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection;
$SqlConnection.ConnectionString = `
"Server = $SQLServer; Database = $Database; Integrated Security = True";

$SqlCmd = New-Object System.Data.SqlClient.SqlCommand;
$SqlCmd.CommandText = $SqlQuery;
$SqlCmd.Connection = $SqlConnection;

## - Extract and build the SQL data object '$DataSetTable':
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter;
$SqlAdapter.SelectCommand = $SqlCmd;
$DataSet = New-Object System.Data.DataSet;
$SqlAdapter.Fill($DataSet);

$DataSetTable = $DataSet.Tables["Table"];
$DataSetTable

}

• Marked as answer by Ajit663 Thursday, February 12, 2015 7:54 PM