RE: Connecting to AS 2005 using a specified user

AS2005 does allow a similar HTTP connection option to AS2000.

Actually the "MDX Sample App broken by 2005" thread only referred to an
issue where the person was using basic authentication with prompt=1
turned on and the end users were being asked to authenticate twice. HTTP
authentication does still work in 2005, the issue was the users had to
enter their username and password twice.

If you want to put the userid and password in the connection string you
should not see this issue.

Check out:
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx
....for configuring HTTP access on Win 2003

And:
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx
....for configuring HTTP access on Win XP

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <0ECC73AD-25D1-4AC9-9B08-5920169F50F8@xxxxxxxxxxxxx>,
pat@xxxxxxxxxxxxx says...
> You need to set up a windows account for each user on each AS2005 server and
> connect using the SERVERNAME:PORT syntax in the data source, after assigning
> a fixed port to AS2005.
> You also need to install oledb 9 at each client, and this will cause their
> existing http access to AS2000 to fail, since my experience is that oledb 9
> is not backwards-compatible with oledb 8.
>
> Basically, AS2005 connectivity only works if you're a Microsoft-only shop.
> Otherwise, you've got to stick to AS2000
>
>
> "Gustaf" wrote:
>
> > Ok. thanx pat.
> >
> > Any idea on how to connect if a user does not logon to the same domain as
> > the SQL server?
> >
> > Regards Gustaf
> >
> > "Pat" wrote:
> >
> > > No AS2005 http connectivity won't work in your case. You have to stay with
> > > AS2000.
> > > Have a look at the thread "MDX Sample App broken by 2005" in this newsgroup.
> > >
> > > "Gustaf" wrote:
> > >
> > > > in AS 2005 it was not possible to state a user and password in order to
> > > > connect to a cube. All end user access was controlled by a windows accont. Is
> > > > it possible to state a username and password in the connectionstring using
> > > > msolap.3???
> > > >
> > > > Does AS 2005 support connecting via HTTP in the same manner as SQL server
> > > > 2000?
> > > >
> > > > Regards Gustaf
> > > >
>

.

Relevant Pages

  • RE: RPC Over HTTP
    ... Normally running the CEICW (configure e-mail and internet connection ... wizard) and allowing RPC over HTTP option on the ... Web services configuration page should configur your server to allow RPC ... Verify that the certificate is installed by going to ...
    (microsoft.public.windows.server.sbs)
  • RE: Cannot connect via http but https works?
    ... Only one computer of three on my adhoc workgroup reports this error. ... only HTTP won't work. ... regsvr32 SOFTPUB.DLL ... computer and try to establish a connection and try the link, ...
    (microsoft.public.windowsxp.network_web)
  • Re: RPC over HTTP problem for some users only
    ... This will cause the Exchange ... The default connection methodology for Outlook 2003 when RPC/HTTP is ... Fast - TCP/IP then HTTP ...
    (microsoft.public.outlook.installation)
  • Re: RPCoHTTP always has 4 failures
    ... ON fast networks, connect using HTTP first, then connect using TCP/IP ... Outlook doesn't even prompt me to log in, it just says the server is ... Warning If you use Registry Editor incorrectly, ... It always shows HTTPS as the protocol in the connection ...
    (microsoft.public.exchange.admin)
  • RE: Yet another thread on the legality of port scanning
    ... Authorized users are told they are authorized users. ... is an acceptable connection in the absence of explicit permission? ... expected to be a public http server. ...
    (Security-Basics)