To make Sql Server to be accessed remotely, check the belows.<\/p>\n
1. Use correct server name. The server name is machine name + instance name. e.g.\u00a0My-PC\\SQLExpress<\/p>\n
The server name shouldn’t start with ‘\\\\’<\/p>\n
2. Tick Allow remote connection to this server from the tab Connection of Server Property from\u00a0SQL Server Management Studio.<\/p>\n
3. Enable TCP\/IP Protocol for the SQL server in SQL Server Configuration Mananger.<\/p>\n
4. Check the Port number being used from the TCP\/IP property from the above. and Add Rule to allow income access of TCP Port 1433 (if this is being used) and UDP 1434.<\/p>\n
5. Make sure SQL Server Browser is running. If it’s not running, check if it is disabled.<\/p>\n
<\/p>\n
References<\/p>\n
http:\/\/blogs.msdn.com\/b\/walzenbach\/archive\/2010\/04\/14\/how-to-enable-remote-connections-in-sql-server-2008.aspx<\/p>\n
http:\/\/blogs.msdn.com\/b\/sql_protocols\/archive\/2007\/05\/13\/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx<\/p>\n","protected":false},"excerpt":{"rendered":"
To make Sql Server to be accessed remotely, check the belows. 1. Use correct server name. The server name is machine name + instance name. e.g.\u00a0My-PC\\SQLExpress The server name shouldn’t start with ‘\\\\’ 2. Tick Allow remote connection to this server from the tab Connection of Server Property from\u00a0SQL Server Management Studio. 3. Enable TCP\/IP… Continue reading SQL Server remote access<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[192,191],"class_list":["post-864","post","type-post","status-publish","format-standard","hentry","category-db","tag-remote-access","tag-sqlserver","entry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts\/864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/comments?post=864"}],"version-history":[{"count":2,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts\/864\/revisions"}],"predecessor-version":[{"id":866,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts\/864\/revisions\/866"}],"wp:attachment":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/media?parent=864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/categories?post=864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/tags?post=864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}