SQL Server 2008 Express Setup/IDAttend Instruction
Contents
1. On the installation center screen choose Installation from left hand menu Then choose new SQL server stand alone Installation tw SQL Server Installation Center a Oj x Planning Sie New SOL Server stand alone installation or add features to an existing installation Installation Launch a wizard to install SQL Server 2008 in a non clustered environment or to add features to an existing SQL Server 2008 instance Maintenance aes New SOL Server Failover cluster installation ools Launch a wizard to install a single node SQL Server 2008 Failover cluster Resources SP Add node to a SOL Server Failover cluster Advanced PAS y if Launch a wizard to add a node to an existing SOL Server 2008 Failover cluster Options y Upgrade from SQL Server 2000 or SQL Server 2005 Launch a wizard to upgrade SQL Server 2000 or SQL Server 2005 to SQL Server 2008 Before you upgrade you should run the Upgrade Advisor to detect potential problems P Search for product updates Search Microsoft Update for SQL Server 2008 product updates Mikrosoft e gt L Server2008 Then wait for support files to be installed click next and when it shows product key click next e Specify a free edition Eres e Enter the product key e Tick to Accept the terms then click next and then click install SOL Server 2008 Setup iol xi Setup Support Files Files will be installed and once complete click next NE soL Server 2008 Setup eee S2. Startup Type LITYINETWORK SERVIC Automatic Use the same account for all SQL Server services These services will be configured automatically where possible to use a low privilege account On some older Windows versions the user will need to specify a low privilege account For more information click Help Service Account Name Password SQL Server Database Engine Service Account Name Password Startup Type NT AUTHORITYLOCAL 5 SOL Server Browser lt Back Next gt Cancel Help 4 Set authentication to windows authentication mode Click Add Current User Click Next Pte SQLServer 2008 Setup Database Engine Configuration Specify Database Engine authentication security mode administrators and data directories Setup Support Rules Account Provisioning Data Directories User Instances FILESTREAM Feature Selection Instance Configuration Disk Space Requirements Server Configuration Specify the authentication mode and administrators for the Database Engine Authentication Mode Windows authentication mode Database Engine Configuration 9 9 Mixed Mode SQL Server authentication and Windows authentication Error and Usage Reporting Built in SQL Server system administrator account Enter password Confirm password Specify SQL Server administrators Installation Rules Ready to Install Installation Progress Complete SQL Server administra
3. Feature Name Status Setup Support Files Gathering user settings lt Back HE i Cancel After some progress it will display the Setup Support rules page click next Setup Support Rules Setup Support Rules identify problems that might occur when you install SQL Server Setup support files Failures must be corrected before Setup can continue Setup Support Rules Operation completed Passed 10 FailedO Warning O Skipped 1 en HOD ASA SGER ACODER RA ER BRR RRB Ree NNA License Terms Show details gt gt Re run Feature Selection view detailed report Disk Space Requirements Error and Usage Reporting Installation Rules Ready to Install Installation Progress Complete lt Back _ se Cancel Help Important On the Installation Type screen Choose Perform a new installation of SQL Server 2008 Do not try to add a feature to an exisiting instance of SQL SQL Server 2008 Setup IDATTEND SQLEngine 10 0 1600 22 Express Click Next on the product key screen Tick to accept the terms on the License terms screen Then on the feature selection screen choose Managment Tools Basic SQL Server 2008 Setup me i alj Instance Features Shared Features M Management Tools Basic SQL Client Connectivity SDK Redistributable Features Check the disk space requirments and click next On the error and Usage Reporting screen click next And on the Inst
4. Ltd M 0409009943 E kevin idattend com au
5. Runtime and let install Local Admin rights may be required for this to install Create a shortcut to Server IDAttend System IDAttend exe Copy shortcut to the desktop Note The IDAttend runtime install does not install any shortcut to IDAttend exe on the server IDAttend is now ready to be used on the workstation IDAttend SQL Server Express 2008 Setup SQL Server 2008 Express is the freeware version of SQL Server It has a number of limitations and while it is better than using an Access database for IDAttend it is not a real substitute for the full version of SQL Server To install SQL Server Express you must be logged onto the server where SQL Server is to be installed with full administrator rights In QLD schools this will be an Orange Card login on the Member Server normally If installing on a DC in a QLD school the MOE Sys Tech will need to be logged in Please follow these instructions exactly You may not get a second chance You must first run SQLEXPR EXE from the SQL SERVER 2008 EXPRESS folder on IDAttend CD or the IDAttend folder on the server Once the install program is launched it will extract files needed for installation Note The installer may disappear for up to a minute at serveral stages during the install x METTET Extracting File x64 microsoft sqlserver configuration smo dll To Directory d 49fcb60b5e3604d8ae5a Please wait while SQL Server 2008 Setup processes the current operation
6. 20141117 090301 Product Key Summary EOha OOS 20141117 090501 bet License Terms Information about the Setup operation or possible next steps Feature Selection Your SOL Server 2006 installation completed successfully Disk Space Requirements Error and Usage Reporting Installation Rules Ready to Install Installation Progress Complete Supplemental Information The Following notes apply to this release of SOL Server only Microsoft Update For information about how bo use Microsoft Update to identify updates for SQL Server 2008 see the Micrasoft Update Web site lt http jigo microsoft com Frvdink LinkId 108409 gt at http jigo microsoft com Fulink LinkId 106409 Reporting Services The Reporting Services installation options that you specified in Setup determine whether additional configuration is required before you can access the report server IF you installed the default configuration the report server Close Help 4A Configuring Management studio Start SQL Management from Start menu All Programs Microsoft SQL Server 2008 SQL Server Management Studio Microsoft SOL Server Management Studio i Microsoft SQL Server Management Studio is configuring the environment For First time use This might take a few minutes OOOO Normally the IDAttend Instance will be displayed for the Server Name Click Connect Microsoft SQL Server Management Studio File Edit View Tools Wind
7. END service on EQNO 1037 Click Yes on the confirmation screen This option is only restarting the SQL Server service not the server itself Close the SQL Server management Studio window SQL Server should now be setup for use with IDAttend Attaching existing IDAttend database s to the newly installed SQL Server backend If moving from one server to another then first Stop the SQL Server service on the old server Copy the two files IDAttendxxxx mdf and IDAttendxxxx_log ldf from the C Program Files Microsoft SQL Server MSSQL 1 MSSQL Data should be that folder if not do a search for them In IDAttend under Tools Data Locations the existing location on the server of the current database is shown in blue Paste the files into the same folder on the new server In SQL Server Management Studio Express right click on the Databases tree and select Attach The IDAttendxxxx database should show up Select it and Save Repeat for any other year s databases that are not attached lf the server name has changed you will need to change it in IDAttend ini in the IDAttend System folder ServerDB Server MYSERVER IDAT TEND Note If there are databases from previous years then also move those and attach them as above Setting up IDAttend to use SQL Server if not already done Run IDAttend assuming the IDAttend runtime has been installed Log in with the user name password of admin mxx6re Create a new database if required
8. SQL Server 2008 Express Install Instruction for IDAttend Important Note If updating your IDAttend Server that has SQL Server on it and you are using and Express version then it is more than likely that the database files are on the C Drive of the server Please copy all of the IDAttendxxxx MDF and IDAttendxxxx LDF files to a safe location before formatting or decommissioning the server You may need to stop the SQL Server Service to do this In IDAttend under Tools Data Locations the existing location on the server of the current database is shown in blue DAttend Installation The IDAttend CD needs to be copied to an IDAttend folder on a server that all users can access QLD MOE schools this is normally installed on a Member Server on the network The folder must be shared share may happen automatically if folder is under some shared apps folder Permissions must be set to allow all school staff Change rights to the folder QLD schools may need to use the QED Zero Touch application to create setup permissions etc Copy all folders on the IDAttend CD to this folder Download the latest IDAttend update from http www idattend com au support idattend download Extract the update zip file to the IDAttend System folder on the server Overwrite any existing files Install SQL Server as per the instructions below Workstation Setup From a workstation login run the IDAttendRuntime exe file server IDAttend Workstation
9. SQL Server service needs to be restarted Ignore this at this stage Close the Configuration Manager screen is SOL Server Configuration Manager File Action View Help 9 A G aB H SQL Server Configuration Manager Local Protocol Name Status E ne sali ah ed oe i Y Shared Memory Enabled P 3 SQL Server etwork Lontiguration Y7 Named Pipes Disabled He Protocols for MSSMLBIZ Be Protocols for IDATTEND Be Protocols for IDATTENDEXP a a SOL Native Client Configuration a Client Protocols Aliases y TCP IP Enabled VIA Disabled IDAttend SQL Server 2008 Management Studio Setup To install SQL Server 2008 Management Studio Express you must be logged onto the server where SQL Server is to be installed with full administrator rights In QLD schools this will be an Orange Card login on the Member Server normally If installing on a DC in a QLD school the MOE Sys Tech will need to be logged in Please follow these instructions exactly You may not get a second chance Run either SQLManagementStudio_x64_ENU or SQLManagementStudio_x86_ENU relevant for your server type from the SQL SERVER 2008 EXPRESS folder on IDAttend CD or the IDAttend folder on the server Once the install program is launched it will extract files needed for installation Note The installer may disappear for up to a minute at serveral stages during the install On the installation center screen choose Installation from left hand menu Then choose new SQL server s
10. allation Rules screen click next You are now ready to install Management studio Click Install _ of x Ready to Install verify the SOL Server 2006 Features to be installed Setup Support Rules Installation Type Product Key Ready to install SQL Server 2008 El Summary 2 Edition Express with Advanced Services 2 Action Install General Configuration Features Management Tools Basic Instance configuration i Instance Directory C Program Files Microsoft SOL Server Shared component root directory Shared Feature directory dE DATA Applications IDAttend Error and Usage Reporting z Usage Reporting False i Error Reporting False License Terms Feature Selection Disk Space Requirements Error and Usage Reporting Installation Rules Ready to Install Installation Progress Complete Configuration File path C Program Files Microsoft SOL Serveri 100 5etup Bootstrap Logi20141117_090301 ConfigurationFile ini lt Back Install Cancel Help ae After Installtion the Installtion progress screen should state Setup process complete click next Click close to complete the installation of management studio 6 SOL Server 7008 Setup Eo ioj x Complete Your SOL Server 2006 installation completed successfully Setup Support Rules Summary log file has been saved to the Following location Installation Type C Program Files Microsoft SOL Server LO0 Setup BootstrapiLogi
11. ed instance and call it IDAttend You can leave the default paths but the database will be installed on your C drive which may not be ideal for backup purposes and if you have space limitations If you change the path to the database folder within the idattend folder folder you should make sure that the idattend folder is going to be backed up Click Next SQL Server 2008 Setup IDAttend Dated S Di DATA Applications IDAttend Database lt Back net gt canei era Review the disk space requirements and click next SQL Server 2008 Setup B J Drive C 118 MB required 18411 MB available System Drive C 118 MB required AQ Drive D 177 MB required 95426 MB available i Shared Install Directory D 00 DATA Applications IDAttend 0 MB required Instance Directory D B DaTA Applications IDAttend Database 177 MB required Set the the account name to Local System Not Network Service And change the SQLserver Browser startup type to automatic click next E SQL Server 2008 Setup 15 x Server Configuration Specify the configuration Setup Support Rules Feature Selection Instance Configuration Disk Space Requirements Server Configuration Database Engine Configuration Error and Usage Reporting Installation Rules Ready to Install Installation Progress Complete Service Accounts Collation Microsoft recommends that you use a separate account for each SQL Server service
12. etup Support Rules Setup Support Rules identify problems that might occur when you install SQL Server Setup support files Failures must be corrected before Setup can continue Setup Support Rules Operation completed Passed 10 Failed 0 Warning O Skipped 1 Feature Selection Disk Space Requirements Error and Usage Reporting Show details gt gt Re run Installation Rules View detailed report Ready to Install Installation Progress Complete lt Back _net gt Cancel Help __ Select the database engine services feature and click next i jDxX Feature Selection Select the Express Features to install For clustered installations only Database Engine Services and Analysis Services can be clustered Setup Support Rules Features Description Instance Features Database Engine Services C SOL Server Replication Shared Features O SQL Client Connectivity SDK Redistributable Features Feature Selection Server features are instance aware and have their own registry hives They support multiple instances on a computer Instance Configuration Disk Space Requirements Server Configuration Database Engine Configuration Error and Usage Reporting Installation Rules Ready to Install Installation Progress Complete Select All Unselect All Shared feature directory c Program Files Microsoft SQL Server T lt Back Next gt Cancel Help Choose nam
13. ew Select a page l 15 Script 5 Help i T New Query gt General Memory Enab gt Processors le processors Connect 39 4 Security E LO EQNOQE Connections i Databa 4 Database Settings C Security 4 Advanced Server 4 Permissions Ea Replicat Manage 151 51 3151 51 51 lt 1 15595551 1 st IV Automatically set processor affinity mask for all processors IV Automatically set 1 0 affinity mask for all processors Threads Maximum worker threads Connection i fo m Server EQNOQEED0SIDATTEND Connection NOQ oc ilepi1 I Use Windows fibers lightweight pooling 32 View connection properties Configured values Bunning values Ready 44 Right click on the SQL Server Instance in the Object Explorer at the left of screen Select Register F Microsoft SQL Server Management Studio File Edit View Tools Window Community Help T new Query D Lis Gar A GS Bh i Object Explorer lx EONOC 0 0 161 E Om Connect g Disconnect New Query Activity Monitor Start Stop Pause Resume Restart Policies Facets Start PowerShell Reports Refresh Properties Ready There is no need to make any changes to the defaults Click Save button Right click on the SQL Server Instance in the Object Explorer at the left of screen Select Restart NOTE It may take a minute to show the restart dialog Ore you sure you want to restart the MSSQL IDATT
14. or log into the previously created IDAttend SQL database If there are no errors and DAttend loads normally the SQL Server setup is correct If creating To create a new database in IDAttend go to Tools Create New Database option fe Create New Database 2s f SOL Server f Access SQL Server Name EQSOCexxO03IDATTEND New Database Name idattend2009 Database User Hame Database Password Transfer From Current Database School Details Pernod Times Year Level Assignment Details User Details Teacher Details Attendance Codes Student Details E p User Settings Previous Visitors Create Database Cancel Enter the lt server name gt lt SQL server instance name gt in the SQL Server Name field Enter the Database Name to be used for the new database no spaces are allowed in this name Refer above screen shot Unless SQL Server Authentication is required to log into the IDAttend database the Database User Name and Database Password fields should be left blank Click the Create Database button Next change the Tools Database Locations to the SQL Server Database just created and Click OK Log into the new database using the Admin password and setup IDAttend as described in the System Setup section of the IDAttend User Manual Import the students and timetable as described in these sections If anyone has any issue or questions with the installation please call me Kevin Beckwith IDAttend Pty
15. ow Community Help T1 New Query Ly D a S Re Connect 39 M m Y gs aF Connect to Server SOL Server 2008 Server type DatabaseEngine O Server name F ND ba Authentication Windows Authentication User name Noose a Password E E D Remember password 101 x When the screen loads expand the next to Security Select Logins Under the Logins option right click and select New Login Click the Search button Click the Objects Type button Ensure Groups is ticked Object Types a Y es Select the types of objects you want to find Object types T E Buittin security principals E KE Groups W amp Users Click OK Click the Locations button Ensure Entire Network is selected Click OK Enter xxxxgg_usrstaff and click OK xxxx is the school number Check Names may also be clicked select User or Group Select this object type User Group or Builtin security principal From this location KEVIN PC Enter the object name to select examples The xxxxgg_usrstaff group should now have an IDAttend login in SQL Server The following needs to be done for all logins including gg_usrstaff Except for NT AUTHORITY SYSTEM and SA Select the login Right click and select properties When the screen displays select the Server Rolls option and ensure the following are ticked dbcreator and sysadmin If public is ticked Leave ticked _ T H Login Properties BUILTIN Adminis
16. pace Requirements Information about the Setup operation or possible next steps Server Configuration Your SQL Server 2008 installation completed successfully Database Engine Configuration Error and Usage Reporting Installation Rules Ready to Install Installation Progress Complete Supplemental Information The Following notes apply to this release of SQL Server only Microsoft Update For information about how to use Microsoft Update to identify updates for SQL Server 2008 see the Microsoft Update Web site lt http go microsoft com Fwlink LinkId 108409 gt at http go microsoft com Fwlink LinkId 108409 Reporting Services The Reporting Services installation options that you specified in Setup determine whether additional configuration is required before you can access the report server IF you installed the default confiquration the report server nd Close Help WZ ta Configure SQL server Go to Start Menu All programs Microsoft sql server 2008 configuration tools SQL Server Configuration Manager This screen will display all instances of SQL Server You need to select the IDAttend Instance as setup previously if there is more than one displayed By default SQL Server Express does not install any remote connection protocols You must click on the TCP IP option and enable it also enable the Named Pipes option Named Pipes is not required in QLD MOE schools You may get a warning that the
17. tand alone Installation and wait for files to be extracted tm SQL Server Installation Center E loj x Planning Sai New SOL Server stand alone installation or add features to an existing installation Installation Launch a wizard to install SQL Server 2008 in a non clustered environment or to add Features to an existing SQL Server 2008 instance Maintenance Sai New SOL Server failover cluster installation Tools Launch a wizard to install a single node SQL Server 2008 failover cluster Resources SP Add node to a SOL Server Failover cluster Advanced PAS 7 y if Launch a wizard to add a node to an existing SQL Server 2008 Failover cluster Options Upgrade from SQL Server 2000 or SQL Server 2005 Launch a wizard to upgrade SQL Server 2000 or SQL Server 2005 to SOL Server 2008 Before you upgrade you should run the Upgrade Advisor to detect potential problems B Search for product updates Search Microsoft Update for SQL Server 2008 product updates SOL Server 2008 TT iil Please wait while SQL Server 2008 Setup processes the current operation Mikrosoft 5 L Server 2008 On the Setup Support rules screen click ok Then on the Setup Support files screen click install F soL Server 2008 Setup R Setup Support Files Click Install to install Setup Support files To install or update SQL Server 2008 these files are required Setup Support Files The following components are required for SQL Server Setup
18. tors have unrestricted access to the Database Engine lt Back Next gt Cancel Help On the Error and Usage report screen click next On the installation Rules Screen click Next You are now ready to do the actual install of SQL server Click Install SQL Server 2008 Setup ae iol x E Summary z Edition Express Action Install El General Configuration Features i Database Engine Services Instance configuration Instance Name IDATTEND Instance ID IDAttend I Instance IDs SQL Database Engine MSSQL10 IDATTEND Instance Directory D DaTA Applications IDAttend Database Shared component root directory L Shared feature directory D NN DATA Applications IDAttend oe Error and Usage Reporting Usage Reporting False oo Error Reporting False Instance configuration E Database Engine I Service Configuration Account NT AUTHORITYINETWORK SERVICE i Startup Type Automatic h Once installation process is completeit should read success click next SQL Server 2008 Setup l i B x On the complete screen click close Complete Your SQL Server 2008 installation completed successfully Setup Support Rules Summary log file has been saved to the Following location Feature Selection C Program Files Microsoft SOL Server 100 Setup Bootstrap Log 20141117 085447 Instance Configuration Summary EQNOGWIMHIOS 20141117 085447 txt Disk S
19. trators uaiiie Ande Select a page LAT General LA Server Roles eT User Mapping Server role is used to grant server wide security privileges to a user L Securables GAT Status SS Script Help Server roles E bulkadmin E diskadmin E setupadmin sysadmin Connection Server KEVIN PCOIDATTENDEXP Connection KEVIN PC Kevin S32 View connection properties Click OK Next select the User Mapping option The database Master must be ticked The following options in the database role membership section must be ticked db_datareader db _datawriter db owner Click OK button Repeat all steps above for BUILTIN Users and for any other logins listed except NT AUTHORITY SYSTEM and SA Right click on the SQL Server Instance in the Object Explorer at the left of screen Select Properties BS Microsoft SQL Server Management Studio mie x File Edit View Tools Window Community Help T New Query D D 7 lel G amp S Sh Object Explorer zA Connect BY ay u Y aS f5 itelpiele eae A g 16l Connect Disconnect E Server 59 Replicat OE Manage New Query Register Activity Monitor Start Stop Pause Resume Restart Policies Facets Start PowerShell Reports Refresh Click on Processors in Select A page section Tick Boost SQL Server Priority flag Click OK fF Microsoft SQL jam fm Server Properties EQNOQ2027003 IDATTEND De Edt wi
Download Pdf Manuals
Related Search