Sql Server : Change Login Password or Forgot Password

-
when you forgot your sql server password or want to generate new password, in that case follow some steps:

 1. Start Command Prompt
2. write:
         osql -E -S .\SQLEXPRESS(Server Name)         
         exec sp_password @new='changeme', @loginame='sa'
         go
         alter login sa enable
         go
         exit


Comments

Post a Comment

Popular posts from this blog

C# Copy files from one server to another

-
Sometimes we need to copy files from one sever and paste those files to another server programmatically. So for that we can use below code but we should have admin credentials of that server where we want to paste files. In below method we need to pass source path of the server, from where we want to copy and destination path of the server, where we want to paste. Also we need to provide UserName, Domain, Password of the server where we want to paste those files. public void CopyFiles(string sourcePath, string destinationPath)         {             try             {                  IntPtr admin_token = new IntPtr();                 // use LOGON32_LOGON_NEW_CREDENTIALS as LogonType                 if (LogonUser(" UserName ", " Domain ", " Password ", 9, 0, ref admin_token) != 0)                 {                     WindowsIdentity wid_admin = new WindowsIdentity(admin_token);                     WindowsImpersonationContext wic =
Read more

Suppress StyleCop SA1600

-
    Local Suppression: [SuppressMessage("Microsoft.StyleCop.CSharp.DocumentationRules",  "SA1600:ElementsMustBeDocumented", Justification = "Reviewed.  Suppression is OK here.")] for local suppression you must use namespace  using System.Diagnostics.CodeAnalysis;   OR you can also use   [System.Diagnostics.CodeAnalysis.SuppressMessage ("Microsoft.StyleCop.CSharp.DocumentationRules", "SA1600:ElementsMustBeDocumented")]  Example:   using System.Diagnostics.CodeAnalysis;   [SuppressMessage("Microsoft.StyleCop.CSharp.DocumentationRules", "SA1600:ElementsMustBeDocumented", Justification = "Reviewed. Suppression is OK here.")] protected void Button1_Click(object sender, EventArgs e)   {   } [SuppressMessage("Microsoft.StyleCop.CSharp.DocumentationRules", "SA1600:ElementsMustBeDocumented", Justification = "Reviewed. Suppression is OK here.")]  protected v
Read more

Telerik Rad Grid Sorting

-
If you are using Telerik Rad Grid and also need to sort column on column's header click than for your requirement below code will help you surely. .aspx Code : <telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True" EnableViewState="false" AutoGenerateColumns="False" OnSortCommand="RadGrid1_SortCommand"  OnNeedDataSource="RadGrid1_NeedDataSource">  <SortingSettings EnableSkinSortStyles="true" />   <MasterTableView AllowNaturalSort="false" AllowSorting="True" AutoGenerateColumns="False">     <Columns>        <telerik:GridBoundColumn DataField="Name" HeaderText="Name"  SortExpression="Name">        </telerik:GridBoundColumn>        <telerik:GridBoundColumn DataField="Address" HeaderText="Address"  SortExpression="Address">        </telerik:GridBoundColumn&g
Read more