October 20, 2014 at 6:39 am
hi,
am trying to connect the SQL server 2104 from one machine to other , but am unable to connect.
showing error as below.
A network or instance related error occurred while establishing connection with SQL sever.the server was not found or not accessible. verify that instance name is correct and SQL server is allowed to connect remote connections.( Provider: SQL server interfaces error 26 Error locating server/instance specified)( Microsoft SQL server).
please help me to fix this.
October 20, 2014 at 9:33 am
You need to Enable a network protocol to allow connectiosn to the SQL Server. Here's an article on how to do it, http://msdn.microsoft.com/en-us/library/ms191294.aspx. If that doesn't work you also have to allow traffic through windows firewall to that address and port, here's an article on how to do that, http://technet.microsoft.com/en-us/library/ms175043(v=sql.120).aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 21, 2014 at 1:17 am
Hi,
firewall is completely off on both machines, where am able to connect in one way (i.e from A to B) and not in other way (i.e from B to A). please help.
October 21, 2014 at 8:00 am
sheik.kalidh (10/21/2014)
Hi,firewall is completely off on both machines, where am able to connect in one way (i.e from A to B) and not in other way (i.e from B to A). please help.
Have you verified that the SQL Server is set to allow remote connections?
You need to Enable a network protocol to allow connectiosn to the SQL Server. Here's an article on how to do it, http://msdn.microsoft.com/en-us/library/ms191294.aspx.
When you say you can connect from A to B not B to A do you mean you have SQL Server installed on both machines or you can ping or RDP from B to A?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply