Link to home
Start Free TrialLog in
Avatar of mlcktmguy
mlcktmguyFlag for United States of America

asked on

Sql Server Setup, Linking to application

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.
SOLUTION
Avatar of David Sankovsky
David Sankovsky
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mlcktmguy

ASKER

Sorry, I haven't abandoned the question just haven't had a chance to try anything of the suggestions yet.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for all the suggestions although I don't really know how to implement most of the them.  I'm trying to locate someone in the area that can assist me with this.

The person that installed SQL Server on the office server is unfortunately no longer available.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I am getting abandoned notices on tis question.  I have not abandoned it but have not been able to implement any of the above suggestions yet.
Thank you all for your assistance
mlcktmguy, if your issue as been solved please elect one or more comments provided by the experts as the best and assisted solution.
I thought I had done that last night.  I will try again this morning.