Hi,

I opened the tutorial project:
d:\Program Files\SQL Server 2005\90\Samples\Analysis Service\Tutorial\
Lesson4\Analysis Service Tutorial.sln

When I deploy it, an error occurs:
The project could not be deployed to the 'tpew2kdm' server because of
the
following connectivity problems : A connection cannot be made. Ensure
that
the server is running. To verify or update the name of the target
server,
right-click on the project in Solution Explorer, select Project
Properties,
click on the Deployment tab, and then enter the name of the server.

I checked the Deployment Target:
Server = myserver
Database = Analysis Service Tutorial

I guess I have to create that database on Analysis Service, but I can't

connect to Analysis Service with SQL Server authentication. I connect
through VPN from home to office server with SQL Server authentication.
Because I connect from an untrusted machine, I can't use Windows
authentication, so I am stuck.

Any comments are highly appreciated.

Are you able to resolve the server by name?
Can you ping the server by name?

Sometimes (depending on yuor office DNS/WINS setup) if you are VPN'd from
home, you may not have full access to remote servers/clients using netbios.

Have you tried to use IP address?

Immy

"Dino Hsu" <dino_hsu_1019 (AT) yahoo (DOT) com> wrote

Yes, I can connect to database engine with SQL Server authentication,
but it seems not to allow SQL Server authentication for analysis
service.

Hi!

Can you connect to AS (obviously with Windows Integrated authentification)?

Vladimir Chtepa


"Dino Hsu" <dino_hsu_1019 (AT) yahoo (DOT) com> schrieb im Newsbeitrag
news:1136828173.189411.91960 (AT) o13g2000cwo (DOT) googlegroups.com...

I can connect to AS from office client. From home client with Windows
authentication, always fails because of "untrusted" thing.

There is no "SQL authentication" equivalent for Analysis Services. All
the authentication comes back to windows accounts.

Can you leave your office machine running and connect to it via remote
desktop and use that to work from home?

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

In article <1136854747.426551.37230 (AT) g14g2000cwa (DOT) googlegroups.com>,
dino_hsu_1019 (AT) yahoo (DOT) com says...

Dear Darren,

Yes, for learning purpose, I plan to upgrade my home Pentium III 800M
512M SDRAM DRAM to Pentium IV 3G + 2G DDR-2 DRAM. (I prefer to add 1
DRAM to my other home AMD Sempron 2.2G, unfortunately, SQL Server 2005
doesn't support it)

However, if SQL Server authentification is not supported in analysis
service, do you mean analysis service is not for Internet access? How
can Internet random user be authenticated?

Thanks again.

try this:
first, access a shared folder on the server (\\asserver\myfolder)
second, try to access the cube

does your VPN connection is the Windows VPN one?


"Dino Hsu" <dino_hsu_1019 (AT) yahoo (DOT) com> wrote

it's Cisco VPN client I use.

In article <1136909450.038660.59610 (AT) f14g2000cwb (DOT) googlegroups.com>,
dino_hsu_1019 (AT) yahoo (DOT) com says...
All the security roles have to map through to a windows user (either
local or domain users) so all user/password maintenance has to be done
through windows.

That said, you can still authenticate a "random" internet user if you
set up HTTP authentication or use XML/A. There are a couple of things to
watch, with AS2k you need to have the enterprise edition to get the http
authentication feature, with AS2k5 there are a couple of issue with http
authentication in combination with basic authentication (there are a
couple of threads in this newsgroup relating to them)

If your internet users are coming in as anonymous users you can also use
http authentication and just map them to a single known account.

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