Click here to Skip to main content
15,071,430 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi,

I need help. I have one windows base software in VB.net And his database in MS SQL Server. But I want to use this software in two different places than I need to be database online and access one database from two different places.
Posted
Comments
Zoltán Zörgő 28-Feb-15 2:54am
   
In general this is not a matter of coding or Sql Server operation. What connection possibility do you have from your remote locations to your server location?

1 solution

Well, yes...and no.

It is possible - you have to access the SQL server instance as an admin and permit Remote Connections: http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx[^] and probably also configure it's local firewall(s) to open the right ports.

But...it's dangerous.
You will be opening every database on the instance to anyone who has (or can work out) a username / password combination. So you need to start by ensuring that all such SQL logins are secure - and "sa/admin" has got to go for starters!

Personally, I wouldn't do it: I'd write a WCF app to sit on a "local" site to the DB server and make all requests via that. It's a lot more complex, but it's also a lot, lot safer.
   

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




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900