My firm is doing our first SQL Sever project so we are definitely NUB's.
MS Access 2013 is the Front End and we are using SQL Server Developer 2014 for the backend DB.
Our first step was to install SQL Server Developer 2014 on each of the workstations involved in the project. After that I created a 'File' DSN on the local machine and the developers were able to link to the SQL DB and do some preliminary testing/conversion work. The only DB's the local machines could use, was the one on their machine.
This setup has been working well to get the staff familiar with using SQL Server.
The next step is to install SQL on our office server. This step has been completed, so the DB is sitting on the server but none of the local machines can see it.
Now we need the individual workstations to be able to see/link to the SQL Server DB on our office server. At this point I'm unsure of the next step, which I believe is setting up DNS(s) to link to SQL on our office Server.
Do each of the individual machines set up there own DSN to link to the instance on the server, or is the DSN set up on the server and referenced by the local machines?
I see three types of DSN's, 'User', 'System' and 'File'. As I mentioned above, up to this point we have created 'File' DSN's on each of the local machines which connect to the SQL DB on the local machine. What type of DSN will be used to connect to the SQL DB on our office Server?
Any help with the next step would be appreciated.