![Page 1: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/1.jpg)
How to Setup SQL Server in School SoftwareOn Server PC
![Page 2: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/2.jpg)
By Default it takes MS Access as Database Backend
If you wish to use SQL Server as backend, then you need to select 2nd Option i.e. “Multi User Environment
(SQL Server)”
![Page 3: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/3.jpg)
Click on Settings
Enter your Server Name and Other Details
![Page 4: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/4.jpg)
SQL Server 2005 must be installed on your PC, if you want to use SQL Server as backend
You can download SQL Server 2005 Express From
https://www.dropbox.com/s/wp3u3txyyspi736/SQLEXPR_ADV.EXE?dl=0
*PC Users must have rights to create a database in SQL Server
*All the rights to read / write database must be enabled for all users.
HOW to know your server name…?
1) Open SQL Server Management Studio2) In the first screen, you will get your server name3) Copy this server name4) And paste in your school software’s setting screen5) Click on Save my Settings
![Page 5: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/5.jpg)
![Page 6: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/6.jpg)
![Page 7: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/7.jpg)
![Page 8: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/8.jpg)
Remember to give a good password for the super user of your company
![Page 9: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/9.jpg)
On Client PC
On Client machine, you need to create a DSN pointing to database created on Server PC
1) Open Control Panel Administrative Tools
![Page 10: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/10.jpg)
Open “Data Sources (ODBC)”
![Page 11: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/11.jpg)
![Page 12: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/12.jpg)
![Page 13: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/13.jpg)
![Page 14: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/14.jpg)
![Page 15: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/15.jpg)
![Page 16: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/16.jpg)
![Page 17: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/17.jpg)
![Page 18: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/18.jpg)
![Page 19: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/19.jpg)
Now your DSN Setting is complete
Here you need to create a new Company on Client machine and point its Setting with DNS
![Page 20: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/20.jpg)
The DNS name must you created on Client machine must be appearing in the list of ODBC Connection. Choose the correct one and continue
Same procedure need to be followed on all client machines
![Page 21: ampletrails.com · Web viewIf you wish to use SQL Server as backend, then you need to select 2 nd Option i.e. “Multi User Environment (SQL Server)” Click on Settings Enter your](https://reader036.vdocuments.us/reader036/viewer/2022070707/5e9fdf90170e753b2b113bb9/html5/thumbnails/21.jpg)