Installing SQL Server 2008 - Code name "Katmai"

Well, I finally got around to installing SQL Server 2008. Ran into a little problem when it came to the Server Configuration screen. I got this error

"Invalid or missing username or password. To continue, provide valid credentials for the SQL Server Agent service".

The solution was to use my credentials for the login with username of mss/wandrus and my login password.

 

UPDATED: http://www.sql-articles.com/articles/SQL2008/ins_2008.html
http://www.sql-articles.com/index.php?page=articles/SQL2008/ins_2008.html does a nice job of showing how to step through the installation process.

BizTalk Assessment Question: Best way for deploying

What type of file is used in Microsoft(R) BizTalk(R) Server 2006 to make application deployment and management easier by using the new application concept?

• Batch files
• .msi files
• XML files
• Microsoft Windows(R) Management Instrumentation (WMI) files
• Flat files

MSI makes the most sense here. It allows for minipulation to allow for a set of smaller MSI files instead of one large MSI file, and you can manipulate the MSI file with pre and post processing scripts.

BizTalk Assessment Question: What is needed for complete installation?

Which products are required for a complete installation of all features of Microsoft(R) BizTalk(R) Server 2006? (Each correct answer presents part of the solution. Choose
three.)

1. Microsoft .NET Framework 2.0
2. Microsoft Internet Explorer 7
3. Microsoft Commerce Server 2006
4. Microsoft Office Excel(R) 2003 with Service Pack 2
5. SQLXML 3.0 with Service Pack 3
6. Microsoft Office OneNote(R) 2003 with Service Pack 1

Answer found: SQLXML 3.0 with Service Pack 3, Microsoft Office Excel(R) 2003 with Service Pack 2, and Microsoft .Net Framework 2.0

BizTalk Assessment Question: Bypass pre-reqs

You are performing a silent installation of Microsoft(R) BizTalk(R) Server 2006.
You want to bypass checks for downloadable prerequisites.

What new command line parameter should you use?

1. /IGNOREDEPENDENCIES
2. /ADDLOCAL ALL
3. /PASSIVE
4. /COMPANYNAME

1) Bypasses the checks for downloadable prerequisites.
2) Installs all features.
3) Performs a passive installation. The setup program only displays the progress bar.
4) Sets the company name.