Telerik.OpenAccess.Exceptions.DataStoreException: Unable to reach database server on host

5 posts, 1 answers
  1. cynthia
    cynthia avatar
    4 posts
    Member since:
    Jun 2014

    Posted 14 Jun 2014 Link to this post

    hello


    Please i have designed a windows application and i created a set up
    deployment project for it and deployed it in the client side is
    displaying well but each time i try querying the database i get the
    following error



    Telerik.OpenAccess.Exceptions.DataStoreException: Unable to reach database server on host ''.
    Error Details:A network-related or instance-specific error occurred
    while establishing a connection to SQL Server. The server was not found
    or was not accessible. Verify that the instance name is correct and that
    SQL Server is configured to allow remote connections. (provider: SQL
    Network Interfaces, error: 26 - Error Locating Server/Instance
    Specified)
     ---> Telerik.OpenAccess.RT.sql.SQLException: A
    network-related or instance-specific error occurred while establishing a
    connection to SQL Server. The server was not found or was not
    accessible. Verify that the instance name is correct and that SQL Server
    is configured to allow remote connections. (provider: SQL Network
    Interfaces, error: 26 - Error Locating Server/Instance Specified)
    ---> System.Data.SqlClient.SqlException: A network-related or
    instance-specific error occurred while establishing a connection to SQL
    Server. The server was not found or was not accessible. Verify that the
    instance name is correct and that SQL Server is configured to allow
    remote connections. (provider: SQL Network Interfaces, error: 26 - Error
    Locating Server/Instance Specified)




    please i have disabled theTCP/IP in the sql configuration of the client
    machine yet it still persist. please  ineed a solution to this as soon
    as possible.



    thank you
  2. Ady
    Admin
    Ady avatar
    589 posts

    Posted 18 Jun 2014 Link to this post

    Hello Cynthia,

     Are you sure all the values specified in the connection string are valid? Can you connect to the database using Sql Server Management Studio?
    Can you try testing the connection string you use in a simple ADO application? Just create a SqlConnection instance, set the connection string value and open the connection (connection.Open())

    Do get back with your findings.

    Regards,
    Ady
    Telerik
     
    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
     
  3. DevCraft banner
  4. cynthia
    cynthia avatar
    4 posts
    Member since:
    Jun 2014

    Posted 27 Jun 2014 in reply to Ady Link to this post

    thanx for your reply i have done exactly as u adviced i have created a mini ado application yet if i deploy it on the client computer it doesn't save but it doesnt give me any error message. below is my connection string when i deploy the application.

    <configuration>
      <connectionStrings>
        <add name="InvoiceDBConnection" connectionString="data source=ULOMA\SQLEXPRESS;initial catalog=InvoiceDB;integrated security=True" providerName="System.Data.SqlClient" />
      </connectionStrings>
    </configuration>


    also i can create the database in the management studio in my deployment machine. please i need a response as soon as possible. please help me to resolve this issue as my client is tired of my excuses.

    thank you.
  5. cynthia
    cynthia avatar
    4 posts
    Member since:
    Jun 2014

    Posted 27 Jun 2014 in reply to cynthia Link to this post

    Also the sql server on my development machine is 10.0.4000 while in my deployment machine is 10.50.4000 please could this be the issue? if yes how do i resolve this?
  6. Answer
    Ady
    Admin
    Ady avatar
    589 posts

    Posted 30 Jun 2014 Link to this post

    Hi Cynthia,

     There could be a number of reasons why you cannot connect to the database server from the client machine. Please follow the steps mentioned in this blog to narrow down and fix the problem. Similar steps are also mentioned in this StackOverflow answer.

    Do get back in case you need further assistance.

    Regards,
    Ady
    Telerik
     
    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
     
Back to Top
DevCraft banner