Validating login connection

  • In SQL 2000 you could go through Query Analyzer to validate a user's login/password connection.  How can I validate a user's login in SQL2005? 

  • 1. Are you in mixed mode or Windows Authentication only?

    2. What are you trying to accomplish? Whether a user has valid access directly to the database?

    3. Security is very different in 2005 - why wouldn't you expect to need different tools?

  • Mixed mode

    Quick test to validate a db connection

    Just scratching the surface of 2005 + security. M.S. is known for providing several different ways of accomplishing the same task.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply