Reset Forgotten Login Password
-
Hi everyone, I'm writing a small client application that will access data from Sql Server Database. I would like to know how the SQL that can be used to reset a user's password if the old password is lost or forgotten. The Sql Server stored procedure sp_password requires the old password but what should be done if the old password is lost in order to reset the user's password. I'm using SQL Server 2005. Thanks in advance.
-
Hi everyone, I'm writing a small client application that will access data from Sql Server Database. I would like to know how the SQL that can be used to reset a user's password if the old password is lost or forgotten. The Sql Server stored procedure sp_password requires the old password but what should be done if the old password is lost in order to reset the user's password. I'm using SQL Server 2005. Thanks in advance.
sp_ prefix on your procedure implies that you are using a system procedure, just where are you storing your users authentication? If you are creating a sql server user and assigning authentication/authorisation via sql server object you are using the most difficult model possible. I think most apps have a "functional" ID they use to connect to the database and then internalise the authorisation of their users, much simpler! You may need to drop and recreate the user.
Never underestimate the power of human stupidity RAH
-
Hi everyone, I'm writing a small client application that will access data from Sql Server Database. I would like to know how the SQL that can be used to reset a user's password if the old password is lost or forgotten. The Sql Server stored procedure sp_password requires the old password but what should be done if the old password is lost in order to reset the user's password. I'm using SQL Server 2005. Thanks in advance.
-
Hi everyone, I'm writing a small client application that will access data from Sql Server Database. I would like to know how the SQL that can be used to reset a user's password if the old password is lost or forgotten. The Sql Server stored procedure sp_password requires the old password but what should be done if the old password is lost in order to reset the user's password. I'm using SQL Server 2005. Thanks in advance.