Unlocking a Account

Question

Post reply

Unlocking a Account

todd_dawson

Ten Centuries

Points: 1240
More actions
September 26, 2008 at 9:42 am

#194160

What would be the SQL 2000 equivalent of 'ALTER LOGIN' - I need to unlock an account.

Viewing 5 posts - 1 through 4 (of 4 total)

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

nary SSCrazy Points: 2869 More actions · Answer 1

SQL Server 2000 won't lock/disable the Login as this feature is availble in SQL Server 2005 not in 2000.

Glen SSCertifiable Points: 6737 More actions · Answer 2

sp_change_users_login, sp_password, sp_addlogin, sp_droplogin, sp_grantlogin, sp_revokelogin

etc.

todd_dawson Ten Centuries Points: 1240 More actions · Answer 3

So a lock out for an account wouldnt come from the SQL Server side, it would have to come from the vendors software for SQL 2000?

nary SSCrazy Points: 2869 More actions · Answer 4

Todd

If you are using any Customize piece for SQL Server from Vendor then Locking Login may be additional feature they might have introduce in that Software , so for that you might need to check with Vendor who provide the Software .

Thanks