About How to share SQL Database in windows application

You haven't really provided enough information for us to be able to help - we don't know the first thing about the application or its database to be able to say anything we can be sure will be meaningful.

Most importantly it would help if you told use the technology of the database. Is it MS Access? MS SqlServer? Oracle? MySql? MongoDB? Something else entirely?

Is it a server-based database or is it file-based database?

You say you want to access the database from some other computer by using the same application. Do you mean 'by using the application on the server as a conduit' (probably not)? Do you mean 'by installing the application on the other computer, but referencing the data stored on the server'? I would start by reading the installation guide for the application, paying special attention to the section (if any) that relates to having the application and its data on distinct computers.

Let me understand this.
Your db is in dbserver1 and your application app1.exe is in appServer1. Now u want to access the db from appServer2 using ur app1.exe. In this case, as this is windows application, move ur app1.exe to appServer2 and run it from there. Also check if u dont have any connectivity problem to your dbServer1 from appServer2.

You can't use AttachDbFilename to connect to remote database.
Check this link http://support.microsoft.com/kb/914277[^]

First check if remote connection is enabled for the db server.
To enable follow this link.
http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

Once this is done then modify your connection string like this:
Data Source=SOFTZEAL-2-PC\SQLEXPRESS;Initial Catalog=Database;Integrated Security=True;User Instance=True; User ID=kishor;PWD=kishor123