slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft SQL Server 2005 Express Edition & SQL Server Management Studio Express PowerPoint Presentation
Download Presentation
Microsoft SQL Server 2005 Express Edition & SQL Server Management Studio Express

play fullscreen
1 / 95

Microsoft SQL Server 2005 Express Edition & SQL Server Management Studio Express

234 Views Download Presentation
Download Presentation

Microsoft SQL Server 2005 Express Edition & SQL Server Management Studio Express

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Microsoft SQL Server 2005 Express Edition & SQL Server Management Studio Express Installation and Configuration Guides

  2. System Requirements

  3. Installation Guide We have two separate Installers setup files for:  Microsoft SQL Server 2005 Express Edition  SQL Server Management Studio Express Microsoft SQL Server 2005 Express Edition (SQL Server Express) is a powerful and reliable data management product that delivers rich features, data protection, and performance for embedded application clients, light Web applications, and local data stores. Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. SSMSE can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2005.

  4. Installation Guide for Microsoft SQL Server 2005 Express Edition

  5. Installation GuideMicrosoft SQL Server 2005 Express Edition When you click on the “SQLEXPR” icon to start the Installation of “Microsoft SQL Server 2005 Express Edition”, You would see the following extractor dialogue first

  6. Installation GuideMicrosoft SQL Server 2005 Express Edition Once the self-extractor would finish extracting the files, the Setup would be started. In the first step, End User License Agreement dialogue would appear … You MUST tick the checkbox for “I accept the licensing terms and conditions” Then click on Next button to proceed further …

  7. Installation GuideMicrosoft SQL Server 2005 Express Edition Next would appear the dialogue box for “Installing Prerequisites”.. Indicating a couple of supporting components for “SQL Server EE”.. The setup would install these component by itself … Click on “Install” button to continue

  8. Installation GuideMicrosoft SQL Server 2005 Express Edition Once the setup would install the required supporting components, it would give a success message …. When these components are installed, click on Next button to proceed …

  9. Installation GuideMicrosoft SQL Server 2005 Express Edition In the next step, The setup would scan the computer configuration to determine if your machine is fulfilling the minimal installation requirements

  10. Installation GuideMicrosoft SQL Server 2005 Express Edition Once the computer configuration is done,, Installation Wizard would appear click on “Next” button to further proceed the setup …

  11. Installation GuideMicrosoft SQL Server 2005 Express Edition In the next step, The setup would do some System Configuration Check This would be an automatic step and it would do all the checking by itself If there would be no issue or problem,, it would give the success message Once Successful, click on Next button to further proceed …

  12. Installation GuideMicrosoft SQL Server 2005 Express Edition The setup would do some Installation preparation before actual Installation would begin …

  13. Installation GuideMicrosoft SQL Server 2005 Express Edition Registration Information dialogue box would appear.. Name is the mandatory field, which MUST be filled with some valid value whereas, the Company field is optional click on “Next” button

  14. Installation GuideMicrosoft SQL Server 2005 Express Edition Next would be the Feature Selection Dialogue box There would be two types of Features • Database Services • Client Components You can click on “+” sign to expand a certain category.. If any of the subcomponent for a feature would be unavailable, it would appear to be a gray icon If all of the subcomponents for a feature would be unavailable, it would appear to be a white icon with a Red color cross ….

  15. Installation GuideMicrosoft SQL Server 2005 Express Edition Click on “+” sign to expand the each Feature category.. Subcomponents for each category would appear …

  16. Installation GuideMicrosoft SQL Server 2005 Express Edition Click on the small arrow, appearing on the sub-component icon it would display an option menu for that sub-component … To include that subcomponent, click on the first option “will be installed on local hard drive” Choose this option for each Subcomponent, separately clicking on The little arrow against each of it ..

  17. Installation GuideMicrosoft SQL Server 2005 Express Edition Once all features are made available locally, it would appear to be like this .. You can click on “Browse” button if you need to change the Installation path But it is recommended that you continue with default … Click on “Next” button to continue the setup …

  18. Installation GuideMicrosoft SQL Server 2005 Express Edition Just one step back, you might have noticed that there was an option “Hide advanced configuration options” If you would check that, some of the advance options would not appear during the setup,, but it is recommended to uncheck this and continue the setup …

  19. Installation GuideMicrosoft SQL Server 2005 Express Edition The “Instance Name” dialogue box would appear Here you can specify if you want to create a named instance with any name But it is recommended to keep it Default .. Note: This dialogue box would only appear If you had uncheck the “Hide advance configuration option“ at Registration Information dialogue box

  20. Installation GuideMicrosoft SQL Server 2005 Express Edition Next, Service Account dialogue box would appear As you can See, there are various types of Services Accounts In the next few slides, I have tried to describe about each of the service type Note: This dialogue box would only appear If you had uncheck the “Hide advance configuration option“ at Registration Information dialogue box

  21. Installation GuideMicrosoft SQL Server 2005 Express Edition Customize the logon for each service account Select the Customize for each service account check box to customize settings for individual services. This option assigns specific logon accounts to individual services. Click this check box to implement the principle of least privileges, where SQL Server services are granted the minimum permissions they need to complete their tasks. If this check box is not selected, the same account and settings are used for all SQL Server services. Select any of the following services to customize its settings. Service Accounts

  22. Installation GuideMicrosoft SQL Server 2005 Express Edition Use the built-in System account You can assign Local System, Network Service, or Local Service to the logon for the configurable SQL Server services. The Local System option specifies a local system account that does not require a password to connect to SQL Server on the same computer. However, the local system account may restrict the SQL Server installation from interacting with other servers, depending on the privileges granted to the account. The Network Service account is a special, built-in account that is similar to an authenticated user account. The Network Service account has the same level of access to resources and objects as members of the Users group. Services that run as the Network Service account access network resources using the credentials of the computer account. The Local Service account is a special, built-in account that is similar to an authenticated user account. The Local Service account has the same level of access to resources and objects as members of the Users group. This limited access helps safeguard your system if individual services or processes are compromised. Services that run as the Local Service account access network resources as a null session with no credentials. Service Accounts

  23. Installation GuideMicrosoft SQL Server 2005 Express Edition Service Accounts Use a domain user account Specifies a domain user account that uses Windows Authentication to set up and connect to SQL Server. Microsoft recommends using a domain user account with minimal rights for the SQL Server service, as the SQL Server service does not require administrator account privileges. The SQL Server Agent account must have administrator privileges if you create CmdExec and ActiveScript jobs that belong to someone other than a SQL Server administrator, or if you use the AutoRestart feature. If the above features are requirements in your environment, consider using separate service accounts for the SQL Server and SQL Server Agent services.

  24. Installation GuideMicrosoft SQL Server 2005 Express Edition Service Accounts For best practice, it is recommended to choose “Use the Built-in System Account” and “Local Service” Also check the “SQL Server” and “SQL Browser” services to be started at the end of setup Click on Next button to continue the setup

  25. Installation GuideMicrosoft SQL Server 2005 Express Edition In the next step, “Authentication Mode” dialogue box would appear If you choose “Windows Authentication Mode”, SQL Server Authentication would be only dependent on your Windows Authentication, which means if anyone can login to your window account, He/She can use your SQL Server … Thus, it is recommended to choose the “Mixed Mode”, which would also include the SQL Server’s own authentication mode … The default application administrator for SQL Server is “sa”, and when you choose the “Mixed Mode” you are required to give a new password for the default administrator account. click on Next button to continue

  26. Installation GuideMicrosoft SQL Server 2005 Express Edition Collation Settings dialogue box would only appear if you had unchecked the “hide advance configuration option” at Registration Information dialogue box Keep this all as default and click Next button to continue the setup …

  27. Installation GuideMicrosoft SQL Server 2005 Express Edition User Instance dialogue box would only appear if you had unchecked the “hide advance configuration option” at Registration Information dialogue box If you want to allow the other users to use the SQL Server, without the administrative privileges, or to let them connect as a SQL client from a remote machine, you can check the “Enable User Instance” checkbox option … click “Next” to continue the setup

  28. Installation GuideMicrosoft SQL Server 2005 Express Edition Next would be the “Error and Usage Report Settings” … This is an optional part where you can check if you want to sent the report to Microsoft, if anything goes wrong with the product during the usage … click on Next button to continue..

  29. Installation GuideMicrosoft SQL Server 2005 Express Edition Once the setup has collected the necessary information it is now ready to begin the installation click on “Install” button

  30. Installation GuideMicrosoft SQL Server 2005 Express Edition Next the Setup Process would be doing some component configuration …

  31. Installation GuideMicrosoft SQL Server 2005 Express Edition Once all the components would be configured successfully, it would show green checks against each component in the list click on Next button to continue the setup

  32. Installation GuideMicrosoft SQL Server 2005 Express Edition Now the setup has almost done the installation process, thus it would now be the last dialogue box for the SQL Server setup click on Finish button to complete the Installation Process

  33. Configuration Guide for Microsoft SQL Server 2005 Express Edition

  34. Configuration GuideMicrosoft SQL Server 2005 Express Edition Once you have completed the Installation for Microsoft SQL Server 2005 Express Edition, It’s configuration tools would be available in Program menu of your computer you can browse through Start  Programs  Microsoft SQL Server 2005  Configuration Tools

  35. Configuration GuideMicrosoft SQL Server 2005 Express Edition To open the SQL Server Configuration Manager tool Start  Programs  Microsoft SQL Server 2005  Configuration Tools  SQL Server Configuration Manager

  36. Configuration GuideMicrosoft SQL Server 2005 Express Edition In SQL Server Configuration Manager, you would find three types of Configuration tools • SQL Server 2005 Services • SQL Server 2005 Network Configuration • SQL Native Client Configuration

  37. Configuration GuideMicrosoft SQL Server 2005 Express Edition click on “SQL Server 2005 Services” from the left-side navigation menu It would show the list of SQL Server 2005 services on right side panel, in detailed view, which is usually comprised of Name, State, Start Mode, Log On As, Process ID and Service Type … When you select a particular service, it’s specific action icons such as; start, pause, stop, refresh/restart are shown on the menu bar ..

  38. Configuration GuideMicrosoft SQL Server 2005 Express Edition Services action options can also be available by Right clicking on that particular service .. for further advance settings, you can choose Properties option

  39. Configuration GuideMicrosoft SQL Server 2005 Express Edition If you choose properties option for a particular service, it’s properties dialogue box would appear like this: This property dialogue box is for the alteration of the “Service Account” settings which were adjust during the installation process, means if you need to change those settings later, you can do it here …

  40. Configuration GuideMicrosoft SQL Server 2005 Express Edition click on “Service” tab of Properties dialogue box for some service settings Here you can change the Start Mode of the selected service to be “Automatic”, “Manual” or “Disabled”

  41. Configuration GuideMicrosoft SQL Server 2005 Express Edition click on “Advanced” tab of Properties dialogue box for some advance settings … Here, you can indicate weather the service is listening and also you can enable or disable “Customer Feedback Reporting” and “Error Reporting” options Once you have made necessary adjustment on all three tabs, click on Apply button and then click on OK button to apply the changes

  42. Configuration GuideMicrosoft SQL Server 2005 Express Edition Now expand the “SQL Server 2005 Network Configuration” option from left hand menu and select “Protocols for SQLEXPRESS” option On right panel, a list of SQL Express Protocols, along with their current status would be shown ….

  43. Configuration GuideMicrosoft SQL Server 2005 Express Edition Right click on a particular protocol to enable or disable that particular protocol service …

  44. Configuration GuideMicrosoft SQL Server 2005 Express Edition You can also choose Properties option to adjust some other options for that particular protocol

  45. Configuration GuideMicrosoft SQL Server 2005 Express Edition Now expand the “SQL Native Client Configuration” option from the left side navigation menu, and select “Client Protocol” option Right click on a particular protocol to enable or disable it .. You can also select Properties option for some advance settings …

  46. Configuration GuideMicrosoft SQL Server 2005 Express Edition Note: You shall enable “TCP/IP” and “Name Pipes” protocols for both “Network Configurations” and “Client Configurations” specially when you need to use the SQL Server services with external application such as a Project in Java or .NET environment

  47. Configuration GuideMicrosoft SQL Server 2005 Express Edition To open the SQL Server Surface Area Configuration Start  Programs  Microsoft SQL Server 2005  Configuration Tools  SQL Server Surface Area Configuration

  48. Configuration GuideMicrosoft SQL Server 2005 Express Edition SQL Server Surface Area Configuration Dialogue box would appear … Click on “Surface Area Configuration for Services and Connections” option

  49. Configuration GuideMicrosoft SQL Server 2005 Express Edition Here you can adjust various options and Settings for Database Engine services and SQL Server Browser services … Specifically, if you need to use your SQL Server services from a Remote location or you need to do connectivity with external application projects, it is recommended that you shall adjust “Remote Connections” option, under Database Engine category. Select “Local and Remote Connections” and “Using both TCP/IP and Name Pipes” click on Apply button and then OK button to apply changes

  50. Installation Guide for SQL Server Management Studio Express