Can I use 6.5 tools to login to SQL 2000 database with Windows Auth.

[Antelope]

New to SQL and told to lock down our SQL server. User that likes SQL 6.5 tools better than 2000, but when I set SQL 2000 for Windows Only Authentication, he cannot login. It gives him a choice of standard or trusted authentication, but when he chooses trusted - he cannot even enter a user name. Any way to accomplish this?

 

[Corran007]

you can only access sql 2000 with sql 2000 tools. even sql7 tools will not work. I know you can still hit a 7 machine with 2000 tools, but i do not know about 6.5.

 

[Antelope]

Actually, it worked fine until I changed the sa password on my users because I wanted to implement more security. It seems like local sql server authentication will work with 6.5 tools, but Windows Authentication will not.