ODBC root is i of the many sources that y'all tin connect to inward Reporting
Services using the Report Builder.
Here are the steps. It is assumed y'all get got SQL Server 2016 SP1 installed; Report Builder is also
installed on the same machine. For these steps it is assumed that the SQL Server is upward as well as running
as well as y'all are the possessor of the estimator who installed the SQL Server.
1. Launch Report Builder alongside Administrative Privileges.
2. Right click Data Sources as well as Click Add DataSource... to convey upward the Data Source properties window.
3. Provide a refer for the information source, DS_ODBC
4. Choose Use a connectedness embedded inward my report
5. Select connectedness type: click handgrip as well as select ODBC at the bottom of list
6. Click Build... to convey upward the Connection properties window
7. In the Data root specification department select Use connectedness string:
8. Click the Build... push that gets activated to display Select Data Source window
9. Click Machine Data Source
10. In Machine Data Source tabbed page, click New... to display Create New Data Source
11. Accept the default, User Data Source as well as click Next
12. In the Select a driver for which y'all desire to gear upward a information source, scroll downward as well as
select SQL Server (SQLSRV32.dll); click Next to display the side past times side window
13 Click Finish. Create a New Data Source to SQL Server is displayed
14. Provide a refer of your choice (ODBC_DSN); Description:(ODBC for Report Builder); Server
purpose handgrip to locate: Hodentek9\OHANA. Click Next
15. Accept the default inward the displayed page: alongside Windows NT authentication using the
Network login id. Click Next
16. Change the default database past times clicking handgrip to Northwind. conduct all other
defaults. Click Next
17. Accept all defaults on the displayed page. Click Finish
18. In the ODBC Microsoft SQL Server Setup page exam the connectedness as well as brand certain it works. Click OK
19. ODBC_DSN enters the Machine Data Source tabbed page. Click OK
20. SQL Server Login window gets displayed. Enter creator owner's credentials
21. Copy the connectedness string from the connectedness properties window.
Dsn=ODBC_DSN;description=ODBC for Report Builder;trusted_connection=Yes;app=Microsoft SQL Server;wsid=HODENTEK9;network=DBNMPNTW
22. Test Connection to brand certain it works
23. Click OK
The Connection string enters the Data Source Properties window equally shown.
Services using the Report Builder.
Here are the steps. It is assumed y'all get got SQL Server 2016 SP1 installed; Report Builder is also
installed on the same machine. For these steps it is assumed that the SQL Server is upward as well as running
as well as y'all are the possessor of the estimator who installed the SQL Server.
1. Launch Report Builder alongside Administrative Privileges.
2. Right click Data Sources as well as Click Add DataSource... to convey upward the Data Source properties window.
3. Provide a refer for the information source, DS_ODBC
4. Choose Use a connectedness embedded inward my report
5. Select connectedness type: click handgrip as well as select ODBC at the bottom of list
6. Click Build... to convey upward the Connection properties window
7. In the Data root specification department select Use connectedness string:
8. Click the Build... push that gets activated to display Select Data Source window
9. Click Machine Data Source
10. In Machine Data Source tabbed page, click New... to display Create New Data Source
11. Accept the default, User Data Source as well as click Next
12. In the Select a driver for which y'all desire to gear upward a information source, scroll downward as well as
select SQL Server (SQLSRV32.dll); click Next to display the side past times side window
13 Click Finish. Create a New Data Source to SQL Server is displayed
14. Provide a refer of your choice (ODBC_DSN); Description:(ODBC for Report Builder); Server
purpose handgrip to locate: Hodentek9\OHANA. Click Next
15. Accept the default inward the displayed page: alongside Windows NT authentication using the
Network login id. Click Next
16. Change the default database past times clicking handgrip to Northwind. conduct all other
defaults. Click Next
17. Accept all defaults on the displayed page. Click Finish
18. In the ODBC Microsoft SQL Server Setup page exam the connectedness as well as brand certain it works. Click OK
19. ODBC_DSN enters the Machine Data Source tabbed page. Click OK
20. SQL Server Login window gets displayed. Enter creator owner's credentials
21. Copy the connectedness string from the connectedness properties window.
Dsn=ODBC_DSN;description=ODBC for Report Builder;trusted_connection=Yes;app=Microsoft SQL Server;wsid=HODENTEK9;network=DBNMPNTW
22. Test Connection to brand certain it works
23. Click OK
The Connection string enters the Data Source Properties window equally shown.
Komentar
Posting Komentar