SkiQueen
SSC Journeyman
Points: 75
More actions
August 9, 2007 at 11:38 am
#174128
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?
steve smith-401573
SSChampion
Points: 10889
August 10, 2007 at 8:46 am
#726057
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?
August 10, 2007 at 10:28 am
#726102
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