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.


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


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


Accept the license terms:

Then install:


Wait until the installation is done:

Choose install SSMS:

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:

After download completed press left click to start the setup procedure


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


when the installation finish open the SQL SERVER CONFIGURATION

 


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





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


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




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



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


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


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



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


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



Let's right click on Security → New → Login


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



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


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

  • No labels