troubleshooting Question

Sql Server Setup, Linking to application

Avatar of mlcktmguy
mlcktmguyFlag for United States of America asked on
Microsoft SQL ServerMicrosoft Access
10 Comments4 Solutions101 ViewsLast Modified:
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.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 4 Answers and 10 Comments.
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>


Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 4 Answers and 10 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004