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

[cynthia]

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

[Ady]

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

 

 

[cynthia]

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.

[cynthia]

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?

[Ady]

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