Problem with multiple instant of SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kam - 16 Feb 2005 04:57 GMT

I have 2 instant of SQL server on the same machine.
1st instant keep most of the static information - Dimensional data
2nd instant keep most of the transaction information.

When I try to use the Analysis Services, I have 2 connection, but they can't
talk to each other.

after I define the fact table, I can't pull out the share dimension in the
wizard.

Can anyone confirm the Analysis services is work 1 instant at a time or it
will work with mutiple instant of SQL server?

Reply to this Message

Ray - 16 Feb 2005 12:25 GMT

Your scenario sounds a bit odd. Why two instances? Why split facts from
dimensions? If you really what this to work, try the following:

Create a linked server.
Create views with four part names using the linked servers to the tables you
need.

Keep in mind that your server configuration is handicapping the optimizer.

>I have 2 instant of SQL server on the same machine.
> 1st instant keep most of the static information - Dimensional data
[quoted text clipped - 9 lines]
> Can anyone confirm the Analysis services is work 1 instant at a time or it
> will work with mutiple instant of SQL server?

Reply to this Message

Dave Wickert [MSFT] - 17 Feb 2005 18:53 GMT

That is correct. With AS2K you cannot have dimensional data come from one
database; and fact data from another. Typically I recommend to customers
that they create views in the dimensional database which point to tables in
the fact database (or vise-versa, whatever is easiest for you).

Signature

Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

> I have 2 instant of SQL server on the same machine.
> 1st instant keep most of the static information - Dimensional data
[quoted text clipped - 8 lines]
> Can anyone confirm the Analysis services is work 1 instant at a time or it
> will work with mutiple instant of SQL server?

Reply to this Message