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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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