is it possible to process the cube using vb.net/c# which exists in the remote server?

Hi

can we process the cube exists in the remote system, using vb.net/c#

i am able to process in the same system, where analysis service available.

i couln't process this from the client system.

is there any soluctions?

You can use either the AMO or ADOMD libraries to send processing commands to a remote server.

The AMO library is easier to work with for admin tasks, but you would have to redeploy the dll's. Where as any client that has to query the cubes will already need have ADOMD installed.

The following send an XMLA processing command using ADOMD, all you need to do is to create a console application, add a reference to Microsoft.AnalysisServices.AdomdClient and paste in the following:

Code Snippet

Sub Main()

Dim serverName As String = "Server1"

Dim databaseName As String = "Adventure Works DW"

Dim databaseID As String = databaseName

Dim cubeID As String = "Adventure Works"

Dim cn As New AdomdConnection("Provider=MSOLAP;Data Source=" & serverName & ";Initial Catalog=" & databaseName)

Console.WriteLine("Opening Connection...")

cn.Open()

Dim cmd As AdomdCommand

cmd = cn.CreateCommand()

cmd.CommandType = CommandType.Text

cmd.CommandText = "<Batch xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine""><Parallel><Process> <Object>" & _

"<DatabaseID>" & DatabaseID & "</DatabaseID>" & _

"<CubeID>" & cubeID & "</CubeID> " & _

"</Object><Type>ProcessFull</Type><WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> </Parallel> </Batch>"

Try

Console.WriteLine("Executing Command...")

cmd.ExecuteNonQuery()

Console.WriteLine("Command Complete")

Catch ex As Exception

Console.WriteLine(" --== ERROR ==--")

Console.WriteLine(ex.Message)

Console.WriteLine()

Finally

cn.Close()

Console.WriteLine("Finished")

End Try

End Sub

|||

Hi Darren

I tried your solution using AdoMd 8.0 on AS 2005,

but it seems that no data are refreshed,

neverthless the command text is executed without any error

Do I miss any other instruction (i.e: 'comitt transaction', .)?

Thanks

|||

I don't think ADOMD 8.0 has the execute method you need 9.0 to work with AS2005.

I just double checked and if your account has permission to process the server, database and cube properties are set correctly it should work. Try running a profiler session on the server and see if there are any errors being thrown at that end.

Is it possible to logon to SQL Server as a different Windows user?

I'd like to stay logged on to windows as myself, a network user, but
logon to a remote SQL Server on the network as a different network
windows user who has an account on SQL Server with more privileges. Is
this possible? Say I'm logged on as network user mynetwork\myself and
I want to keep that open but logon to SQL Server as network user
mynetwork\otheruser.fumanchu wrote:
> I'd like to stay logged on to windows as myself, a network user, but
> logon to a remote SQL Server on the network as a different network
> windows user who has an account on SQL Server with more privileges. Is
> this possible? Say I'm logged on as network user mynetwork\myself and
> I want to keep that open but logon to SQL Server as network user
> mynetwork\otheruser.
If you have the Run As service running on your Windows 2000/XP client,
you can run an Explorer session as another Windows user and run the
application from that new instance on Explorer. To use teh Run As option
hold down the CTRL key and right-click My Computer on the Desktop.
--
David Gugick
Imceda Software
www.imceda.com

Is it possible to logon to SQL Server as a different Windows user?

I'd like to stay logged on to windows as myself, a network user, but
logon to a remote SQL Server on the network as a different network
windows user who has an account on SQL Server with more privileges. Is
this possible? Say I'm logged on as network user mynetwork\myself and
I want to keep that open but logon to SQL Server as network user
mynetwork\otheruser.
fumanchu wrote:
> I'd like to stay logged on to windows as myself, a network user, but
> logon to a remote SQL Server on the network as a different network
> windows user who has an account on SQL Server with more privileges. Is
> this possible? Say I'm logged on as network user mynetwork\myself and
> I want to keep that open but logon to SQL Server as network user
> mynetwork\otheruser.
If you have the Run As service running on your Windows 2000/XP client,
you can run an Explorer session as another Windows user and run the
application from that new instance on Explorer. To use teh Run As option
hold down the CTRL key and right-click My Computer on the Desktop.
David Gugick
Imceda Software
www.imceda.com

