Microsoft SQL Server Management Studio -- Restore database in a difference server

Reference :

http://msdn.microsoft.com/en-us/library/ms177429.aspx

http://msdn.microsoft.com/en-us/library/aa337562.aspx

1.Go to the source database server, back up the database, save the backup file to E:\zkoo\chs2_DB.bak

2.copy the backup to destination database server to restore

3.how to enable  SQL server authentication

1) create a new login by choosing SQL Server authentication ,setup password following the rule (8 characters)

 

2)click  "status" to enable the login

3)restart the Database

4)login using SQL Server Authentication , re-input new password (following the rule)

 

4. configuration file :

  <dataConfiguration defaultDatabase="CHS" />
   <connectionStrings>
  <add name="CHS" connectionString="Database=CHS2;Server=XX.XX.XX.XX;User Id=chs2;Pwd=Password1;Connection Timeout=30;"
    providerName="System.Data.SqlClient" />
 </connectionStrings>