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 Jun 23, 2004

MSSQL Server Reporting Services: Managing Reporting Services: Data-driven Subscriptions, and External Data Sources for Subscriber Data - Page 4

By William Pearson

Create the Database and Table in Enterprise Manager

Let's go to MSSQL Server 2000 Enterprise Manager ("Enterprise Manager") to create our new source.

1.  Click Start.

2.  Navigate to the Microsoft SQL Server program group that installs within a typical setup. The equivalent on my PC appears as shown in Illustration 3.

Click for larger image

Illustration 3: Navigate to Enterprise Manager ...

3.  Click Enterprise Manager (shown circled above) to initialize the application.

We arrive within the Enterprise Manager Management Console, as shown in Illustration 4.

Illustration 4: In the Enterprise Manager Management Console (Compressed View)

4.  Expand the MSSQL Servers group object by clicking the "+" sign to its immediate left.

5.  Expand the SQL Server Group object that next appears.

6.  Expand the server to which you intend to connect next (mine appears as LOCAL), as depicted in Illustration 5).

Illustration 5: Expand the Selected Server (Compressed View)

NOTE: The registered servers and other objects will appear different in this view on your own PC, and will depend upon your environment.

7.  Right-click the Databases folder under the selected server.

8.  Select New Database on the context menu that appears, as shown in Illustration 6.

Illustration 6: Select New Database ...

The Database Properties dialog appears, defaulted to the General tab.

9.  Type the following into the Name box on the General tab:


The Database Properties dialog - General tab appears as shown in Illustration 7.

Illustration 7: Database Properties Dialog - General Tab

10.  Click the Data Files tab.

11.  Ascertain that the default location is satisfactory for the placement of the new database. If not, make appropriate changes.

The Database Properties dialog - Data Files tab for my server (I left all at default) appears as shown in Illustration 8.

Illustration 8: Database Properties Dialog - Data Files Tab

12.  Click the Transaction Log tab.

I again left my settings at default; the Database Properties dialog - Transaction Log tab for my server appears as shown in Illustration 9.

Illustration 9: Database Properties Dialog - Transaction Log Tab

13.  After making any necessary adjustments specific to your environment, click OK to create the new RS_Subscription database.

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