Tuesday, 31 July 2018

Best SQL Server Password Changer to Reset or Change SQL SA Password

How to Reset/Change SQL Server Password with Help of SQL Password Changer

Some days back, I got a question on this topic and the question was “how to reset/change SQL password” without reinstalling it. I guess many of us face issues like this. So; today from this article I will be sharing three easy Methods or ways to reset/change SQL Server Password.


Method 1: Reset/change SQL Server Password using SQL script.


  • Open the SQL Server Management Studio
  • Now, open a new query.
  • Copy, paste and perform the following steps as  mentioned below:


Go to the ALTER LOGIN [sa] with DEFAULT_DATABASE=[master]
Go
USE [master]
Go
ALTER LOGIN [sa] WITH PASSWORD=N’NewPassword’ MUST_CHANGE
Go
Where NewPassword is the password you want to use for the sa account.

Method 2: Reset SQL password in Management Studio.

You can easily change or reset your and once again can have access to the powers of SA account using windows authentication mode.

All you have to do is to follow these simple steps:


  • Login into SQL server using Window Authentication.
  • In the Objective Explorer Option, open Security folder and now open the Login folder.
  • Right click on sa account and go to properties.
  • Now, reset/change sa password and press OK

Method 3: Reset SQL server Password using Automated Method  

If all the above methods don’t work in resetting or changing SQL server password, then the only method left with you is Aryson MS SQL SERVER PASSWORD RECOVERY V.20.It is the best solution to instantly reset or change SQL server account in a very safe manner. This SQL Server password Recovery Software allows user to set a new password for their accounts if they have forgotten or lost the original password. With this recovery tool you can crack users as well as System Administrator account password flawlessly.

Some of its exclusive features are:


  • It can set new Password for user accounts in SQL server by replacing the original password.
  • It can crack all types of SQL passwords, such as encrypted and UN-encrypted Password and a many more.

Now, let’s see how to change the password by using this tool:

Step 1. Download MS SQL Server Password Recovery 
Step 2. Browse master.mdf file to continue the password recovery process.

Step 3. Click on the Open file button to choose the SQL server master data base file (master.mdf) which is in documents.

Step 4. Select the desired user from user list and choose any option   “Change Password “ or “Remove password “according to your need.



Step 5. To reset SQL server password click on “change password”button.

Step 6. Type a new password and click OK.
Step 7. Password successfully changed for selected database.

Step 8. Submit YES and close the application.


Conclusion

The tool I mentioned is the best tool to reset SQL server password as per my knowledge. You can choose any method on the basis of your need. Hope the above mentioned tool and the two manual steps will help you in changing your SQL server password.



Friday, 13 July 2018

How to Convert Offline Folder OST File to PST in Outlook 2016/2013/2010/2007


The OST stands for Offline Storage Tables, when there is unreliable connectivity of internet then OST is an effective means to access Exchange Server mailbox folders locally on the Outlook client. It permits to continue with the mailbox functionality when the server is not connected that is in the offline mode. However, OST files have a property of stiffness and cannot be influenced easily by an external interruption. Sometimes there is a condition when OST data becomes inaccessible due to which routine business operations got affected. There are many reasons that make OST data inaccessible.

The troubleshooting of inaccessibility of OST is needed, no matter what is the version of the application likewise MS Outlook 2007, 2010, 2013, 2016 or any older ANSI edition. This is the simple solution to export offline folder file to Outlook PST when you have to resolve all the problems regarding the OST, regardless how severe files are damaged and harmed.


Steps to Convert Offline Folder File to Outlook PST format which are as follows:


(1) Archive Method

The Outlook has a feature of an archive which can be used to copy or move mailbox items to PST. All the items of OST mailbox can be converted into PST format. But, in this feature, only Contact item is there which cannot be archived. Regardless any other items of the mailbox can be exported. Steps for archiving are as follows:

a. First, open MS Outlook after that open the OST file from which the data requires to be exported
b. Just Click on File tab, click on Info, and then click on CleanUp Tools
c. Next, the step is to choose Archive from the options
d. Archive dialog box will appear, make sure that Archive this folder and all subfolders option is selected by the way it is selected by default
e. Select the folder or item that you need to export or convert to PST like Inbox.
f. In the Archive items older than the box, it provides an appropriate date. All the items that were received earlier until the mentioned date will be archived. 
g. In the Archive file: option, give the destination path to store the new PST.
h. Click on OK to achieve the export process.

(2) Method of Drag and Drop of Mailbox Items

In this method, you can drag and drop OST mailbox items to PST file format. It is the one of an efficient way to transfer data from OST file to Outlook PST. First of all, to achieve this you have to create blank PST file in MS Outlook and then click and drag the desired item in the OST mailbox to create new PST file.

Although, this procedure has some constraints regarding the method of drag and drop of a mailbox.
For every individual item which has to be exported to PST mailbox, you have to repeat the process. You have to pay attention during the process because it is time-consuming, and committing a single mistake will lead to an unwanted repetition of the process.  
To export structure folder or other default folders such as inbox, calendars, contacts etc. you have to create new PST file to organize the whole data in a systematic way.

(3)  Method of Outlook Import & Export Wizard

There is another method for exporting OST file to PST files in Outlook 2010 is MS Outlook Import and Export wizard. It can also be used for another version. In this method, you can also choose OST data to Excel and CSV file formats. This technique is manual; you can try an attempt for error-free execution.

So, there are possibilities of losing the important data in each step during the execution process when it is done inaccurately. This process needs a lot of attention and technical efficiency to accomplish built-in import/export strategy. To overcome this problem you should take backup of OST file before executing the export, to restore them. By doing so your data will not lose when there is any mistake.

(4) Tool to Converter Offline Folder OST File to PST


The Converter tool is also available it is an automatic method to export bulk mailboxes. So, the alternate is OST to PST Converter which can be used for converting offline Exchange OST to PST in MS Outlook. This tool also has many features like:
  • Your data will not change after conversion.
  • It performs the quick and safe conversion and maintains data integrity. 
  • This tool or software can be used for both normal and corrupt files.
  • It also supports encryption. The files which are password protected will also get exported.