August 12, 2009 at 6:37 am
Hi All,
How do I disable SQL Logins in SQL SERVER 2000?
ASAP.
August 12, 2009 at 6:44 am
Not sure there is a Disable Access option for SQL logins on 2000.
you can denydatareader and denydatawriter on DBs using roles, write a script to do so or manually check the options in the user permissions.
If the SQL account uses Windows Authentication, you can can deny access in the SQL Login Properties.
Otherwise jumble the passoword or remove the account.
August 12, 2009 at 6:47 am
If you mean that you only want to allow Windows Authentication, then in Enterprise Manager, right click the server and select properties, then look on the Security tab
August 15, 2009 at 2:24 am
There is no Disable option in SQL SERVER 2000, the option has been introduced in SQL Server 205.
If you don't want to give access to any SQL Login then you can go and change the Authentication mode from MIXED MODE to Windows only.
IF You are denying DATA READER or DATAWRITER Rights in that way the login will be able to connect to your server anyway.
But if you want that some specific users should not be able to connect to SQL Server then you can deny the CONNECT Right for that Login.
:hehe:
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply