Showing posts with label login. Show all posts
Showing posts with label login. Show all posts

Monday, March 19, 2012

Encrypted password

when we built the login control by built in login control of vs2005 the passwords are saved in the database which is automatically created.how can i get the unencrypted form of these passwords from database.

This post talks about it in great details.

http://mishler.net/2006/04/18/AspNet+Membership+Password+Administration.aspx

hope it helps

|||actually i am a begginer and this articles didnt helped me tell me something else

Sunday, February 26, 2012

Enable/Disable SQL Server login

Hi,

Is there a way that I can enable/disable logins using SQL Authentication? Or similar function like Oracle's ALTER user LOCK/UNLOCK.

Thanks & Regards.
DennisYes, you can disable/enable logins using:

ALTER LOGIN login_name DISABLE

ALTER LOGIN login_name ENABLE

This works with any login, not only SQL logins.

Thanks
Laurentiu

Friday, February 24, 2012

Enable sa login for SQL Express 2005 using osql.exe

Hi,
Is there a way to enable the sa login using osql.exe? I think SQL Express
2005 disables the sys table modification using osql.exe.
Regards,
Qingsong
Hi
ALTER LOGIN sa ENABLE;
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Qingsong Zhang" <qingsong_zhang@.affymetrix.com> wrote in message
news:etAOavtAGHA.2704@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Is there a way to enable the sa login using osql.exe? I think SQL Express
> 2005 disables the sys table modification using osql.exe.
> Regards,
> Qingsong
>