On the Authentication mode window (Figure I), choose whether
you want to configure SQL Server 2005 as Windows Authentication only or Mixed
Mode. If you choose Mixed Mode, you must assign a strong sa password as shown
in Figure I. On the Collation Settings window, accept the defaults unless you
have specific collation requirements for your company (Figure J).
If you are installing Reporting Services, specify the Report
Server virtual directory and the Report Manager virtual directory as shown in
Figure K. On the Report Server Database Setup, choose the appropriate instance
that you want the Reporting Server installed on (see Figure L) as well as the
Report Server database name.
On the Report Server Delivery Settings window, enter the
appropriate SMTP setting as shown in Figure M and decide in the Error Reporting
window (Figure N.) whether you want to automatically send fatal error reports
On the Ready to Install window, review your components and
click install as shown in Figure O. You are now presented with a Setup progress
window (see Figure P.) and when all components are installed, click Next.
Figure Q. displays the final window with a link to a Summary Log. Click Finish.
In my next article, we will go over the new interface of SQL 2005 and see what
it has to offer.
See All Articles by Columnist Steven S. Warren