Is it possible to logon to SQL Server as a different Windows user?

I'd like to stay logged on to windows as myself, a network user, but
logon to a remote SQL Server on the network as a different network
windows user who has an account on SQL Server with more privileges. Is
this possible? Say I'm logged on as network user mynetwork\myself and
I want to keep that open but logon to SQL Server as network user
mynetwork\otheruser.fumanchu wrote:
> I'd like to stay logged on to windows as myself, a network user, but
> logon to a remote SQL Server on the network as a different network
> windows user who has an account on SQL Server with more privileges. Is
> this possible? Say I'm logged on as network user mynetwork\myself and
> I want to keep that open but logon to SQL Server as network user
> mynetwork\otheruser.
If you have the Run As service running on your Windows 2000/XP client,
you can run an Explorer session as another Windows user and run the
application from that new instance on Explorer. To use teh Run As option
hold down the CTRL key and right-click My Computer on the Desktop.
David Gugick
Imceda Software
www.imceda.com

Is Enterprize manager secure for remote admin?

Hello all,

An ASP.NET website hosting service allows the use of Enterprize Manager to manage the backend database of a hosted asp.net website. This is not done across a VPN and I don't think it could be done on SSL so the question is : How Secure is that? would this be ok for learning but not Ecommerce? Or is it an encrypted session and I paranoid?

-Thanks
HeywadeI wouldn't be overly enthusiastic about storing sensitive e-commerce info in there, no. I think you can rig it to communicate with IPSec, but it depends what the host supports - ask them.

is ASP the only way for SQL remote access via internet

Hi.
I would like to access my database outside of my company. I read many
documents but they are all pertaining to accessing the database via
ASP or some form of web application. Is there no single windows or
linux application tht runs natively to access a remote SQL data base?
Any advise is appreciated. Thanks!!The only requirement for an application to access a remote SQL Server is
network connectivity. There are additional considerations with remote
client-server access, such as security, deployment complexity and
performance. These are reasons why a web-based architecture is most often
chosen for remote data access.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"kackson" <kackson@.yahoo.com> wrote in message
news:90250227.0407050549.4b832321@.posting.google.c om...
> Hi.
> I would like to access my database outside of my company. I read many
> documents but they are all pertaining to accessing the database via
> ASP or some form of web application. Is there no single windows or
> linux application tht runs natively to access a remote SQL data base?
> Any advise is appreciated. Thanks!!|||I suppose you could set up a VPN to your server and use an access ADP
project on the local machine to connect

"kackson" <kackson@.yahoo.com> wrote in message
news:90250227.0407050549.4b832321@.posting.google.c om...
> Hi.
> I would like to access my database outside of my company. I read many
> documents but they are all pertaining to accessing the database via
> ASP or some form of web application. Is there no single windows or
> linux application tht runs natively to access a remote SQL data base?
> Any advise is appreciated. Thanks!!|||Hi.
What exactly is access ADP? If I setup a VPN, is this "access ADP" the
only best secure method? Are there alternatives that are secure and
proven to be the sort of industry standard method (the way that most
people do) where native applications (not via net applications) access
databases over internet? Any advise is really much appreciated.

"aaj" <a.b@.c.com> wrote in message news:<40ea74dd$0$9974$afc38c87@.news.easynet.co.uk>...
> I suppose you could set up a VPN to your server and use an access ADP
> project on the local machine to connect
>
> "kackson" <kackson@.yahoo.com> wrote in message
> news:90250227.0407050549.4b832321@.posting.google.c om...
> > Hi.
> > I would like to access my database outside of my company. I read many
> > documents but they are all pertaining to accessing the database via
> > ASP or some form of web application. Is there no single windows or
> > linux application tht runs natively to access a remote SQL data base?
> > Any advise is appreciated. Thanks!!|||> What exactly is access ADP?

