SQL Server 2005 Express Setup/IDAttend Instructions
Contents
1. 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 Ltd M 0409009943 E kevin idattend com au2. Express does not install any remote connection protocols You must click on the TCP IP option and enable it lf your network has both a curriculum and admin network and you have not opened a TCP IP port on the router between the two networks you need to also enable the Named Pipes option Named Pipes is not required in QLD MOE schools You may get a warning that the SQL Server service needs to be restarted Ignore this at this stage Close the Configuration Manager screen Next Go to Windows Start Programs SQL Server 2005 Configuration Tools and select SQL server 2005 Surface Area Configuration Click on the Surface Area Configuration for Services and Connections option 4 Surface Area Configuration for Services and Connections localhost t m SOL Server 2005 Surface Area Configuration Help Protect Your SQL Server Enable only the services and connection types used by your applications Disabling unused services and connections helps protect your server by reducing the surface area For default settings see Help Select a component and then configure its services and connections S g IDATTEND By default SQL Server 2005 Express Evaluation and Developer editions allow local T Database Engine client connections only Enterprise Standard and Workgroup editions also listen for E Seniice remote client connections over TCP IP Use the options below to change the protocols mag on which SQL Server listens for incom
3. 0 Running values Right click on the SQL Server Instance in the Object Explorer at the left of screen Select Register 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 Click OK 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 Log into Windows with a normal Windows login on a workstation Attaching existing IDAttend database s to the newly installed SQL Server backend lf 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 database not attached If the server name has changed you will need to change it in IDAttend ini in the IDAttend System folder ServerDB server MYSERVER ID
4. 5 Server name KEVIN POIDATTENDEXP Atrerticaton User name KEVIN PC Kevin Ih Normally the IDAttend Instance will be displayed for the Server Name Click Connect When the screen loads expand the next to Security Select Logins The following need to be done for all logins except NT AUTHORITY SYSTEM and SA Select the login Right click and select properties When the screen displays select the Server Rolls option Ensure the following are ticked dbcreator sysadmin If public is an option this will normally be ticked by default Leave ticked J Login Properties BUILTIN Administratore ww S ee ae bo Bets A Server Roles Server role is used to grant server wide security privileges to a user Server roles bulkadmin diskadmin Connection Server KEVIN PC IDATTENDEXP Connection KEVIN PC Kevin 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 Any other logins listed except NT AUTHORITY SYSTEM and SA Queensland MOE schools need to add a new login after the above has been done Under the Logins option right click and select New Login Click the Search button Click the Object
5. ATTEND 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 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 ILA f SOL Server f Access SQL Server Name EQSOCexxxO003DATTEND 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
6. B on your hard drive Installation path Click the Next button The next screen will display the Instance Name screen This screen will only be displayed if you un ticked the Hide advanced configuration options mentioned earlier You should click the Named Instance and enter IDATTEND eo Microsoft SOL Ser Instance Name You can install a default instance or you can specify a named instance Provide a name for the instance For a default installation cick Default instance and cick Next To upgrade an existing default instance dick Default instance To upgrade an existing named instance select Named instance and specify the instance name Default instance Named instance IIDATTEND To view a list of existing instances and components cick on Installed instances lt Back Click Next button The next screen may show a list of existing components that are already installed You would normally click the Next button The following screen will display the Service Account screen The defaults are normally OK Make sure the Start services at the end of setup section has both SQL Server amp SQL Brower ticked 38 Microsoft SQL Server 2005 Setup 2s F Service Account Service accounts define which accounts to log in SOL Server Use the builtin System account Use a domain user account Username Password Domain Start services at the end of setup SOL Server SOL Browser zia
7. SQL Server 2005 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 IDAttend SQL Server 2005 Express Setup If using SQL Server 2005 Express it 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 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 Regional 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 2005 EXPRESS folder on IDAttend CD or the IDAttend folder on the CD Once the install program is launched you need to accept the Licence Agreement click the Install button on the Installing Prerequisite
8. ing client connections TCP IP is prefered over a Remote Connections named pipes because it requires fewer ports to be opened across the firewall Analysis Services mA EY SQL Server Agent 0 Full Text Search Local connections only H IDATTENDEXP a Database Engine Service Using TCP IP onby Remote Connections g MSSMLBIZ g SGL Server Browser Local and remote connections Using named pipes only Using both TCP IP and named pipes View by Instance View by Component OK Cancel Apply Hep Select the SQL Server Instance you have installed Click the Remote Connections section The following should be enabled Local and remote connections Using TCP IP only lf using separate networks then you may need to enable the name pipes only option if the TCP IP option does not enable IDAttend to make connection to the server Click the Apply button and then OK button SQL Server Management Studio must be installed Run SQLServer2005 SSMSEE msi from the SQL SERVER 2005 EXPRESS folder on IDAttend CD or the IDAttend folder on the CD There are no install options for this install Once installed you need to do the following Go to Windows Start Programs SQL Server 2005 and select SQL Server 2005 Management Studio A login screen will be displayed this may take a minute or two all Connect to Server 2s Miomo Microsoft N Windows Server System SQL Server 200
9. k Click the Next button The Authentication Mode window will be displayed next The default of Windows Authentication should be left as is pa Microsoft SQL Server 2005 Setup uthentication Mode hy The authentication mode specifies the security used when connecting to SOL Server Select the authentication mode to use for this installation Windows Authentication Mode 9 Mixed Mode Windows Authentication and SQL Server Authentication Specify the sa logon password below Enter password Confirm password aa Click the Next button The Collation Settings screen is displayed next The defaults are fine Click the Next button The Configuration Options screen is displayed next je Microsoft SQL Server 2005 Setup L 2s Configuration Options Configure user and administrator accounts a L Z Enable User Instances This option enables users without administrator permissions to run a separate instance of the SOL Server Express Database Engine V Add user to the SQL Server Administrator role This option adds the user who is running the SQL Server Express installation program to the SQL Server System Administrator role By default users on Microsoft Windows Vista operating system are not members of the SOL Server System Administrator role ee SS The Enable User Instances option should be ticked Depending on the version of SQL Server Express being in
10. oft SQL Server 2005 Setup J Feature Selection Select the program features you want installed Click an icon in the following list to change how a feature is installed Feature description Installs the SQL Server Database Engine tools for managing relational E Database Services El xX Client Components x 7 Software Development Kit Management Studio Express M 7 Connectivity Components and XML data and replication x This feature requires 88 MB on your hard drive It has 2 of 4 subfeatures selected The subfeatures require 99 MB on your hard drive Installation path C Program Mesos SOL Sener Next the Feature Selection screen will be displayed lt is important that you select Will Be Installed On Local Hard Drive for Connectivity Components and Management Studio Express if you install has this option There is no need to install the Software Development Kit 3 Microsoft SQL Server 2005 Setup ga ae J Feature Selection Select the program features you want installed Click an icon in the following list to change how a feature is installed Feature description Installs components for communication Client Components between cients and servers induding Connectivity Components network libraries for ODBC and OLE oo W r Software Development Kit DB hani F Management Studio Express Database Services This feature requires 19 M
11. s Type button Ensure Groups is ticked Object Types Le p es Select the types of objects you want to find Object types 82 Buittin security principals ae Groups z 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 securnty principal Types From this location KEVIN PIC Enter the object name to select examples oomgg usrstatt The xxxxgg_usrstaff group should now have an IDAttend login in SQL Server Modify the Server Rolls and User Mapping as per the previous steps Click OK Right click on the SQL Server Instance in the Object Explorer at the left of screen Select Properties Click on Processors in Select A page section Tick Boost SQL Server Priority flag Click OK Server Properties KEVIN PC IDATTEND Select a page ony e TF AA Memory AA Processors 24 Securty A Connections rocessar Frocessor Affinity Enable processors A Database Settings 7 T A Pemissions Automatically set processor affinity mask for all processors Automatically set 1 0 affinity mask for all processors Threads n Maxdmum worker threads Connechon HEER 1 KEVIN PCOIDATTEND Fi Boost SQL Server priority Connection Kevin PC Kevin Ep View connection properties Progress ady Configured values
12. s screen i Microsoft SQL Server 2005 Setup gt Welcome tothe MicrosoftSQL Server Installation Wizard Setup will help you install modify or remove Microsoft SQL Server To continue click Next Next you will see the Installation Wizard screen Click the Next button Next SQL Server will check if it can be installed on the server Check any warning messages to see if they are a valid concern Any Errors will generally mean SQL Server will not install 8 Microsoft SQL Server 2005 Setup Lx System Configuration Check Wait while the system is checked for potential installation problems T 0 Error Success 1 Waming Details Pending Reboot Requirement Performance Monitor Counter Require Default Installation Path Permission Re Intemet Explorer Requirement COM Plus Catalog Requirement ASP Net Version Registration Require Minimum MDAC Version Requirement Edition Change Check Filter v Help Common errors are incorrect OS or service pack level Seeeeeese J Microsoft SQL Server 2005 Setup am Registration Information The following information will personalize your installation The Name field must be filled in prior to proceeding The Company field is optional Hide advanced configuration options The next screen will contain the Registration Information It is important that the Hide advanced configuration options in UN TICKED at this time Click Next button fq Micros
13. stalled and the OS used to install SQL Server you may get the Add user to the SQL Server Administration role If shown you should enable this option Click the Next button The Error and Usage Report Settings screen is displayed next None of the options offered need be sected Click the Next button The Ready To Install screen will be displayed Click the Install button SQL Server 2005 Express will now be installed Once the setup is complete Setup Progress screen will make the Next button available Click Next The Completing SQL Server 2005 Setup screen will now be displayed Click the Finish button SQL Server is now installed on the server The server setup of SQL Server must be done next Go to Windows Start Programs SQL Server 2005 Configuration Tools and select 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 gt gt lt o E7 SOL Server Configuration Manager File Action View Help TERREA H SQL Server Configuration Manager Local Protocol Name Status a SOL Server 2005 Services Zz SQL Server 2005 Network Configuration Be Protocols for MSSMLBIZ Be Protocols for IDATTEND Be Protocols for IDATTENDEXP a SQL Native Client Configuration a Client Protocols g Aliases y Shared Memory Enabled f Named Pipes Disabled S TCP IP Enabled VIA Disabled By default SQL Server
Download Pdf Manuals
Related Search