How to implement a connection to 1c from several offices?

Question

System administration

There is an sql database that we will put on a remote server.
It is necessary that several offices connect to the database and work through client applications (thin client)
. Ideally, the boss wants to see that the offices are united into one local network and says something about vpn, although I don’t quite understand why he needs this vpn.
According to the idea, you need to:
1. order a hosting based on Windows 2012 server
2. install a sql database there
3. each office configures the 1c client program on each computer to work with a remote sql database using the server ip address
4. to access the server files, you can connect each computer through a network drive
5. the question remains how to make computers from two or three offices visible to each other and whether a dedicated ip is needed for each office
Correct the sequence and whether I am reasoning correctly.
There is no full-time system administrator and admin 1c.
1s 8.3
The option to use cloud technologies turned out to be expensive, at least 6-8 people will be connected at the same time.

Answer 1

I will answer the question myself, especially since a lot of time has passed and we can summarize:
1. We rented a VPS from a hosting provider and installed Windows there. Windows license is included.
2. Installed the 1C SQL database
3. Installed a 1c thick client on each office / home computer
4. Connect to the server by ip address
5. Everyone is happy and cheerful.
6. The cost of the server is about 1500 rubles per month, enough for 10 users at the same time. There are no brakes.

Answer 2

5. the question remains how to make computers from two or three offices visible to each other and whether a dedicated ip is needed for each office

For everyone - is not present, for the server - it is necessary. How to combine computers into one local network - I suspect that it will help you ... VPN ! (suddenly). Which can run on the same server as the DB.
If very briefly - the essence is the same as that of the router, all computers connected to the router automatically fall into the same network and receive one of the addresses from the IP range 192.168.0.XX (usually). In your case - the same situation, only instead of a router there will be a server (VPN).
As an added security bonus, you can allow only VPN clients to connect to your database on the server, which would drastically reduce the likelihood of hacking attempts from outside, as well as encrypt traffic between clients and the base (VPN is usually encrypted).
Somewhere between the lines, I had to insert a manual for setting up Windows and the network in it, but for me it's a very dark and dense forest, so unfortunately I can't tell you about setting up Windows.

Answer 3

budget
1. order hosting based on Windows 2012 server
2. install 1C 8.3 sql there (again, what is it as a sql server? postgres is free)
3. each office sets up a 1c client program on each computer to work with a remote sql database by the ip address of the server
4. to exchange documents use virtualbox or something similar
a richer option
1. to organize a vpn, it's good to install a separate vpn server with an external and internal interface in front of the winserver. thus winserver does not shine in the internet
2. winserver with vpn server in the intranet. this is good
3. install 1C, database, terminal service. Thus, all users work on the same server and the exchange of documents between them is carried out through a shared folder. this is speed
4. forwarding documents and printing is carried out using the rdp protocol (inside the connection channel)
well, you also need to think about backup in both cases
Whatever you choose, this scheme will have to be accompanied. It is better to hire an admin initially
and you get it - cloud technology. Only very mini

Answer 4

Take a dedicated server and set up a server + 1c + sql + web
Buy a domain + set up HTTPS Drive
all users to work via the web, all connections go via https, everything is encrypted = the boss is happy.
If you need information exchange between users, raise any file storage, you can use the same NextCloud.

Answer 5

Cloud 1c is very cheap, obviously cheaper than your option

Answer 6

1. order hosting based on windows 2012 server

Need everything exclusively white? Many still order abroad. When ordering hosting with Windows, you will have to pay for a license. You can rent a piece of iron, roll into the OS yourself. Better hypervisor to allow virtual machines to solve their problems, get flexibility and portability. Read ESXi, HyperV, Proxmox

2. install sql database there

SQL database and server 1C-Enterprise

3. each office sets up on each computer the work of the client program 1c to work with a remote sql database by the ip address of the server

it's like that

4. to access the server files, you can connect each computer through a network drive

or, in principle, work with everything terminally, depending on the tasks

5. the question remains how to make computers from two or three offices visible to each other and whether a dedicated ip is needed for each office

a dedicated IP is needed for the office where the VPN server is located, the rest is not needed. Everyone will see everyone in the way you want when setting up a VPN server. Here the problems are only in sudden pitfalls, but everything that you can imagine is realizable and there are a lot of articles on the Internet, the topic is popular.

Answer 7

order hosting based on windows 2012 server

Yes, although it is possible on the basis of linux server.

each office sets up on each computer the work of the 1c client program to work with a remote sql database by the ip address of the server

Wrong, 1s by IP will not work, only by name.

to access server files, you can connect each computer through a network drive

What files are on sql server? A network drive is a bad idea.

the question remains how to make computers from two or three offices visible to each other and whether a dedicated ip is needed for each office

It is completely incomprehensible why you need the visibility of computers, and why you need a dedicated ip for each office.

Answer 8

1sniks have their own 1cfresh technology, for example (clarifications, prices and features on the official website)
You can publish it on the web through 1cLink, the address will be like https://domain.link.1c.ru/ (1link works on Apache)

Answer 9

1. order hosting based on windows 2012 server

Ready to pay for a Win2012 license? Go ahead, I'm happy for you. Not ready? Then linux is your everything, 1C supports it.
Ready to pay for MS SQL too? I am doubly happy for you. Not ready? Postgres is everything. Under linux :)
Oh, you're also a Windows security expert? Only a truly knowledgeable person would risk exposing a data server to the Internet . I made a mistake? Then linux is definitely your everything. Well, either Windows and a router (on a linux) are ahead.
Yopt, you probably write cryptors with one hand ... Because only a person who knows all the giblets of cryptors is able to easily put communication channels on the Internet like this. Not? Then a VPN is your everything.
Not. The question remains - how to make sure that your data is not blocked and encrypted on the very first day of operation of this truly enchanting nonsense :)
Listen to the old crocodile - hire a specialist :) In LAN, what you expect - it would probably work. In the global network, you, excuse me, are talking such enchanting nonsense that I won’t even explain what is wrong in it :)

Answer 10

1C: Fresh

Answer 11

Options:
Whether or not you need a VPN depends on the level of security you want.
You can rely on RDP encryption or HTTPS encryption. But do not forget that they will be available from anywhere. A VPN can naturally be made available only from those computers that have a key, for example.