SQL Server 2014  Databases Setup:

• Set mixed authentication mode:
  Start -> All Programs -> Microsoft SQL Server 2014 -> SQL Server Management Studio
  On the "Connect to Server" window, login with the valid username (sa) and password;  Click "Connect"
  At the top of the left panel, right click on YourComputerName(SQL Server 12.0...) and select Properties
  On the left panel of the "Server Properties" window, select "Security"
  Choose "SQL Server and Windows Authentication mode" and click OK
  
  
• Create two new databases:
  On the left panel, expand "Databases"
  Right click "Databases"  -> Select "New Database...", enter "premiere" and click OK.
  Similarly, create an empty "henry" database
  
  
• Create tables and populate the two new databases:
  On the left panel, right click on "premiere" database.
    Click on "Open File" icon (from the icon bar)
    Browse and choose premiere.sql -> Open;
  On the icon bar, a box on the left side (below Edit menu) displays the name of the active database.
  Click the dropdown list of databases of that box and select "premiere" database.
  Click "Execute" icon
  Click on "Open File" icon (from the icon bar)
    and open henry.sql script (note this script file creates tables and loads all data)
  At the active database box, select "henry" from the dropdown list of databases
  Click "Execute" icon
  
  
• Create a new user and set permissions:
  On the left panel of Server Management Studio window,
  Click "Security" and right click on "New" and select "Login..."
    General: Name as Application program username(cop4722), Choose SQL Server Authentication,
        Password(4722), Confirm password (4722), premiere as the default database,
        Uncheck all Enforce password check boxes
    UserMapping: Enable premiere (top), Enable db_owner, public (bottom)
                          Enable henry (top), Enable db_owner, public (bottom)
    Click OK
  
  Choose any username and password of your choice for this step.

--Prabakar