Use the following code below to connect to SQL Server 2008 R2.  This will text connectivity over SSPI/Integrated Authentication.  You can also define the port number and display the results in the powershell window.  Remember to press “Enter” once the count of records is returned. This is very helpful when troubleshooting connection issues, it can

Read more…