Error 26 - Error locating Server/instance specified

• Gary Cobden

  Ten Centuries

  Points: 1269

  More actions

  March 23, 2010 at 8:08 am

  #220302

  I have a Server with a named instance to which I am unable to connect remotely.

  I can connect to the default instance remotely without problems.

  The named instance has the 'Allow remote connections' options checked on the SQL Server properties - Connections tab

  SQL Server browser is running on the Server

  I have run the following sample query to establish the port

  set nocount on

  DECLARE @test-2 varchar(20), @key varchar(100)

  if charindex('\',@@servername,0) <>0

  begin

  set @key = 'SOFTWARE\MICROSOFT\Microsoft SQL Server\'

  +@@servicename+'\MSSQLServer\Supersocketnetlib\TCP'

  end

  else

  begin

  set @key = 'SOFTWARE\MICROSOFT\MSSQLServer\MSSQLServer\Supersocketnetlib\TCP'

  end

  EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

  @key=@key,@value_name='Tcpport',@value=@test OUTPUT

  SELECT 'Server Name: '+@@servername + ' Port Number:'+convert(varchar(10),@test)

  This returns the following

  Server Name: HARP-DB01\BEST_TEST Port Number:1146

  I have used SQL Client Networking Utility to set up an Alias to the Server using TCP/IP with port 1146 specified but this has no luck

  Windows Firewall is turned off on the Server, and I am now at a loss as to what to try next.

  Assistance please

  Thanks in advance

• joeroshan

  SSChampion

  Points: 10377

  More actions

  March 23, 2010 at 8:35 am

  #1138257

  Have you tried using port number in the connection string?

  http://blogs.msdn.com/sql_protocols/archive/2006/02/27/unable-to-connect-to-a-sql-server-named-instance-on-a-cluster.aspx

  ----------------------------------------------------------------------------------------------------------------------------------------------------
  Roshan Joe

  Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]