WordPress migration

To migrate your WordPress from your local machine to the live domain, follow the below steps

1. Login to the WordPress admin section
2. Go to plugins->Add New
3. Search for “wp migrate db”
4. Activate the first plugin in the result
5. Go to Tools->wp migrate db
6. Give the old url, new url, old physical path and new physical path
7. Once you submitted this form, you will be able to download one sql file
8. Download this sql file and upload it in the new live site
9. Copy all the files from the local machine and upload into the live hosting server using any ftp client tool(Ex: FileZilla Client)
10. Change the DB configuration settings in the wp-config.php

Restart SQL Server

Follow the below steps to restart the SQL server

1. Go to run(Windows+r) and type “services.msc”
2. Select “SQL Server (SQL Express)”
3. Right click and select “Restart”

SQL server – The user is not associated with a trusted SQL Server Connection – Fixed

Issue:

The user is not associated with a trusted SQL Server Connection when the user is trying to login to SQL Server in management studio.

Solution
The reason of the issue is sql server authendication is disabled in your sql server. This can be enabled by the following steps

1. Open Microsoft SQL server Management Studio Express
2. Login in with Windows Authendication user
3. Right click on the server name(Left pane) and click on properties
4. Choose “Security” in the dialog windows(Left side)
5. By default “Windows Authendication mode” is selected. You have to select “SQL Server and Windows Authendication mode” and click on “OK”
6. Restart the sql server service and Login with the SQL Authendication user(Click here to Restart SQL  Services)