Another Domain

Hi,
We have SQL Server 7.0 running on NT 4.0 ( I know we should have moved on
but that's another story).
We also have VB6 apps accessing the SQL Server using Windows authentication
.
Until now only users within our domain needed to use the apps.
There are a number of NT security groups to which we add our users depending
on their required permission levels.
However we now have a situation where users from an external domain need
access to the VB6 apps. They will also need to synchronise data using merge
replication.
Is there a way of mapping such users to our NT Security groups even though
they are members of an external domain. There will be co-operation from the
administrators of the other domain.
We would rather stick with Windows Authentication rather than Mixed Mode.
Any help greatly appreciated.
DDHi
You would need to setup trusts between the 2 domains. This is done at OS
level. Get your admins to look if it is something they really want to do. An
external company, unless it is in the same legal entity group, should not be
trusted as you have no control over their admins.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave52" wrote:

> Hi,
> We have SQL Server 7.0 running on NT 4.0 ( I know we should have moved on
> but that's another story).
> We also have VB6 apps accessing the SQL Server using Windows authenticati
on.
> Until now only users within our domain needed to use the apps.
> There are a number of NT security groups to which we add our users dependi
ng
> on their required permission levels.
> However we now have a situation where users from an external domain need
> access to the VB6 apps. They will also need to synchronise data using mer
ge
> replication.
> Is there a way of mapping such users to our NT Security groups even though
> they are members of an external domain. There will be co-operation from th
e
> administrators of the other domain.
> We would rather stick with Windows Authentication rather than Mixed Mode.
> Any help greatly appreciated.
> DD
>|||The way I'd handle this is to create a local group on the SQL Server box tha
t
contains a global group from the remote domain. Then I'd simply give permiss
ions
inside SQL Server to this local group. For this to happen of course, there m
ust
be a trust between the domain that contains the SQL Server and the "external
"
domain that wants access to it.
HTH
Thomas
"Dave52" <Dave52@.discussions.microsoft.com> wrote in message
news:D40BC61F-A792-4442-BF6B-FF29BFAB9258@.microsoft.com...
> Hi,
> We have SQL Server 7.0 running on NT 4.0 ( I know we should have moved on
> but that's another story).
> We also have VB6 apps accessing the SQL Server using Windows authenticati
on.
> Until now only users within our domain needed to use the apps.
> There are a number of NT security groups to which we add our users dependi
ng
> on their required permission levels.
> However we now have a situation where users from an external domain need
> access to the VB6 apps. They will also need to synchronise data using mer
ge
> replication.
> Is there a way of mapping such users to our NT Security groups even though
> they are members of an external domain. There will be co-operation from th
e
> administrators of the other domain.
> We would rather stick with Windows Authentication rather than Mixed Mode.
> Any help greatly appreciated.
> DD
>

Analysis Services end-user frontend

Hi,

I've developped a simple testing SQL Server 2005 Analysis Services solution.

I tried with Excel 2003 and pivot tables for accessing the cubes, because end users are very used to that enviroment.

The problem is that selection of dimensions and measures is dificult because there are too many, and not arranged into folders. All attributes of all the dimensions and all the measures are displayed in a -plain- format (as far as I know). That's very frustrating, because is difficult for the user to select the correct dimensions, attributes, and measures.

I tried with XLAddinSetup.msi, but I didn't like it, because I think that isn't so powerful and easy to use than pivot tables.

What can I do?

Do you recommend to use another frontend, not Excel?

Many thanks.

This is a very difficult time to recommend a front-end to Analysis Services given Microsoft's recent acquisition of Proclarity:

http://www.microsoft.com/presspass/press/2006/apr06/04-03ProClarityPR.mspx

There are a lot of good tools on the market, but no-one knows how many will be around this time next year! Obviously Proclarity will be in some shape or form, though it might make sense to wait and see what Microsoft's plans are for it. It's probably a good idea to contact your local Proclarity office and ask them what is going to happen in the short-term; if there's someone from Proclarity reading this, perhaps they can make a public statement here?

Chris

|||

Chris Webb wrote:

This is a very difficult time to recommend a front-end to Analysis Services given Microsoft's recent acquisition of Proclarity:

http://www.microsoft.com/presspass/press/2006/apr06/04-03ProClarityPR.mspx

There are a lot of good tools on the market, but no-one knows how many will be around this time next year! Obviously Proclarity will be in some shape or form, though it might make sense to wait and see what Microsoft's plans are for it. It's probably a good idea to contact your local Proclarity office and ask them what is going to happen in the short-term; if there's someone from Proclarity reading this, perhaps they can make a public statement here?

Chris

Ok, I think I can wait.

On the other hand, I still think that Excel is enough for the moment, but my problem is, as I said before, that accessing to dimensions and measures of OLAP cubes is messy, because the list isn't hierarchy organized in folders.

Does anybody know how to do that?

|||

I don't think you will be able to do this with any current version of Excel, although Excel 2007 will be able to do it.

Chris

|||

As Chris mentions ProClarity might be a good bet for you. However, I can also recommend the Danish front-end TARGIT, which has some very compelling and user-friendly features. You can download a 30-day demo version from http://www.targit.com/Products/Demo_and_Videos/Download_30_days_trial_demo.aspx

TARGIT is able to handle the meta data from AS 2005 and present this in a nice manner.

|||

I also recommend that you look into the upcoming Office 2007 release. Excel has many enhancements specifically targetted at AS 2005.

http://www.microsoft.com/presspass/press/2005/oct05/10-23BiLaunchPR.mspx

|||

If you can't wait for Excel 2007 there are some 3rd party add-ins for Excel currently available:
XLCubed
BIXL
O2OLAP

If you want to move away from Excel and don't like ProClarity look at ExecutiveViewer from www.temtec.com. Have you tried Reporting Services with SSAS? Microsoft is pushing this very hard (but it is more a developer tool than an end-user solution).

Dr Cube