{"id":1551,"date":"2019-07-08T04:39:05","date_gmt":"2019-07-08T04:39:05","guid":{"rendered":"https:\/\/litextension.com\/faq\/docs\/shopping-cart-questions\/nopcommerce\/how-to-get-nopcommere-sql-server-database-information\/"},"modified":"2021-05-14T09:18:10","modified_gmt":"2021-05-14T09:18:10","slug":"how-to-get-nopcommere-sql-server-database-information","status":"publish","type":"docs","link":"https:\/\/litextension.com\/faq\/docs\/shopping-cart-questions\/nopcommerce\/how-to-get-nopcommere-sql-server-database-information\/","title":{"rendered":"How to get nopCommere SQL Server Database Information"},"content":{"rendered":"<p><strong>1. You can get Nopcommerce SQL Server Database login information either by:<\/strong><\/p>\n<ul>\n<li>Contact your system admin or hosting provider<\/li>\n<li>In \/App_Data\/Settings.txt<\/li>\n<\/ul>\n<p>A SQL Server database info normally contains host, username, password, port ( default = 1433 ), database name.<\/p>\n<p><strong>2. After you get the database info, please make sure that it can be connected remotely from an outside machine, by following this:<\/strong><\/p>\n<p><strong>Step1: Configuring remote access on a SQL Server instance<\/strong><\/p>\n<p>To enable remote connection on SQL Server right \u2013 click on the server and select the Properties option. In the Server Properties dialog under the Connections tab check the\u00a0<b>Allow remote connections to this server<\/b>\u00a0option:<\/p>\n<p><a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/AllowRemoteConnection.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/AllowRemoteConnection_s.png\" alt=\"Server Properties dialog - Connections tab - checking the Allow remote connections to this server option\" \/><\/a><\/p>\n<p>Go to Start-&gt;Programs-&gt;Microsoft SQL Server 2005\/2008\/2012 -&gt;Configuration Tools and select the SQL Server Configuration Manager:<\/p>\n<p><a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/SQLServerConfigManager.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/SQLServerConfigManager_s.png\" alt=\"Illustration of selecting the SQL Server Configuration Manager\" \/><\/a><\/p>\n<p>Under the SQL Server Network Configuration select Protocols for &lt;your server name&gt;:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"box-sizing: border-box; border: 0px; vertical-align: middle; max-width: 100%; font-size: 14.9329px;\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/Protocols.png\" alt=\"Selecting Protocols for &lt;your server name&gt; under the SQL Server Network Configuration\" \/><\/p>\n<p>Make sure that TCP\/IP protocol is enabled and right-click on TCP\/IP and select the Properties option. In the TCP\/IP Properties dialog select the IP Addresses tab and scroll down to IPAII. If the TCP Dynamic Ports dialog box contains 0, which indicates that the Database Engine is listening on dynamic ports, delete the 0 and set the TCP Dynamic Ports to blank and TCP Port to 1433. Port 1433 is the default instance that SQL Server uses:<\/p>\n<p><a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/PortsDialog.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/PortsDialog_s.png\" alt=\"Configuring the IPAII properties via TCP\/IP Properties dialog\" \/><\/a><\/p>\n<p>When you click the OK button you will be prompted with a message to restart the service:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/Warning.png\" alt=\"Warning message to restart the service\" \/><\/p>\n<p>In the left pane of SQL Server Configuration Manager click SQL Server Services, right-click SQL Server&lt;instance_name&gt;, and click Restart:<\/p>\n<p><a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/Restart.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/Restart_s.png\" alt=\"Right-clicking SQL Server (instance name), and clicking Restart\" \/><\/a><\/p>\n<p><em>Note:\u00a0If you\u2019re using a firewall you need to add an exception for the 1433 port to allow TCP\/IP traffic on Port 1433<\/em><\/p>\n<p><strong>Step 2: Configure a Windows Firewall for Database Engine Access<\/strong><\/p>\n<p>To add a firewall exception for the 1433 port go to Programs -&gt; Administrative Tools select the\u00a0<b>Windows Firewall with Advanced Security\u00a0<\/b>option and follow the steps:<\/p>\n<p><a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/WindowsFirewall.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/WindowsFirewall_s.png\" alt=\"Selecting the Windows Firewall with Advanced Security option\" \/><\/a><\/p>\n<ul>\n<li>In the Windows Firewall with Advanced Security dialog click on the Inbound Rules option and select the New Rule command:<a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/WindowsFirewallNewRule.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/WindowsFirewallNewRule_s.png\" alt=\"Selecting the New Rule command\" \/><\/a><\/li>\n<li>In the New Inbound Rule wizard select the Port option and click Next:<a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/RuleType.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/RuleType_s.png\" alt=\"Selecting the Port option in the New Inbound Rule wizard\" \/><\/a><\/li>\n<li>In the Protocols and Ports window specify the protocols and ports to which a rule applies. Select the TCP option, in the Specific local ports text box enter the 1433 port, and click Next:<a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/ProtocolsAndPorts.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/ProtocolsAndPorts_s.png\" alt=\"Configuring protocols and ports in the New Inbound rule wizard\" \/><\/a><\/li>\n<li>In the Action window select the Allow the connection to specify the action to be taken when a connection matches the conditions specified in the rule:<a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/AllowTheConnection.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/AllowTheConnection_s.png\" alt=\"Selecting the Allow the connection in the Action window\" \/><\/a><\/li>\n<li>Specify the profiles for which the rule applies in the Profile window, and click Next: <a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/Domain.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/Domain_s.png\" alt=\"New Inbound Rule wizard - Profile dialog\" \/><\/a><\/li>\n<li>In the last window specify the name of the created rule and click the Finish button: <a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/RuleName.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/RuleName_s.png\" alt=\"Specifying the name of the created rule\" \/><\/a><\/li>\n<\/ul>\n<p>You can now see the created rule in the list of inbound rules:<\/p>\n<p><a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/InboundRulesList.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/InboundRulesList_s.png\" alt=\"Viewing the created rule in the list of inbound rules\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Step 3: Configuring remote access on a named instance of SQL Server<\/strong><\/p>\n<p>If you using a named instance of SQL Server there are specific things you need to do to allow clients to access the SQL database remotely. As already stated, the default instance that SQL Server listens is port 1433. For a named SQL Server instance, the ports that are used to talk to the SQL Server are by default dynamic.<\/p>\n<p>When a client makes a connection to a named instance of SQL Server, it sends a SQL Server Resolution Protocol (SSRP) UDP packet to the server machine User Datagram Protocol (UDP) port 1434.<\/p>\n<p>To set up remote access to a SQL Server named instance go to Start-&gt;Programs-&gt;Microsoft SQL Server 2005\/2008\/2012 -&gt;Configuration Tools and select the SQL Server Configuration Manager.<\/p>\n<p>In the TCP\/IP Properties dialog select the IP Addresses tab and scroll down to IPAII. Set the TCP Dynamic Ports to blank and TCP Port to\u00a0<b>1434<\/b>, and restart the SQL Server&lt;server name&gt; service.<\/p>\n<p>When connecting to a SQL Server named instance SQL Server Browser claims the UDP port 1434. In the SQL Server Configuration Manager make sure that the SQL Server Browser is set to Automatic and Running:<\/p>\n<p><a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/SQLServerBrowserAutomatic.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/SQLServerBrowserAutomatic_s.png\" alt=\"Make sure that the SQL Server Browser is set to Automatic and Running using SQL Server Configuration Manager\" \/><\/a><\/p>\n<p>In the Programs -&gt; Administrative Tools -&gt;\u00a0<b>Windows Firewall with Advanced Security<\/b>\u00a0add a firewall exception for the 1434 port and UDP in the Inbound Rules:<\/p>\n<p><a class=\"zoom\" href=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/SpecificLocalPorts.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/knowledgebase.apexsql.com\/wp-content\/uploads\/2014\/04\/SpecificLocalPorts_s.png\" alt=\"Adding a firewall exception for the 1434 port and UDP in the Inbound Rules\" \/><\/a><\/p>\n<p><strong>3. Still it does not work?<\/strong><\/p>\n<p>No big problem at all, please contact us, we can definitely help! You just need to provide us Teamviewer or Remote Desktop Connection to your SQL Server. We can do the rest for you!<\/p>\n<p>In case you have any other questions, please reach out to us via:<\/p>\n<ul>\n<li><a href=\"https:\/\/litextension.zendesk.com\/hc\/en-us\/signin?return_to=https%3A%2F%2Flitextension.zendesk.com%2Fhc%2Fen-us%2Frequests\" target=\"_blank\" rel=\"noopener\">Ticket system<\/a> (highly recommended)<\/li>\n<li>Email us at <a href=\"mailto:contact@litextension.com\" target=\"_blank\" rel=\"noopener\">contact@litextension.com<\/a><\/li>\n<\/ul>\n","protected":false},"author":1,"featured_media":0,"parent":1550,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_tag":[1662,4191],"class_list":["post-1551","docs","type-docs","status-publish","hentry","doc_tag-how-to-get-nopcommere-sql-server-database-information","doc_tag-nopcommere"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/1551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/comments?post=1551"}],"version-history":[{"count":11,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/1551\/revisions"}],"predecessor-version":[{"id":5617,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/1551\/revisions\/5617"}],"up":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/1550"}],"next":[{"title":"Does LitExtension support migration of product attributes from nopCommerce?","link":"https:\/\/litextension.com\/faq\/docs\/shopping-cart-questions\/nopcommerce\/do-you-support-migration-of-product-attributes-from-nopcommerce\/","href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/4233"}],"prev":[{"title":"How to get Client ID and Client Secret to perform nopCommerce migration?","link":"https:\/\/litextension.com\/faq\/docs\/shopping-cart-questions\/nopcommerce\/how-to-get-client-id-and-client-secret-to-perform-nopcommerce-migration\/","href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/6536"}],"wp:attachment":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/media?parent=1551"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/doc_tag?post=1551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}