I have developed a winform application in C#.net and using SQL Server 2008.
My application inserts and updates values into database.
Is it possible to install the application on a another system which doesn't have sql server on it?
-
1Yes, you can install it. It just won't work without db.Ondrej Janacek– Ondrej Janacek2013-11-17 16:09:32 +00:00Commented Nov 17, 2013 at 16:09
-
Well you just need to be sure, that the Database can be accessed externally and that your application has the right connection settingsDaniel Abou Chleih– Daniel Abou Chleih2013-11-17 16:11:14 +00:00Commented Nov 17, 2013 at 16:11
-
Are the different systems supposed to be sharing the same data, or to have their own separate databases?Dour High Arch– Dour High Arch2013-11-17 22:20:02 +00:00Commented Nov 17, 2013 at 22:20
Add a comment
|
3 Answers
Imagine using sql azure. Cloud based sql server. The database is never on the same physically computer. It's all down to the connection string. With an on premise database you need to make sure the database allows external connections, maybe opening up firewall etc. then make sure the connection string is set correctly on the application to talk to external database. You can even configure to change the connection string as required pointing at different databases depending on the individual requirements. Scott
Comments
Yes, you can. You can access the DB remotely by referring remote DB server in connection string.
Comments
It is possible, if you are looking to run the application on machine that is running on the same Domain as the SQL Server and has privileges to the SQL Server.
