![\"error\"](\"https:\/\/qbytes.cloud\/wp-content\/uploads\/2015\/04\/error.png\")
<\/a><\/p>\nInstrucions to enable MSSQL remote connecton.<\/p>\n
Run SQL Server Configuration Manager. Protocols for MSSQLServer<\/p>\n The next good thing to check is the SQL Server Network Configuration. Open the SQL Server Configuration Manager, unfold the node SQL Server Network Configuration and select Protocols for MSSQLServer (or whatever the name of your SQL Server instance is).<\/p>\n Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.<\/p>\n Make sure TCP\/IP is enabled.\u00a0Right-click on TCP\/IP and select Properties.<\/p>\n Now:<\/p>\n Select the IP Addresses Tab.\u00a0Verify that, under IP2, the IP Address is set to the computer’s IP address on the local subnet.<\/p>\n Make Sure the SQL Server Browser is running. Go to Services and set the start to automatic. Then start the service.<\/p>\n Add a firewall rule to allow port 1433<\/p>\n Make user Remote Connections are enabled on your SQL Server database.<\/p>\n Open SQL Server 2008 Management Studio, connect to the server in question, right click the server.<\/p>\n Navigate to Connections and ensure that Allow remote connections to this server is checked.<\/p>\n Other resources:<\/p>\n http:\/\/blogs.msdn.com\/b\/walzenbach\/archive\/2010\/04\/14\/how-to-enable-remote-connections-in-sql-server-2008.aspx<\/a> You experience the following error message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69],"tags":[],"class_list":["post-2074","post","type-post","status-publish","format-standard","hentry","category-mssql"],"_links":{"self":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/2074","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/comments?post=2074"}],"version-history":[{"count":0,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/2074\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/media?parent=2074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/categories?post=2074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/tags?post=2074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a>
\nScroll down to IPAll.\u00a0Make sure that TCP Dynamic Ports is blank.\u00a0Make sure that TCP Port is set to 1433.<\/p>\n<\/a>
\nApply and Click OK.<\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n
\nhttps:\/\/msdn.microsoft.com\/en-us\/library\/ms191464.aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"