SQL Server Security

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Solve SQL Server permissions and authentication problems

    For the past two weeks I've been trying to resolve a permissions problem, an authentication problem, or both. I've run out of ideas of where to look. Here is what I have: (1) SQL Server 2005 on a Member Server (2003) (2) I'm running Visual Studio... 

  • Create username and password for new SQL Server database

    I have created a SQL Server 2005 database and I plan to protect it with a username and password. I'm unclear as to how to do this. How can I make a security system for my new database with its security objects? 

  • Recover password in SQL Server 2000

    I have forgotten my password root in SQL Server 2000. Is there some way to recover it without having to install SQL Server again? 

  • User password display in SQL Server

    I am trying to find out which password I have assigned to the user schema on my SQL Server 2000. I know that you can change the password, but I've had some grief with that application in the past. I know where the password is stored, but it is in enc... 

  • Protect against SQL Injection by whitelisting

    OK, admittedly the best practice for guarding against SQL Injection attacks is to white-ist acceptable characters. However, given that knowledge is power, is there a comprehensive list of special characters (such as the single-quote or double-hyphen)... 

  • Using asymmetric encryption

    SQL Server Security expert Steven Andres explains how the asymmetric encryption system could help protect against an attacker. 

  • SQL Server 2005 best practices for developer permissions

    SQL Server Security expert Steven Andres suggests resources to help get you on your way in developing internal applications. 

  • Monitoring failed login attempts in SQL Server 2000

    As failed login error reporting is disabled by default in SQL Server 2000, Security expert Steven Andres details how to enable this function. 

  • Securing IIS and SQL Server as part of an online platform

    Learn how to protect the platform between your database and the web beginning with keeping your DMZ machines as distant from your internal domain as possible. 

  • Avoid SQL injection with these best practices

    Avoiding SQL Server injection through validating data may be tedious, but it is usually simple and always worthwhile.