Installing my application on two machine

Question

1.00/5 (1 vote)

See more:

I installed my Windows Form Application developed by using C# 2.0 and SQL Server 2005 on two machines reside in same place. Will I have to install SQL Server 2005 on both machines???
If yes, then how the user can it.??? If not, then what I have to do??
Please suggest me good solution. Thanks

Posted 14-Aug-13 8:06am

Md M Ahmad

Add a Solution

Comments

[no name] 14-Aug-13 14:12pm

Well SQL Server has to be installed somewhere in order for your users to use your database. Either on their computer individually or a common server. Up to you.

nithibs 30-Aug-13 6:58am

Well, the same above question arises for me also. if a client needs to install my exe on another machine how can he/she individually install the exe. Whether they also needs to install the sql server and should change the connection string??

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)

OriginalGriff · Answer 1 · 2013-08-14T08:13:00

NO!

That's the whole idea - SQL Server is a SERVER database - multiple users make requests to SQL Server, it coordinates them with the database file and serves up the results. If you install a second instance for your second PC, then it will use a different database file and you will not be able to share information between your users.

All you (probably) need to do is change the Connection String on one of the PCs to point at the other PC (unless you installed SQL server on a third PC in which case it should just work provided they are on the same LAN, and well done!)

Having said that, I have two installations of SQL Server: one for production and one on my PC for development. That way, If I perpetrate a cockup when altering the code it does not affect the production data in any way. That's because there is no data shared between the two SQL instances.

ZurdoDev · Answer 2 · 2013-08-14T08:11:00

Solution 1

When you wrote your code you should have a Connection String which is how you tell your code how to connect to SQL. So, no, you just need 1 SQL Server that both machines can access.

Posted 14-Aug-13 8:11am

ZurdoDev