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: 504
File size: 2.3kB
Views: 1,825
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.

Concentrated Tech NSoftware Dell Compellent Sponsored by Idera and Concentrated Tech and NSoftware and Dell Compellent
Copyright 2011 PowerShell.com. All rights reserved.