MEMOEXP

Our System Center Memo

Installing SQL 2005 Standard

Before installing SCCM, you will need to install SQL. I’ll walk you through with screenshots below. Guides to other installation as below.

Install SQL 2008 R2, Configuring SCCM Prerequisites, Install SCCM.

Launch the SQL Installer.

1. Click Server Components, tools, Books Online, and samples under Install.

image

If below appears, click Run program.

image

 

2. Check the license agreement, click Next.

image

 

3. Click Install.

image

 

4. Click Next.

image

 

5. Click Next.

image

 

6. There will be a warning on ASP .Net Version Registration Requirement if you’re running on a 64bit OS, but installation can still proceed. Click Next.

image

 

7. Click Next.

image

 

8. Check SQL Server Database Services, click Next.

image

Optional step. From Advanced, I expended Client Components and chose Management Tools and Business Intelligence Development Studio but this is not mandatory.

image

 

9. Click Next.

image

 

10. Select Use the built-in System account, and select Local system on the drop down. Also check SQL Server Agent. Click Next.

image

 

11. Select Windows Authentication Mode, click Next.

image

 

12. Select SQL collations (used for compatibility with previous versions of SQL Server), then select Dictionary order, case-insensitive, for use with 1252 Character Set. Click Next.

image

 

13. Click Next.

image

 

14. Click Install.

image

If below screen appears, click Run Program.

image

 

15. Click Next.

image

 

16. Click Finish.

image

 

Installing SQL 2005 Standard SP3

You are required to update your SQL 2005 to SP3. Unfortunately my screen shots are gone so you’ll have to try this yourself. Its straightforward but if you bump into any questions just post a comment here.

NOTE! SQL2005 Standard SP3 is a cumulative update, you are not required to install the previous service packs.

Advertisements

March 13, 2011 - Posted by | System Center Configuration Manager (SCCM)

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: