Have your free copy of GP10

Saturday, May 24, 2008

To install Microsoft SQL Server 2005:

1. Insert the SQL Server 2005 DVD. The main SQL Server installation screenshould appear. If you do not see this screen, browse the DVD and double-clickthe 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 SQL Server 2005. 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 Components to Install window, select the components for your SQL
server installation and click Next.
To install individual components, click Advanced.
If you are installing a failover cluster, see How to: Create a New SQL Server 2005 Failover Cluster (Setup) in the MSDN Online Library (http://msdn2.microsoft.com/ms179530.aspx).
9. The Feature Selection window opens if you selected to install individual
components. Select the program features you want to use and specify the location to install SQL Server 2005. Click Next.
10. In the Instance Name window, select a default or named instance for your installation.
• To install a new default instance (the primary instance on the computer), click Default instance and click Next. There can be only one default instance.
• To install a new named instance, click Named instance and then enter a unique instance name. Click Next.
• If a default or named instance is already installed, select the existing instance for your installation and click Next. The instance upgrades and you will have the option to install additional components.
For information about using instances of SQL Server, see your SQL Server documentation. We recommend that you have a dedicated server.
11. In the Services Accounts window, specify the user name, password and domain name for the service accounts. We recommend that you use the same account for each service and automatically start services. Click Next.
12. 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.

No comments: