mlcktmguy
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
The person that installed SQL Server on the office server is unfortunately no longer available.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
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.
ASKER
I thought I had done that last night. I will try again this morning.
ASKER