We help IT Professionals succeed at work.
Get Started

Sql Server Setup, Linking to application

Last Modified: 2016-04-15
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.
Watch Question
This problem has been solved!
Unlock 4 Answers and 10 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE