+ Reply to Thread
Results 1 to 6 of 6

error:26 Error Locating Server/Instance Specified

  1. error:26 Error Locating Server/Instance Specified

    I am having trouble connecting to Sql Server 2005 Express from asp.net
    2.0 app on Windows Server 2003. I am using Sql Server Authentication,
    and I tried the below article's suggestions a number of times. When I
    login to to the machine, and login, I am able to get authenticated.
    However, when I debug my application, I get the error below. Do I have
    to give the sql server authenticaed account I created certain
    permissions? Whould I set a port, and use the ipaddress rather than
    the server name? Any suggestions would be greatly appreciated.

    http://support.microsoft.com/kb/914277

    My Error:

    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)

    My Connection String:
    value="server=MyServerName;uid=MyUserName;pwd=MyPasswd;database=MyDB"/>

  2. Re: error:26 Error Locating Server/Instance Specified

    On Feb 1, 5:20*pm, carlos wrote:
    > I am having trouble connecting to Sql Server 2005 Express from asp.net
    > 2.0 app on Windows Server 2003. I am using Sql Server Authentication,
    > and I tried the below article's suggestions a number of times. When I
    > login to to the machine, and login, I am able to get authenticated.
    > However, when I debug my application, I get the error below. Do I have
    > to give the sql server authenticaed account I created certain
    > permissions? Whould I set a port, and use the ipaddress rather than
    > the server name? Any suggestions would be greatly appreciated.
    >
    > http://support.microsoft.com/kb/914277
    >
    > My Error:
    >
    > 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)
    >
    > My Connection String:
    > * > value="server=MyServerName;uid=MyUserName;pwd=MyPasswd;database=MyDB"/>


    Update:

    I changed the connection string to use the ipaddress, and a port that
    I set in the TCPIP settings, and now i'm getting the below 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: TCP Provider, error: 0 - No connection could
    be made because the target machine actively refused it.)

    I'm thinking this may be a permission problem??


  3. Re: error:26 Error Locating Server/Instance Specified

    Hi Carlos,

    By default, SQL Server 2005 Express, Evaluation, and Developer editions
    allow local client connections only. Enterprise, Standard, and Workgroup
    editions also listen for remote client connections over TCP/IP.

    you ned to enable Remote Connections option using

    Surface Area Configuration for Services and Connections (Remote Connections)
    - Database Engine

    You must restart the Database Engine instance's service to apply changes.

    Regards,
    Amol R. Lembhe

    "carlos" wrote:

    > On Feb 1, 5:20 pm, carlos wrote:
    > > I am having trouble connecting to Sql Server 2005 Express from asp.net
    > > 2.0 app on Windows Server 2003. I am using Sql Server Authentication,
    > > and I tried the below article's suggestions a number of times. When I
    > > login to to the machine, and login, I am able to get authenticated.
    > > However, when I debug my application, I get the error below. Do I have
    > > to give the sql server authenticaed account I created certain
    > > permissions? Whould I set a port, and use the ipaddress rather than
    > > the server name? Any suggestions would be greatly appreciated.
    > >
    > > http://support.microsoft.com/kb/914277
    > >
    > > My Error:
    > >
    > > 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)
    > >
    > > My Connection String:
    > > > > value="server=MyServerName;uid=MyUserName;pwd=MyPasswd;database=MyDB"/>

    >
    > Update:
    >
    > I changed the connection string to use the ipaddress, and a port that
    > I set in the TCPIP settings, and now i'm getting the below 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: TCP Provider, error: 0 - No connection could
    > be made because the target machine actively refused it.)
    >
    > I'm thinking this may be a permission problem??
    >
    >


  4. Smile Re: error:26 Error Locating Server/Instance Specified

    hiii,can anybody solve this?

    I am having trouble connecting to Sql Server 2005 Express from asp.net
    2.0 app on Windows Server 2003. I am using Sql Server Authentication,
    and I tried the below article's suggestions a number of times. When I
    > > login to to the machine, and login, I am able to get authenticated.
    > > However, when I debug my application, I get the error below

    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)


    i did follg changes also but still the error is thr

    Surface Area Configuration for Services and Connections (Remote Connections)
    - Database Engine

    restarted the Database Engine instance's service to apply changes.


    plz plz help asap as i m trying 2 solve this from last 1 week
    thanks

  5. Re: error:26 Error Locating Server/Instance Specified

    You can look to this post:
    http://fellowdeveloper.blogspot.com/...-26-error.html

    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,
    FellowDeveloper :)
    --------------------
    Http://www.fellowdeveloper.blogspot.com

  6. Re: error:26 Error Locating Server/Instance Specified


+ Reply to Thread