An ADP is a Microsoft Access project file that uses SQL Server as the
underlying database engine.

> If I setup a VPN, is this "access ADP" the only best secure method?

An ADP is basically just a client application. It is the VPN connection
that provides the secure network connection needed for a client-server
application to use a remote database over the public internet.

Although you can run the application locally and access the remote database
over a VPN connection, another common method is to establish a remote
desktop connection over a VPN to an application server and run the app
there. Like a web app, this can reduce network overhead and facilitate
deployment.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"kackson" <kackson@.yahoo.com> wrote in message
news:90250227.0407080205.31978dc3@.posting.google.c om...
> Hi.
> What exactly is access ADP? If I setup a VPN, is this "access ADP" the
> only best secure method? Are there alternatives that are secure and
> proven to be the sort of industry standard method (the way that most
> people do) where native applications (not via net applications) access
> databases over internet? Any advise is really much appreciated.
>
> "aaj" <a.b@.c.com> wrote in message
news:<40ea74dd$0$9974$afc38c87@.news.easynet.co.uk>...
> > I suppose you could set up a VPN to your server and use an access ADP
> > project on the local machine to connect
> > "kackson" <kackson@.yahoo.com> wrote in message
> > news:90250227.0407050549.4b832321@.posting.google.c om...
> > > Hi.
> > > I would like to access my database outside of my company. I read many
> > > documents but they are all pertaining to accessing the database via
> > > ASP or some form of web application. Is there no single windows or
> > > linux application tht runs natively to access a remote SQL data base?
> > > Any advise is appreciated. Thanks!!|||As Dan says, an ADP is the Microsoft Access (I think Access 2000 onwards)
front end i.e. the forms etc, but it doesn't use the jet backend, instead it
connects to the SQL Server.

The VPN provides a local IP address on the remote machine that the ADP can
connect to and points it in the direction of the database. I imagine (but
I'm not certain) that any other from end could make a similar connection
e.g. enterprise manager

I suppose bot the VPN and Access are industry standard, but I'm not sure
this type of configuration would be. The only reason we did it like this was
just to see if we could.

I imagine (and I think is what Dan alludes to further down) that using
something like Citrix or terminal server to connect to whatever you use to
access your SQL Server may be a more sensible option.

hope this helps

Andy

"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:jraHc.8856$R36.2433@.newsread2.news.pas.earthl ink.net...
> > What exactly is access ADP?
> An ADP is a Microsoft Access project file that uses SQL Server as the
> underlying database engine.
> > If I setup a VPN, is this "access ADP" the only best secure method?
> An ADP is basically just a client application. It is the VPN connection
> that provides the secure network connection needed for a client-server
> application to use a remote database over the public internet.
> Although you can run the application locally and access the remote
database
> over a VPN connection, another common method is to establish a remote
> desktop connection over a VPN to an application server and run the app
> there. Like a web app, this can reduce network overhead and facilitate
> deployment.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "kackson" <kackson@.yahoo.com> wrote in message
> news:90250227.0407080205.31978dc3@.posting.google.c om...
> > Hi.
> > What exactly is access ADP? If I setup a VPN, is this "access ADP" the
> > only best secure method? Are there alternatives that are secure and
> > proven to be the sort of industry standard method (the way that most
> > people do) where native applications (not via net applications) access
> > databases over internet? Any advise is really much appreciated.
> > "aaj" <a.b@.c.com> wrote in message
> news:<40ea74dd$0$9974$afc38c87@.news.easynet.co.uk>...
> > > I suppose you could set up a VPN to your server and use an access ADP
> > > project on the local machine to connect
> > > > > "kackson" <kackson@.yahoo.com> wrote in message
> > > news:90250227.0407050549.4b832321@.posting.google.c om...
> > > > Hi.
> > > > I would like to access my database outside of my company. I read
many
> > > > documents but they are all pertaining to accessing the database via
> > > > ASP or some form of web application. Is there no single windows or
> > > > linux application tht runs natively to access a remote SQL data
base?
> > > > Any advise is appreciated. Thanks!!