remote database connection

Hello,

My database stays in a remote site and I have access it through VPN. I would like connect my current Windows based Asp.Net application with this database. What are my options? Can I connect remote database with SqlDataAdaper, will that be slow? Should I sue Web Services to connect database?

If you can Ping the database server from the server running the ASP.NET code, you should be able to connect the exact same way as you can connect to a machine right next to your machine. The speed or slowness depends upon exactly what you are doing. It is likely that using the standard SqlClient classes will be faster and easier than trying to do it using a Web Service.

Remote Connection to Analysis Services using VPN

Given that MS Analysis Services does not support standard SQL Server
Authentication (thus requiring windows user accounts), is it possible for a
remote client PC, connected to a network using a VPN, to be authenticated on
an Analysis Server if it is not part of the host domain? If so, how can this
be achieved?
Is there a way of using the anonymous login account?
If not, is this not a strange inconsistency with SQL server, and are there
plans to address this with Yukon?
Many Thanks
Simon Kirk
I am running into the same problem. Currently we are kludging this by
creating a "pass-thru" user on the server with the same uid/pwd as the
client. Also, the user has to be an admin on the Analysis Server box. I'd
love to know if anyone has found a more direct way to remotely register an
Analysis Server.
Ken Collier
"Simon Kirk" wrote:

> Given that MS Analysis Services does not support standard SQL Server
> Authentication (thus requiring windows user accounts), is it possible for a
> remote client PC, connected to a network using a VPN, to be authenticated on
> an Analysis Server if it is not part of the host domain? If so, how can this
> be achieved?
> Is there a way of using the anonymous login account?
> If not, is this not a strange inconsistency with SQL server, and are there
> plans to address this with Yukon?
> Many Thanks
> Simon Kirk
>

Remote Connection to Analysis Services using VPN

Given that MS Analysis Services does not support standard SQL Server
Authentication (thus requiring windows user accounts), is it possible for a
remote client PC, connected to a network using a VPN, to be authenticated on
an Analysis Server if it is not part of the host domain? If so, how can this
be achieved?
Is there a way of using the anonymous login account?
If not, is this not a strange inconsistency with SQL server, and are there
plans to address this with Yukon?
Many Thanks
Simon KirkI am running into the same problem. Currently we are kludging this by
creating a "pass-thru" user on the server with the same uid/pwd as the
client. Also, the user has to be an admin on the Analysis Server box. I'd
love to know if anyone has found a more direct way to remotely register an
Analysis Server.
Ken Collier
"Simon Kirk" wrote:

> Given that MS Analysis Services does not support standard SQL Server
> Authentication (thus requiring windows user accounts), is it possible for
a
> remote client PC, connected to a network using a VPN, to be authenticated
on
> an Analysis Server if it is not part of the host domain? If so, how can th
is
> be achieved?
> Is there a way of using the anonymous login account?
> If not, is this not a strange inconsistency with SQL server, and are there
> plans to address this with Yukon?
> Many Thanks
> Simon Kirk
>