Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

3) Prepare SQL Server Management Studio (if you already have this installed go to 3.2, so only skip 3.1)

  1. Download and install SQL Server Management Studio.
  2. Connect to the SQL Server and right click the server in your object explorer (located on the left) and click properties.
  3. Go to security and make sure Server authentication is set to SQL Server and Windows Authentication mode. If it is not yet set to SQL Server and Windows Authentication mode, continue with step 3.4). Else, continue with step 3.9).
  4. If you change this, you will need to restart your server, do this by opening task messenger (ctrl + shift + esc).
  5. Go to the Services tab.
  6. Find MSSQL${your server version}.
  7. Then right click and press stop, don`t press restart this goes too fast and will therefore not be effective.
  8. Then right click again and start it again.
  9. Go back to SQL Server Management Studio and open the folder called Security under your server in the Object Explorer.
  10. Then go to Logins and double click sa.
  11. Setup a password.
  12. Go to Status and make sure that the Login is Enabled.
  13. Try if it worked by clicking the connect button, see screenshot below.

Image Removed

14. Then select SQL server Authentication instead of Windows authentication and login using the sa credentials, if you are logged in its correct, if not refollow the steps above starting from 3.2.

  1. Make sure you have SQL server installed and an instance set up.
  2. Make sure you have management studio installed.
  3. In management studio connect to you local instance.
  4. Right click databases, and click new database.
  5. Create a database called "BudgetModule".


Image Added

5) Install the application

...