Deploying Access Data Pages

From: Vikas M H (vikasharidas_at_yahoo.com)
Date: 08/22/03 

Date: Fri, 22 Aug 2003 04:52:07 -0700

Hi,
   I am connecting to a SQL Server database with a Data
Access Page which contains a Workflow Toolbar Control.
While deploying the data access page in other machines, i
am getting the error "Data Provider could not be
initialized" and "Login failed for user (null). Reason:
Not associated with a trusted SQL Server connection" on
load of the page. The user who is trying to access is a
valid Active directory User who has also been added into
the SQL database users list under a particular role. How
do i resolve the problem? I have checked out the
solutions over the internet and did not find them helpful
enough. I tried to change the UseRemoteProvider property
to true and then received the "Internet Server Error" on
load of the page. However if i load the data access page
on the machine where the SQL Server exists, it is working
fine. Any help towards this would be greatly
appreaciated. Thanks in advance.

Thanks and Regards,
Vikas Haridas

Relevant Pages

  • Re: Binding Access Forms to a SQL Server Data source : View Or Sto
    ... Goldmine on SQL with 12 users. ... On the same SQL Server, ... It still uses BDE for data access. ... My form source is a Stored Procedure that returns ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL server vs mySQL ???
    ... The easiest way to support multiple databases is to work with a data access ... This question changes depending on which version of MySQL one has. ... * SQL Server has richer trigger support ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: data acces page connect to sql server
    ... I believe that we should all stand in unison, _BEGGING_ Microsoft to ... Using an Alias (see SQL-Server Client Network Utility or something like ... acces page to the microsoft OLE DB PROvider for sql server so that i can ... my data access page to the  sql server. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Problems with remoting and SqlCommand.ExecuteNonQuery
    ... self-signed certificates and SQL Server which may be affecting you (since ... > I´m having problems with a .net remoting application. ... > is a data access component, in other words, it performs data access tasks. ... > The problem arise when I try to execute a database task which involves the ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: SQL server question
    ... Microsoft is deprecating it even for new development, ... An Access project is an Access file that provides a direct, ... You can connect an Access project to a remote SQL Server ... a local SQL Server database, or a local installation of the SQL Server ...
    (comp.databases.ms-access)