Optimizing Microsoft SQL Server Reporting Services: Execution Log Reporting: Preparation as a Data Source

7. Expand the Databases folder, so as to display its contents.

8. Right-click the Databases folder.

9. Click New Database … in the context menu that appears, as shown in Figure 6.




Figure 6: Select New Database

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


10. Type the following into the Name box:


SSP-RS001_ExecutionLog


The General tab of the Database Properties dialog appears as depicted in Figure 7.




Figure 7: The Database Properties Dialog – General Tab

11. Adjust the settings on the Data Files and Transaction Log tabs to place the files in the file system location you desire (I left mine at default for this exercise).

12. Click OK to accept changes and to close the Database Properties dialog.
The dialog closes and the database appears (after refreshing the Enterprise Manager console, as required).

13. Leaving Enterprise Manager open, click the Start button once again.

14. Navigate to the Microsoft MSSQL Server – Query Analyzer shortcut in the Programs group, as appropriate.


The equivalent on my PC appears as shown in Figure 8.




Figure 8: Navigating to the Query Analyzer

15. Select Query Analyzer from the menu. The Connect to SQL Server dialog appears.

16. Select the appropriate server in the SQL Server selector box.

17. Select the radio button to the left of the appropriate authentication selection, supplying login credentials as required.


The Connect to SQL Server dialog appears (with my settings for this exercise) as depicted in Figure 9.




Figure 9: Connect to SQL Server Dialog

 

Continues…



Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |