+ Post New Thread
Results 1 to 5 of 5
Wireless Networks Thread, error: 26 - Error Locating Server/Instance Specified in Technical; I created a rule in ISA Server 2004 to allow access to an MSDE instance on a win server 2003. ...
  1. #1

    Join Date
    Sep 2008
    Posts
    2
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Question error: 26 - Error Locating Server/Instance Specified

    I created a rule in ISA Server 2004 to allow access to an MSDE instance on a win server 2003. When connecting from the computer that I allowed in the rule, I get the message:

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    Does anyone have any suggestions? I have allowed outbound traffic for all users on TCP port 1433 (default Microsoft SQL port) and also allowed access to the port for the named instance.

    When ISA is not installed, I can access the database from any computer.

    Please Help!

  2. #2

    Join Date
    Mar 2009
    Posts
    1
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Post SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

    visit: Share experience between developer: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

    Error when connecting to SQL server:

    Below are steps may try to help:
    1) Make sure your server name is correct, e.g., no typo on the name.
    2) Make sure your instance name is correct and there is actually such an instance on your target machine. [Update: Some application converts \\ to \. If you are not sure about your application, please try both Server\Instance and Server\\Instance in your connection string]
    3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).
    4) Make sure SQL Browser service is running on the server.
    5) If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.

    Best Regard,
    Fellow developer
    -------------------------------------------------------------------------
    Visit Url: Share experience between developer

  3. Thanks to bala4901 from:

    Strotzyl (1st July 2010)

  4. #3

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,673
    Thank Post
    3,205
    Thanked 1,029 Times in 954 Posts
    Rep Power
    361
    Quote Originally Posted by bala4901 View Post
    visit: Share experience between developer: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

    Error when connecting to SQL server:

    Below are steps may try to help:
    1) Make sure your server name is correct, e.g., no typo on the name.
    2) Make sure your instance name is correct and there is actually such an instance on your target machine. [Update: Some application converts \\ to \. If you are not sure about your application, please try both Server\Instance and Server\\Instance in your connection string]
    3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).
    4) Make sure SQL Browser service is running on the server.
    5) If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.

    Best Regard,
    Fellow developer
    -------------------------------------------------------------------------
    Visit Url: Share experience between developer
    as per the question he tried 1433 ( unless that was a typo ) other then that would be good to see if any of the above helps

  5. Thanks to mac_shinobi from:

    Strotzyl (1st July 2010)

  6. #4

    Join Date
    Jun 2007
    Posts
    4
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    Quote Originally Posted by Strotzyl View Post
    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    Does anyone have any suggestions? I have allowed outbound traffic for all users on TCP port 1433 (default Microsoft SQL port) and also allowed access to the port for the named instance.

    When ISA is not installed, I can access the database from any computer.

    Please Help!
    A couple come to mind, have you tried the surface area config for remote connections and also under the security logins for your SQL SVR in management studio put in <DOMAIN>\<SERVER NAME>$ and given rights? (replacing the <> with your settings)

  7. Thanks to Drax from:

    Strotzyl (1st July 2010)

  8. #5

    Join Date
    Sep 2008
    Posts
    2
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Drax View Post
    A couple come to mind, have you tried the surface area config for remote connections and also under the security logins for your SQL SVR in management studio put in <DOMAIN>\<SERVER NAME>$ and given rights? (replacing the <> with your settings)
    I am pretty sure that I tried that, but I will check on Monday. Thanks.

SHARE:
+ Post New Thread

Similar Threads

  1. Server boot error
    By webman in forum Hardware
    Replies: 2
    Last Post: 12th September 2008, 11:15 AM
  2. DNS server error - HELP!!!
    By KWestos in forum Windows
    Replies: 3
    Last Post: 2nd September 2008, 09:49 PM
  3. NOD32 server Update Error
    By cookie_monster in forum Windows
    Replies: 1
    Last Post: 15th July 2008, 11:51 AM
  4. Server Error Message?
    By TechSupp in forum Wireless Networks
    Replies: 3
    Last Post: 19th March 2008, 10:52 AM
  5. Ubuntu Server Error
    By Jackd in forum *nix
    Replies: 5
    Last Post: 2nd October 2007, 08:25 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •