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

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.

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)

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

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

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.

Illustration 8: Database Properties Dialog - Data Files Tab

12.  Click the Transaction Log tab.

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.