Cannot connect to SQL Server 2008 after use Hide Instance option

• thang_ngo_2002

  SSCrazy

  Points: 2187

  More actions

  August 23, 2011 at 11:48 am

  #256062

  In my SQL 2008, I setup Hide Instance=Yes from TCP/IP setting in order to make our DB be more secure.

  But after that our application can not connect to SQL Server, even I use Management Studio in this server but I aslo cannot connect to SQL Instance, I get error 26.

  Please help me what to do ?

  Thanks

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  August 23, 2011 at 1:41 pm

  #1372247

  The following would be of help to you.

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

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• thang_ngo_2002

  SSCrazy

  Points: 2187

  More actions

  August 24, 2011 at 4:36 am

  #1372453

  But I just have problem when I change "Hide Instance" to Yes. I don't have this issue before.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 24, 2011 at 4:13 pm

  #1372879

  Since this keeps the SQL Browser service from exposing it, I'm going to say that your application will need to provide the port in addition to the server name/IP Address.

  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

• thang_ngo_2002

  SSCrazy

  Points: 2187

  More actions

  August 25, 2011 at 1:51 am

  #1372973

  I find out the issue, I forgot port parameter in connection string. Now it's OK. Thanks.