Category / Section
How to get connection string from an Excel sheet in .NET WebForms OlapClient ?
4 mins read
This KB illustrates that how to get connection string from an Excel sheet.
Solution
You can follow the given steps to get connection string.
Step 1
Open a new Excel sheet.
Step 2
Click Data tab à From Other Sources à From Analysis Services.
Step 3
The Data Connection Wizard dialog appears. Provide server name in Server Name textbox and click Next.
Note:
When you have credentials to your SQL Server, enter its user name and password accordingly.
Step 4
Select the Cube and click Next.
Step 5
Finally, click Finish.
Step 6
Now, click the Analyze tab à Change Data Source à Connection Properties…
Step 7
The Connection Properties window appears. Select the Definition tab and copy the connection string.
You can use this connection string in your project or application, holding your OLAP control.