Versions Compared

Key

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

Look in your browser for this link: https://www.microsoft.com/en-us/download/details.aspx?id=101064 You will see the following window. Click on Download.

Image Added


After that run the .exe file as you can see below:

Image Added


Choose the Basic installation (In case you have a serial key for another version e.g standard you can proceed with custom)

Image Added


Accept the license terms:

Image Added

Then install:

Image Added


Wait until the installation is done:

Image Added

Choose install SSMS:

Image Added

When the site pop up you press the link that you can see in the red box of the picture below and the download will start:

Image Added

After download completed press left click to start the setup procedure

Image Added


Choose install and then wait until the setup complete and you are ready to use SSMS

Image Added

Image Added


when the installation finish open the SQL SERVER CONFIGURATION

 Image Added


Choose SQL server Services → SQL server (SQLEXPRESS) right click → Properties → Filestream and click in all boxes → Apply


Image Added


Image Added



The next step is to choose Protocold for SQLEXPRESS → right click on TCP/IP → ENABLE → again right click on TCP/IP → properties

Image Added


After you open the propertis you choose IP Adresses → scroll down to the buttom →  TCP Port 1433 (this is the default port that we are using you can choose whatever port you want) and Apply

Image Added




Now we can move to the SSMS configuration, find the SSMS from your windows search bar and open it as administraton


Image Added


In the server name box you fill it with the IP and the Port of your server (check the previous step) and you connect.

Image Added


After you connect, some options will appear on the left side. Left-click on the first one, then select 'Properties'

Image Added


Select Advanced --> Filestream access level and change it to Full access enabled


Image Added


Open again the properties window that you open in the previous step and select Security → SQL Server and Windows Authentication Mode nad press OK

Image Added


In the next steps we are going to create an admin User.



Let's right click on Security → New → Login

Image Added


Login name: admin (or the name that you want to give) → password → unclick the 3 options for enforce password policy


Image Added


Then we give the roles to our admin user: public and sysadmin → press ok 

Image Added


Now the only thing that we have to do is to restart your SQL server for the changes to be applied and we are ready