Re: Connecting to AS 2005 using a specified user
- From: "Dave Wickert [MSFT]" <dwickert@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 7 Dec 2005 16:17:08 -0800
Specifying the port number like that will control the http port which will
be used (rather than the default 80). If you want to change the AS port
number, you need to edit the config file for the data pump.
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pat" <pat@xxxxxxxxxxxxx> wrote in message
news:F68ED036-322E-4E71-A850-493DAA5AD56D@xxxxxxxxxxxxxxxx
> Sorry, forgot the question about direct connection.
> Just specify SERVER:PORT where you used to specify http://SERVER/ in the
> connection strings.
> To assign AS2005 to a specific port, right click on the AS server in the
> management studio, choose Properties, select Show Advanced Properties, and
> set the value in the Port property.
>
> "Gustaf" wrote:
>
>> I'm very interesing in following this issue, please post any details to
>> this
>> newsgrup.
>>
>> Regards Gustaf
>>
>> "Dave Wickert [MSFT]" wrote:
>>
>> > Do you have a case# for this incident? I'd like to look it up.
>> > This is certainly is not our intention for this feature.
>> > It is a bug and I want to make sure it is being treated as such
>> > internally.
>> > You can just email it to me directly.
>> > --
>> > Dave Wickert [MSFT]
>> > dwickert@xxxxxxxxxxxxxxxxxxxx
>> > Program Manager
>> > BI Systems Team
>> > SQL BI Product Unit (Analysis Services)
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> >
>> > "Pat" <pat@xxxxxxxxxxxxx> wrote in message
>> > news:A5950AD0-DE8B-4EC6-8113-E0AE8567A608@xxxxxxxxxxxxxxxx
>> > >I have opened a support call with PSS and after 2 weeks of hard work,
>> > >the
>> > > conclusion of the escalation engineer is that you cannot use http and
>> > > basic
>> > > authentication on AS2005, which worked on AS2000.
>> > > People on this newsgroup tend to be connected to the server through a
>> > > Windows network and use windows authentication (or have the same user
>> > > on
>> > > the
>> > > client and the server, which is not workable in a production
>> > > environment).
>> > >
>> > > The problem is that the new OLEDB 9 driver prevents the
>> > > authentication
>> > > information to be passed from IIS to AS2005, so you have no way to
>> > > authenticate to AS2005, unless you connect directly to it the way I
>> > > indicated.
>> > >
>> > > The next problem is that once you have installed OLEDB 9 on your
>> > > clients
>> > > machines, they cannot access AS2000 through http any more in the
>> > > following
>> > > scenario: connect to an AS2000 cube with OWC, click "Export to
>> > > Excel",
>> > > then
>> > > try to refresh in Excel. This fails with OLEDB 9, works with OLEDB 8.
>> > > So
>> > > their existing application is broken.
>> > >
>> > > Basically, you don't want to go for AS2005 if you don't have all of
>> > > your
>> > > users and the server in one single Windows domain, or in trusted
>> > > domains.
>> > >
>> >
>> >
>> >
.
- References:
- RE: Connecting to AS 2005 using a specified user
- From: Darren Gosbell
- Re: Connecting to AS 2005 using a specified user
- From: Dave Wickert [MSFT]
- RE: Connecting to AS 2005 using a specified user
- Prev by Date: Re: List of Databases on Analysis Server
- Next by Date: Re: Olap Services closes with "out of memory" error once in few da
- Previous by thread: Re: Connecting to AS 2005 using a specified user
- Next by thread: Re: Connecting to AS 2005 using a specified user
- Index(es):
Relevant Pages
|
