Building a Multi-table Report with SQL 2005 Reporting Services - Connecting to data
(Page 3 of 6 )
The name provided for the New data Source is DS2005. Click on the Edit... button. The Connection properies window shows up as shown in the next picture. The screen comes up with the default data source, the Microsoft SQL Server (SQLClient). This is a new data source in SQL 2005 Server.
For the Server Name:, insert Hodentek\Mysorian. For the SQL 2005 Server on this machine, the User Name=sa; and Password=xxxx are the proper ones for SQL Server authentication. Place a check mark in the Save my password checkbox as shown. Choose the Northwind database from the Select or enter a database name drop-down. The drop-down will show all the databases assuming the information you entered is correct. You may also test the connection by clicking on the Test Connection...button.
Close the Microsoft Visual Studio message window by clicking on the OK button and close the Connection properies window as well.
This will get you back to the --ReportWizard-Select DataSource window.
Click on the Next Button.
Next: Creating a query >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
/ 13 
