Connecting to Remote database from C# Application

arnabghosh · August 16th, 2010, 03:34 PM

Hi All,

I have developed a C# Windows application that is installed in all the machines of LAN based system. The database - SQL Server2000 is installed in the server machine. I need to access the databse from all the clinet machines in the network.

I am using connection string setup in the config file to do the database handling. This works fine on the server machine as the application can connect to the local database with the connection string, but from the client machine the application is not able to connect to the server's database. I am using the following config file:

Code:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    <add key="ApplicationTitle" value="Order Management System" />
    
  </appSettings>
  <connectionStrings>
    <add name="ConnectionString" connectionString="uid=sa; pwd=pass; database=NewOMS; server=NEXTGEN\DEVLOPER"
    providerName="System.Data.SqlClient" />
  </connectionStrings>
</configuration>

Here
server = Server computers name/SQL Server Instance Name
database = database name
uid = SQL Server's default username
pwd = SQL Server's default password

My Application is installed to the client machines using a Windows Installer.
Please let me know where I am getting wrong. Is there any special setup during making of the installer to connect from client machine to remote SQL Server.

Any help would be appreciated.

Thanks n Advance

om_prakash · August 17th, 2010, 12:52 AM

Please check the following link on different options to connect to SQL server:
http://www.connectionstrings.com/sql-server

melvik · October 13th, 2010, 01:06 AM

dear friend,
ur connectionString is OK! but maybe ur server doesnt allow remote connection!?
or u may have to config ur Server I mean IP & ALIAS in ur machines.

let me know :)