{"id":7467,"date":"2017-12-23T11:35:17","date_gmt":"2017-12-23T11:35:17","guid":{"rendered":"https:\/\/kb.sambapos.com\/?p=7467"},"modified":"2023-10-25T19:42:57","modified_gmt":"2023-10-25T19:42:57","slug":"2-1-3-a-sql-express-server-setup","status":"publish","type":"post","link":"https:\/\/kb.sambapos.com\/en\/2-1-3-a-sql-express-server-setup\/","title":{"rendered":"2.1.3.a. SQL Express Server Setup"},"content":{"rendered":"

In this document it will be shown how to download, install and configure the SQL Server. You can use many PC in a network by this way.<\/p>\n

Download SQL Server<\/span>\u00a0<\/span><\/h2>\n

You can download the latest SQL Server Express Version from the below <\/strong>download Link;<\/strong><\/span><\/p>\n

https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-downloads<\/a><\/p>\n

\"\"<\/p>\n

Run the\u00a0.exe <\/strong>Select\u00a0Download Media<\/strong>.<\/p>\n

\"\"<\/p>\n

Select language and Express Advanced (544 MB)<\/strong>\u00a0then click on\u00a0Download<\/strong> button.<\/p>\n

\"\"<\/p>\n

SQL Server 2022 Express Edition <\/strong>will be downloaded.<\/p>\n

\"\"<\/p>\n

Click on\u00a0Open Folder<\/strong>.<\/p>\n

\"\"<\/p>\n

Click on\u00a0SQLEXPR_x64_ENU<\/strong>\u00a0and run(open).<\/p>\n

\"\"<\/p>\n

Click on Ok<\/strong> button.<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

SQL Server Setup<\/span><\/h2>\n

Click on\u00a0SETUP<\/strong>\u00a0and run(open) SQL Server Setup will start.<\/p>\n

\"\"<\/p>\n

Click on\u00a0New SQL Server stand-alone installation or add features to an existing installation<\/strong>.<\/p>\n

\"\"<\/p>\n

Click on\u00a0I accept the license terms <\/strong>and\u00a0<\/strong>Next\u00a0<\/strong>button.<\/p>\n

\"\"<\/p>\n

Click on\u00a0Next\u00a0<\/strong>button for update check.<\/p>\n

In here you need to deselect<\/span> Azure Extension for SQL Server checkbox.<\/strong><\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Click on Next\u00a0<\/strong>button. Select\u00a0Default instance<\/strong>.<\/p>\n

\"\"<\/p>\n

Click on\u00a0Next\u00a0<\/strong>button.<\/p>\n

\"\"<\/p>\n

In this screen<\/b>\u00a0select Mixed Mode<\/strong>.<\/p>\n

\"\"<\/p>\n

Enter password<\/strong>\u00a0and\u00a0Confirm password<\/strong>\u00a0then click on\u00a0Next<\/strong> button. (Please don’t forget your password.)<\/p>\n

\"\"<\/p>\n

Click on\u00a0Close<\/strong> button and close the window by clicking on X <\/strong>button. Installation and setup completed.<\/p>\n

\"\"<\/p>\n

SQL Server is ready to use.<\/p>\n

Settings for SQL Serv<\/span>er<\/span><\/span><\/h2>\n

You need to configure\u00a0Windows Firewall Settings<\/strong>. Go to\u00a0 Control Panel > System and Security >\u00a0Windows Firewall<\/strong>.<\/p>\n

\"\"<\/p>\n

Go to Advanced settings<\/strong>.<\/p>\n

\"\"<\/p>\n

Click on\u00a0\u00a0Inbound Rules<\/strong>\u00a0and click on New Rule<\/strong>.<\/p>\n

\"\"<\/p>\n

Click on Rule Type, select\u00a0Port\u00a0<\/strong>and click on\u00a0Next<\/strong>\u00a0button.<\/p>\n

\"\"<\/p>\n

Select TCP<\/strong>\u00a0and Specific local ports<\/strong> in Protocol and Ports then write\u00a01433<\/strong>\u00a0in box and click on\u00a0Next <\/strong>button.<\/p>\n

\"\"<\/p>\n

Select Allow the connection<\/strong> in Action<\/strong> and click on Next<\/strong> button.<\/p>\n

\"\"<\/p>\n

All boxes must be selected in Profile<\/strong>. Click on Next<\/strong> button.<\/p>\n

\"\"<\/p>\n

Give a name to the rule in Name<\/strong> section and click on Finish<\/strong> button.<\/p>\n

\"\"<\/p>\n

Inbound Rules are done.<\/p>\n

\"\"<\/p>\n

Click on Outbound Rules<\/strong> and New Rule<\/strong>.<\/p>\n

\"\"<\/p>\n

Select Port<\/strong> in Rule Type<\/strong> and click on Next<\/strong> button.<\/p>\n

\"\"<\/p>\n

Select\u00a0TCP<\/strong>\u00a0and\u00a0Specific local ports<\/strong>\u00a0in Protocol and Ports then write\u00a01433<\/strong>\u00a0in box and click on\u00a0Next\u00a0<\/strong>button.<\/p>\n

\"\"<\/p>\n

Select\u00a0Allow the connection<\/strong>\u00a0in\u00a0Action<\/strong>\u00a0and click on\u00a0Next<\/strong>\u00a0button.<\/p>\n

\"\"<\/p>\n

All boxes must be selected in\u00a0Profile<\/strong>. Click on\u00a0Next<\/strong>\u00a0button.<\/p>\n

\"\"<\/p>\n

Give a name to the rule in\u00a0Name<\/strong>\u00a0section and click on\u00a0Finish<\/strong>\u00a0button.<\/p>\n

\"\"<\/p>\n

Outbound Rules are done.<\/p>\n

\"\"<\/p>\n

Please do the same settings for internet security or firewall software if you have.<\/p>\n

\"\"<\/p>\n

TCP\/IP<\/strong>\u00a0and\u00a0NetBios<\/strong>\u00a0Settings<\/p>\n\n\n\n
SQL Server 2017<\/td>\nC:\\Windows\\SysWOW64\\SQLServerManager14.msc<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
SQL Server 2016<\/td>\nC:\\Windows\\SysWOW64\\SQLServerManager13.msc<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
SQL Server 2014<\/td>\nC:\\Windows\\SysWOW64\\SQLServerManager12.msc<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
SQL Server 2012<\/td>\nC:\\Windows\\SysWOW64\\SQLServerManager11.msc<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"\"<\/p>\n

Click on Protocols for MSSQLSERVER <\/strong>in\u00a0SQL Server Network Configuration<\/strong>.<\/p>\n

\"\"<\/p>\n

Right click on Named Pipes<\/strong> ve TCP\/IP<\/strong> default and Enable<\/strong>\u00a0both.<\/p>\n

\"\"<\/p>\n

Double click on TCP\/IP<\/strong>.<\/p>\n

\"\"<\/p>\n

Click on IP Addresses<\/strong>.<\/p>\n

Do the followings for IP1;<\/strong><\/p>\n

    \n
  • Active: YES<\/strong><\/li>\n
  • TCP Dynamic Ports:\u00a00<\/strong><\/li>\n
  • TCP Port:\u00a01433<\/strong><\/li>\n<\/ul>\n

    \"\"<\/p>\n

    Do the followings for IPAll;<\/strong><\/p>\n

      \n
    • TCP Dynamic Ports :\u00a00<\/strong><\/li>\n
    • TCP Port:\u00a01433<\/strong><\/li>\n<\/ul>\n

      \"\"<\/p>\n

      Click on OK button. Right click on\u00a0SQL Server Services<\/strong>\u00a0SQL<\/strong>\u00a0and\u00a0Restart<\/strong>.<\/p>\n

      \"\"<\/p>\n

      Settings are done.<\/p>\n

      Install SambaPOS V5 and SQL Server Connection<\/span><\/h2>\n

      Double click on SambaPOS Setup.exe<\/p>\n

      \"\"<\/p>\n

      Select the language <\/strong>and click on OK <\/strong>button.<\/strong><\/p>\n

      \"\"<\/p>\n

      Select only Sample Data<\/strong>, unselect the others and click on Next\u00a0<\/strong>button.<\/p>\n

      \"\"<\/p>\n

      SambaPOS installation will start. The other settings will be made in SambaPOS when the installation was completed. Run SambaPOS and go to\u00a0Main Menu > Manage > Settings > Local Settings > Database<\/strong>.<\/p>\n

      \"\"<\/p>\n

      Click on Edit Connection<\/strong>. Fill in the boxes:<\/p>\n

        \n
      • Data source:<\/strong>\u00a0Name of PC.<\/li>\n
      • User Id:<\/strong>\u00a0 sa<\/li>\n
      • Password:<\/strong>\u00a0Write the password defined for Mixed Mode in SQL Setup.<\/li>\n
      • Database:<\/strong>\u00a0Give a name for database.<\/li>\n<\/ul>\n

        \"\"<\/p>\n

        Click on OK<\/strong> button. Click on Save<\/strong>\u00a0button and shut down SambaPOS completely and restart.<\/p>\n

        SambaPOS will connect to database when you restarted. Now it is ready to use.<\/p>\n

        Click on SambaPOS logo on top left corner to minimize the SambaPOS. You can see the SQ letters. It means that you are connected to database correctly.<\/p>\n

        \"\"<\/p>\n

        If you go to Main Menu > Manage ><\/strong> Settings > Local Settings > Database<\/strong>\u00a0, you can see the connection string.<\/p>\n

        \"\"<\/p>\n

        These settings must be done for the all clients in network. The name which used for Data source in SQL PC must be used in all clients.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

        In this document it will be shown how to download, install and configure the SQL Server. You can use many PC in a network by this way. Download SQL Server\u00a0 You can download the latest SQL Server Express Version from the below download Link; https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-downloads Run the\u00a0.exe Select\u00a0Download Media. Select language and Express Advanced (544 […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,5],"tags":[],"class_list":["post-7467","post","type-post","status-publish","format-standard","hentry","category-2-1-system-setup","category-installation"],"_links":{"self":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/7467","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/comments?post=7467"}],"version-history":[{"count":14,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/7467\/revisions"}],"predecessor-version":[{"id":28809,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/7467\/revisions\/28809"}],"wp:attachment":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/media?parent=7467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/categories?post=7467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/tags?post=7467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}