Have your free copy of GP10

Saturday, May 24, 2008

Installing Microsoft SQL Server 2005 Express Edition

Installing Microsoft SQL Server 2005 Express Edition
Microsoft SQL Server 2005 Express Edition has a maximum database size of 4 GB. You can download Microsoft SQL Server 2005 Express from www.microsoft.com.
The version of Microsoft Dynamics GP that runs on Microsoft SQL Server 2005
Express is limited to 10 users.
Microsoft SQL Server 2005 Express doesn’t include SQL administrative tools. You can download Microsoft SQL Server Management Studio Express and SQL Server 2005 Books Online for SQL Server Express from www.microsoft.com.
Use the information in this section to install Microsoft SQL Server 2005 Express on your computer.
To install Microsoft SQL Sever 2005 Express Edition:
1. Insert the SQL Server 2005 DVD. The main SQL Server installation screen should appear. If you do not see this screen, browse the DVD and double-click the Splash.hta file.
2. Click Run in the SQL Server Installation Wizard.
3. Mark the option to accept the terms of the End-User License Agreement and then click Next.
4. In the Installing Prerequisites window, click Install to install the software components that are required for Microsoft SQL Server 2005 Express. After the components are installed, click Next.
5. In the Welcome to the Microsoft SQL Server Installation Wizard window, click Next.
6. Your computer is scanned for conditions that may stop installation. To proceed with the installation, click Next in the System Configuration Check window. For more information about the items that are checked, click Help.
7. Enter your name and company in the Registration Information window, and click Next.
8. In the Feature Selection window, select the features for your installation and specify the location to install Microsoft SQL Server Express Edition. Click Next.
9. In the Authentication Mode window, select Mixed Mode as the authentication mode. Mixed Mode is required by Microsoft Dynamics GP.
With Mixed Mode, users can connect using Windows Authentication or SQL Server Authentication. You must enter and confirm the system administrator password when you select Mixed Mode.
10. Specify whether or not to allow error and usage reporting in the Error and Usage Report Setting window. Click Next.
11. In the Ready to Install window, review the list of components that will be installed and click Install.
12. The Setup Progress window appears, allowing you to view the status of the installation. Click Next after the installation has been completed.
13. In the Completing the Microsoft SQL Server Installation Wizard window, click Finish to exit the installation wizard.
14. Restart the computer if you are instructed to do so.

No comments: