Register now or log in to join your professional community.
As per my understanging i think that your question is something like this ... That you want to keep your database intact on the same space where as different users with different application(Win/Web) should be able to access the same DB server from client end
If you want your window application to communicate to DB server then this can possibly done with the help of SOAP protocol. I mean to say that you can write web service that can communicate to your DB Server and and then your Client application can communicate to DB Server using web services.Basicaly those Web Services will act as an intermediate for your application and DB Server. That means it transfer Data to or from application to DB Server.
What exactly you want to do in client PC. IF you want to Install Database in Client PC, you can do it with SQL server Express edition, IF you want only client tools, you can install them in PC without any trouble. If you want to use SSIS from Client, Install integration servicess in client pc and connect to Server.
I mean that the SQL server Database Will face some difficulties in Configurationon the Client Side and I'm sorry for miss-understand So I expect that you explain the case in details , I appreciate your help .
Using web services we can connect to server DB from all Clients windows application. Soap protocol will communicate to DB for each client.
If the client want to connect via web then you can build web service, however if the client is on LAN then it can directly connect to server via local machine's SQL server driver(you have to install it if its not already installed, can possibly package with your application)
