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…

  The following table shows service names, the term that is used to refer to the default and named instances of SQL Server services, a description of the service function, and the required minimum permissions. Display name Service name Description Required permissions SQL Server (InstanceName) Default instance: MSSQLSERVER Named instance: MSSQL$InstanceName SQL Server Database Engine.

Read more…

Here is a SQL Server Security Checklist to help you get started SQL Injection Checks Check Description   Input passed to data access methods that originates outside the current trust boundary is constrained. Sanitization of input is only used as a defense in depth measure.   Stored procedures that accept parameters are used by data

Read more…