PowerShell.com
Library » Script Library » SQL Server » Connect-MSSQL-IPWindowsAuth

Connect-MSSQL-IPWindowsAuth

Previous | Next | View all files | View Slideshow
posted by Richard Giles
10-06-2008
Downloads: 571
File size: 2.3kB
Views: 2,127
Embed
Connect-MSSQL-IPWindowsAuth
  1. ## ===================================================================== 
  2. ## Title       : Connect-MSSQL-IPWindowsAuth 
  3. ## Description : Connect to SQL Server using IP address, instance and  
  4. ##                  Windows authentication 
  5. ## Author      : Idera 
  6. ## Date        : 9/1/2008 
  7. ## Input       : -ipAddress < xxx.xxx.xxx.xxx | xxx.xxx.xxx.xxx\instance > 
  8. ##               -verbose  
  9. ##               -debug     
  10. ## Output      : Database names and owners 
  11. ## Usage            : PS> . Connect-MSSQL-IPWindowsAuth -ipAddress 127.0.0.1 -v -d 
  12. ## Notes         :  
  13. ##    Tag            : MSSQL, connect, IP, Windows Authentication 
  14. ## Change Log    : 
  15. ## ===================================================================== 
  16.  
  17. param 
  18. ( 
  19.       [string]$ipAddress = "127.0.0.1", 
  20.     [switch]$verbose, 
  21.     [switch]$debug 
  22. ) 
  23.  
  24. function main() 
  25. { 
  26.     if ($verbose) {$VerbosePreference = "Continue"} 
  27.     if ($debug) {$DebugPreference = "Continue"} 
  28.     Connect-MSSQL-IPWindowsAuth $ipAddress 
  29. } 
  30.  
  31. function Connect-MSSQL-IPWindowsAuth($ipAddress) 
  32. { 
  33.     trap [Exception]  
  34.     { 
  35.         write-error $("TRAPPED: " + $_.Exception.Message); 
  36.         continue; 
  37.     } 
  38.      
  39.     # Load-SMO assemblies 
  40.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") 
  41.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlEnum") 
  42.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoEnum")  
  43.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo")  
  44.      
  45.     # Instantiate a server object 
  46.     # TIP: using PowerShell "`" to signify line continuation 
  47.     Write-Debug "Creating SMO Server object..." 
  48.     $smoServer = New-Object -typename Microsoft.SqlServer.Management.Smo.Server ` 
  49.         -argumentlist "$ipAddress" 
  50.      
  51.     # Use Windows Authentication by setting LoginSecure to TRUE 
  52.     Write-Debug "Setting Windows Authentication mode..." 
  53.     $smoServer.ConnectionContext.set_LoginSecure($TRUE) 
  54.      
  55.     # Clear the screen 
  56.     # TIP: cls will clear the PowerShell console 
  57.     cls 
  58.     Write-Host Your connection string contains these values: 
  59.     Write-Host 
  60.     $smoServer.ConnectionContext.ConnectionString.Split(";") 
  61.     Write-Host 
  62.      
  63.     # List information about the databases 
  64.     Write-Host "Databases on " $ipAddress 
  65.     Write-Host 
  66.     foreach ($db in $smoServer.Databases)  
  67.     { 
  68.         write-host "Database Name : " $db.Name 
  69.         write-host "Owner         : " $db.Owner 
  70.         write-host 
  71.     } 
  72. } 
  73.  
  74. main 

Connect to SQL Server using IP address, instance and Windows authentication.

Copyright 2012 PowerShell.com. All rights reserved.