SDS ProVal Installation Guide Client & Database Q4 2015.pdf | Microsoft Sql Server | Databases

of 6

Please download to get full document.

View again

All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
PDF
6 pages
0 downs
16 views
Share
Description
ProVal LS Database & Client Software (Trial or Full) Installation Guide Table of Contents Technical Requirements ......................................................................................................................... 1 Licensing ..................................................................................................................................................... 1 Installation of the database using the SQL script ..................................................
Tags
Transcript
  Page | 1  v1401 ProVal LS Database & Client Software (Trial or Full)  Installation Guide  Table of Contents   Technical Requirements ......................................................................................................................... 1 Licensing ..................................................................................................................................................... 1 Installation of the database using the SQL script ........................................................................... 2 Downloading the Client Software ........................................................................................................ 3 Installation of Client Software ........................................................................................................... 3 Re - Installation or Upgrading of Client Software ....................................................................... 3 Running and testing the application ............................................................................................... 4 Timed Trial Database ........................................................................................................................... 4 Customer Database ............................................................................................................................ 4 Registry options ......................................................................................................................................... 5  Technical Requirements Please refer to our Technical requirements document for details. Licensing SDS ProVal is licensed on a named user basis. The Windows user profile will be used to create the licence key. This means a licenced Windows user can log onto any PC and use the software without restriction. It is not a concurrent licence model. Once the licenced number of users have logged in for the first time, no other users will be permitted.  Page | 2  v1401 Installation of the database using the SQL script 1.   Please make sure that the SQL installation is running in ’’mixed mode’’  . If you are unsure, from within SQL Management Studio Program right mouse click on the ‘‘server name’’, go to the security selection in the tree, ‘‘SQL Server and Windows Authentication Mode’’ should be the selected radial button. 2.   Special Note:  All of our applications (ProVal LS & Sequel) use TCP/IP to connect to the SQL server please make sure that this protocol is turned on for your SQL server and you will need to know the listening port number if it is not the default 1433. If you are unsure of how to check this please call us. 3.   Make sure that the logged on user, used by the MSSQL server has Read & Write access to the folder where the backup files are located, we suggest using the server administrator login. 4.   Open the SQL Server Management application and login to the correct instance as a suitable database administrator, ie. 'sa'. Make a note of the 'server/instancename' as the clients will need this to use the correct database when logging into the application. 5.   Go to File open and select the ‘SDSProValWorking Installation Script.sql’ file attached to the email or in your downloaded zip file. 6.   Amend the folder locations on lines 1 5 , 1 6 , in the script file names suit your   server environment if necessary.   The backup folder location must be the same place that you saved the ‘SDSProValWorking.bak’. The script file will do the following:- i.   Create the logins necessary for SDS ProVal, which are SDS User and SDS Query . (Do  NOT  alter the passwords being set otherwise the program will not know how to talk to the database) ii.   An empty database will be created with the correct naming syntax. iii.   Restore the emailed database into the empty database that has just been prepared. iv.   Assign the correct roles to the logins created in i. 7.   Execute the script. This completes the database installation as long as there were no errors. If you do get errors please check the folder and file adjustments that you made earlier and run the script again.  Page | 3  v1401 Downloading the Client Software Click on the following link to access the software downloads page of our website: http://www.s-d-s.co.uk/Client/ApplicationDownload Download the client software and save the zip in a suitable temporary location (your desktop is a good place) . Installation of Client Software 1.   Extract the client ZIP file and you will have either a 32-bit or 64-bit installer available. 2.   Run the .exe installer as an ADMINISTRATOR   3.   Make the required selections and the program files will install into the correct folders. A shortcut will have been created for the ‘‘Desktop’’ as well as in the Shelton Development Services menu selection. 4.   Run the application from the installed folder as an ADMINISTRATOR   for the first time. This allows the .NET platform to compile the program for your particular hardware. (do not use the short cut on the desktop the first time) Re - Installation or Upgrading of Client Software 1.   Un-Install the previous version. 2.   Extract the client ZIP file and you will have either a 32-bit or 64-bit installer available. 3.   Run the setup.exe as an ADMINISTRATOR   4.   Make the required selections and the program files will install into the correct folders. A shortcut will have been created for the ‘‘Desktop’’ as well as in the Shelton Development Services menu selection. 5.   Run the application from the installed folder as an ADMINISTRATOR   for the first time. This allows the .NET platform to compile the program for your particular hardware. (do not use the short cut on the desktop the first time) 6.   When the application logs for the first time after upgrading a database upgrade window might appear and the YES option must be selected. Wait for the database upgrade to finish, then restart the application. Note:    The application won't run correctly until the database is installed.  Page | 4  v1401 Running and testing the application Once the database is installed, start the SDS ProVal LS application. The application will require inputting the 'SQL server name\instancename', then type in 'SDSProValWorking'.  Timed Trial Database If you are using the Timed Trial database two users are pre-programmed into the database and they are: User: Password: Role UserA UserA (Administrators) UserB UserB (General Users) and the passwords match each login name respectively. Note:  Passwords are case sensitive. This User configuration is only valid for Timed Trial databases, for New Supply customers only UserA will exist. Customer Database If you are using a database that has been sent to you as a New Supply, built especially for your organisation, then only the first user, UserA will be active and is set to the Administrator Role although UserA can create new users.
Related Search
Advertisements
Similar documents
View more...
Advertisements
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks