sql connecting problem form ip of local server

Question

hello sir 

i have counfigured sql server 2008 r2

when iconnect sql database engine using  ip\"instance name" it show me error  (ip address of local server)

 

i got same error when i am connecting only ip without insatbce name "cannot connect to (ip)"

but i can connect with .\"incatance name"  and   "pc name"\"instance name"

i need to access from ip\"inctance name"

any one have this type of solutions ?

then plz help me

i have also check this options

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

Answer 1

Hi,

Try below links:

http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/ed7b78c0-7dcb-4be7-96fa-f85b74f0e413/sql-network-interfaces-error-26-error-locating-serverinstance-specified

http://stackoverflow.com/questions/13754563/sql-network-interfaces-error-26-error-locating-server-instance-specified

---

sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

Answer 2

Please Enable TCP/IP protocol from SQL Server Configuration manager like follow figures:

---

sqldevelop.wordpress.com

Answer 3

that option is allready enabled but the problem not solved

Answer 4

Check if sql server is configured to listen on that IP address. If your server has multiple IP addresses that doesn’t necessarily mean that it can automatically accept connections from all IPs

Also

http://stackoverflow.com/questions/1339944/cant-connect-to-localhost-but-can-with-computer-name-in-sql-server-2008

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence