Monthly Archives: April 2011

Using Logon Trigger to block remote SQL Server connections from SSMS or other applications

Due to some business requirements/rules,  some SQL Server instances only allow conditional remote connections such as only a internal web application that can make remote connections, but not allow any other application such as SQL Server Management Studio to do … Continue reading

Posted in Uncategorized | Leave a comment

Tip: Using a different Windows user to log on to SQL Server rather than the current one used for Windows

By default, when we log on to SQL Server using SSMS (SQL Server Management Studio) or other client tools by choosing Windows Authentication Mode, it will use our Windows user credential currently logged on to Windows. This is not a … Continue reading

Posted in SQL Server Authentication | Tagged , | Leave a comment