Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Dec 29, 2004

SQL Server 2005: Day to Day DBA - Part I - Page 2

By Steven Warren

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.

Figure K.

Figure L.

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 to Microsoft.

Figure M.

Figure N.

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

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM