how can i update my sqlserver password using with asp.net

Posted by Chanti444 under ASP.NET on 12/13/2011 | Points: 10 | Views : 852 | Status : [Member] | Replies : 1
hi friends ,

my sqlserver userid="sa" and password="ram" here my problem is i want update password that to using with asp.net code is it possible ?
can u help me who knows any one if it is possible pls my work is very long pending here

..............thankq for advance

satya


Responses

Posted by: Sksingh on: 12/13/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,
You can use sp_addlogin stored procedure to create a new SQL Server login that allows a user to connect to an instance of SQL Server by using SQL Server authentication.
Exp:

EXEC sys.sp_addlogin N'username', N'password';


For more details refer http://msdn.microsoft.com/en-us/library/ms173768.aspx

Regards,
Sunil

Chanti444, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response