Windows server 2012 r2

[Robert Groom]

I'm looking for help to set up a database, that will allow different users access to certain files in an office environment through our network and also to be able to locate files through remote access.
We have a new Dell Power edge T110 server and windows server 2012 r2 foundation installed.

I would be grateful if anyone can point me in the direction to any tutorials or links, that would enable me to configure this myself. (it would be helpful if there were screenshots in the tutorials)
Alternatively if someone is based in South Wales and they can offer their services at a reasonable cost, I would be interested in speaking to them.

 

[One Step Hosting]

Hi Robert, the easiest way might be to set-up a VPN connection to your server, users can then map to whatever drives you want to share,

there's a guide here: http://blogs.technet.com/b/sbs/arch...vpn-on-windows-server-2012-r2-essentials.aspx

 

[Jon Neale]

Create active directory groups to limit/allow access to specific areas for the users. https://technet.microsoft.com/en-ie/library/dn579255.aspx.

 

[Schnell Solutions]

Hi Robert,

I like your business concept...makes sense to approaching one person to look at cost savings across the board instead of dealing with multiple parties all calming to be cheaper!

Any ways, coming back to you post, do you want to share 'data' or 'files' with your team or is it both?

Needless if you look at the two in isolation, there might be more suitable approach for each viz. using Shared Folder(s), Drop Box, One Drive, Google Drive, etc. for files and lots options for sharing data stored in a database.

We use Drop Box to share files...very convenient as it gives us basic control over 'who' can see/access 'what' and for databases, we use a range of tools, apps and role based access controls. Happy to share our experience over a telephone call

 

[Exascale]

Windows server will allow you to create a PPTP VPN pretty easily. You just need to open the required ports (for PPTP) within your router/firewall. If you need any help please do let us know.

 

[soundengineeruk]

I would recommend before starting configure the server is consider how documents will be stored on your server. You be surprised how quickly a file share can become very unstructured and not easy to restructure as data grows.

As you consider how to structure your data some thought should be given around your security structure as it so easy to have lapsed security on file share solution.

 

[mit74]

hi robert, if you need help with this I'm based in South Wales and know exactly what you need. Feel free to PM me.