How to create a database on install on server which should be accessible by all the computers in LAN?

Question

1.00/5 (1 vote)

See more:

I have a requirement such as an app is installed on a particular system which is a server on a lan. Here the administrator provides some configuration settings and save it in an ini file. When the other computers on the LAN opens the windows forms application, the ini file should be read and then the application is launched according to the file settings. I know this might not be possible due to permissions and all. So I was thinking maybe during installing the app on the server it creates a SQL database and store the settings in the tables. When the client computers on LAN run the application they just read the database on the server and do the same. I just have this idea but I am not sure is it achievable and if it is can someone throw some insight on it. '

Any help is appreciated. Thanks in advance

Posted 27-Apr-14 19:36pm

Ankit Chaturvedi

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2014-04-27T20:55:00

do you have sql server or any other database server? is it accessible from other machines in you LAN? then you can create database on that DB server and your client application can connect to database server with database connection string.

check below links for how you can secure connection string data
http://msdn.microsoft.com/en-us/library/89211k9b(v=vs.110).aspx[^]
http://msdn.microsoft.com/en-us/library/ms178372(v=vs.100).aspx[^]
Encrypting windows application connection strings[^]
http://www.asp.net/web-forms/tutorials/data-access/advanced-data-access-scenarios/protecting-connection-strings-and-other-configuration-information-cs[^]

RahulMGunjal · Answer 2 · 2014-04-28T01:09:00

Are you using SQL Server database? If yes -
-while installing, install it in Mixed Mode Authentication
-Install SQL Server Management Studio on the same machine
-Start SQL Server Management Studio.
-Login with User Name and Password provided while installation
-You will see SQL Server instance name something as MYPC/SQLEXPRESS (if you are using Express edition)
-Build connection string
-Use in your app and connect to the database over network.

Make sure you have proper setting in Firewall & anti virus software, which may block your connection to database.

How to create a database on install on server which should be accessible by all the computers in LAN?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0