<div>
I am having this constant issue with the linked servers, always fail to create one and even when I succeed , only the master &nbsp;DB is transferred (though I specify the DB I need to use ) and I fail to save the query in a regular view .<br />
I am totally new in the linked server thing and though I posted a question earlier on how to create a linked server the post didn’t help to create what I need.<br />
<br />
Can you take me through the whole process step by step on how to create linked server using the wizard in enterprise manager.<br />
<br />
Thanks<br />

</div>


<div>
Ok lets start from scratch and create first linked server then you should be able to use them in any SQL query by fully qualifying the object name like linked_server_name.db_name<wbr />.schema.ob<wbr />ject_name<br />
I assume that both servers are on the same NT domain therefor we could use either a NT login account with SA rights on the remote SQL box or a new dedicated SQL login with SA rights on the remote SQL box &nbsp;and to be used for the linked server purpose only. No matter which one you choose the process should be the same and I’ll just call it link_login but please make sure it EXITS on the remote SQL servers under Security and is part of the sysadmin server role.<br />
Use SQL Server Enterprise Manager to Create a linked server definition using the SQL Server Enterprise Manager Console tree and the Linked Servers node (under the Security folder). Define the name (you could use an IP but I suggest you create an alias name for it under network client utility), provider properties, server options, and security options for the linked server. As both are SQL servers I suggest you use “Microsoft OLE DB Provider for SQL Server” and under security use the link_login account created to handle all the activity for these two servers – use “Be made using this security context”.<br />
You should be able now to run a query like below on the SQL server where you added your linked server to test it and from here on…you can write any queries against it or use it in a DTS connection manager.<br />
Select top 10 * from linked_server_name.db_name<wbr />.schema.ob<wbr />ject_name<br />

</div>


<div>
I failed to create the linked server so I used instead the DTSes and union statement to create the shared dimensions, thx
</div>


<div>
<div class="content wysiwyg-content">
I have two different servers, and I would like to create report that could combines data from two different databases each located in a different server.<br />
Please note that the DB structure is identical but the data stored in each db is different, for example we have HR employees data is stored in Server 1 &amp;&nbsp;Marketing employees data is stored in Server 2, different Employee_ID of course, the report should have both employees data (as measures) and the Employee_ID as a shared dimension, but I don't know how to do that.<br />
<br />
We are using SQL server 2000 &amp;&nbsp;analysis services enterprise edition SP4.<br />

</div>
</div>


I have two different servers, and I would like to create report that could combines data from two different databases each located in a different server.
Please note that the DB structure is identical but the data stored in each db is different, for example we have HR employees data is stored in Server 1 & Marketing employees data is stored in Server 2, different Employee_ID of course, the report should have both employees data (as measures) and the Employee_ID as a shared dimension, but I don't know how to do that.

We are using SQL server 2000 & analysis services enterprise edition SP4.


How can I create OLAP report that could retrieve data from two different servers ?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.