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:
<?xml version="1.0" encoding="utf-8" ?>
<add key="ApplicationTitle" value="Order Management System" />
<add name="ConnectionString" connectionString="uid=sa; pwd=pass; database=NewOMS; server=NEXTGEN\DEVLOPER"
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