Re: SSCESA20.DLL - Pull crashes IIS 5.0

exactly. with permission on both the database that is the source
of the articles in the publication as well as the pub itself.

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com


"Zaximg" <Zaximg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:50185C94-598A-4D31-8A3E-69C26AF6CDB0@xxxxxxxxxxxxxxxx
> Joe,
>
> I think Darren is saying to add the user in the Enterprise Manager. Is
> that
> correct Darren?
>
> "wiml" wrote:
>
>> Darren, are you saying use File Explorer on the SQL Server machine and
>> granting secuirty access to "SERVER1/IUSR_SERVER1" for that database
>> directory and/or files or adding that as a user in Enterprise Manager?
>>
>> "Darren Shaffer" wrote:
>>
>> > ok, I think this is an authentication problem - so when your
>> > RDA Pull request gets to the IIS server, the agent there must
>> > turn around and communicate with your SQL Server on a
>> > different machine. have you granted permissions for the IIS
>> > Anonymous user to access your SQL Server?
>> >
>> > So for example if IIS is running on SERVER1 and SQL
>> > Server is running on SERVER2, you would add permission
>> > on your SQL SERVER 7 database for "SERVER1/IUSR_SERVER1"
>> > as at least datareader & datawriter.
>> >
>> > see SQL CE 2.0 Books OnLine topic "RDA, database access options"
>> > for more information.
>> >
>> > --
>> > Darren Shaffer
>> > ..NET Compact Framework MVP
>> > Principal Architect
>> > Connected Innovation
>> > www.connectedinnovation.com
>> >
>> >
>> > "Zaximg" <Zaximg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> > news:ED9C015E-EE1B-4B13-B0BB-2F94BC7CAE38@xxxxxxxxxxxxxxxx
>> > > IIS is with the sscesa20.dll is running on a different server than
>> > > the
>> > > SQL7
>> > > server. Both servers are running Windows 2000. You can ignore the
>> > > mixed
>> > > server environment part.
>> > >
>> > > "Darren Shaffer" wrote:
>> > >
>> > >> what does "mixed server environment" mean? you are
>> > >> getting to the ISAPI DLL (sscesa20.dll) ok, but I suspect
>> > >> it cannot communicate with your SQL Server 7 db.
>> > >> is IIS running on the same server as SQL Server 7?
>> > >>
>> > >> --
>> > >> Darren Shaffer
>> > >> ..NET Compact Framework MVP
>> > >> Principal Architect
>> > >> Connected Innovation
>> > >> www.connectedinnovation.com
>> > >>
>> > >>
>> > >> "Zaximg" <Zaximg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> > >> news:248AEE78-34D1-42A5-9A34-9873CD44445F@xxxxxxxxxxxxxxxx
>> > >> > We're using the SSCESA20.DLL on an IIS 5.0 Server to communicate
>> > >> > to a
>> > >> > SQL
>> > >> > Server 7.0 Server (Service Pack 4) in a mixed server environment.
>> > >> > We
>> > >> > can
>> > >> > confirm that the SQL Server CE 2.0 Agent is running on the IIS 5.0
>> > >> > machine
>> > >> > by
>> > >> > typing in Internet Explorer from any machine on the network
>> > >> > http://192.168.10.5/mobileserver/sscesa20.dll and it does return
>> > >> > "SQL
>> > >> > Server
>> > >> > CE Server Agent" in the browser window. However, the .Net program
>> > >> > fails
>> > >> > when
>> > >> > executing the rda.Pull(pLocalTableName, pSqlStatementToExecute,
>> > >> > rdaConnectString, RdaTrackOption.TrackingOffWithIndexes). IIS
>> > >> > Default
>> > >> > Server
>> > >> > shuts down automatically on the IIS 5.0 server due to an error in
>> > >> > the
>> > >> > Inetinfo.EXE application. The mobileserver directory on the IIS
>> > >> > 5.0
>> > >> > machine
>> > >> > has full rights and privileges under File Explorer. Within the
>> > >> > VB.Net
>> > >> > application itself the following error condition is returned at
>> > >> > the
>> > >> > time
>> > >> > of
>> > >> > the IIS Error (this is from the Locals window while running .Net
>> > >> > in
>> > >> > Debug
>> > >> > mode):
>> > >> >
>> > >> >
>> > >> >
>> > >> > RdaTrackOption.TrackingOffWithIndexes 3 Integer
>> > >> >
>> > >> > - SqlEx {System.Data.SqlServerCe.SqlCeException}
>> > >> > System.Data.SqlServerCe.SqlCeException
>> > >> >
>> > >> > + Errors {System.Data.SqlServerCe.SqlCeErrorCollection}
>> > >> > System.Data.SqlServerCe.SqlCeErrorCollection
>> > >> >
>> > >> > HResult -2147012865 Integer
>> > >> >
>> > >> > InnerException Nothing System.Exception
>> > >> >
>> > >> > Message "SqlCeException" String
>> > >> >
>> > >> > NativeError 28037 Integer
>> > >> >
>> > >> > Source "Microsoft SQL Server 2000 Windows CE Edition"
>> > >> > String
>> > >> >
>> > >> > bReOpenDB True Boolean
>> > >> >
>> > >> > pLocalTableName "ContractUpdate"
>> > >> > String
>> > >> >
>> > >> > pSqlStatementToExecute "SELECT
>> > >> > Contract.ContractNumber, Contract.InvoiceDeliveryOption,
>> > >> > Contract.Email,
>> > >> > Contract.Fax FROM (Contract INNER JOIN Billing ON
>> > >> > Contract.ContractNumber
>> > >> > =
>> > >> > Billing.ContractNumber) WHERE Billing.Route = '3200' AND
>> > >> > (Billing.InvoiceDate
>> > >> > IN ('11/9/2005') OR Billing.Suspended <> 0)" String
>> > >> >
>> > >> > rdaConnectString "Provider=sqloledb; Data
>> > >> > Source=UNI_SQLSR; Initial Catalog=Routeman; User ID=sa; Password="
>> > >> > String
>> > >> >
>> > >> > sErrorMessage "
>> > >> >
>> > >> > Error: 80072EFF
>> > >> >
>> > >> > A request to send data to the computer running IIS has failed. For
>> > >> > more
>> > >> > information, see HRESULT. [,,,,,]
>> > >> >
>> > >> > Native Error: 28037
>> > >> >
>> > >> > Microsoft SQL Server 2000 Windows CE Edition" String
>> > >> >
>> > >> >
>> > >> >
>> > >> >
>> > >> >
>> > >> >
>> > >> >
>> > >> > Let me know if there is any additional information you need.
>> > >> >
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >


.

Relevant Pages

  • Re: SQL Server execute permission denied on object
    ... This is a permission problem: the Login account or the required permissions ... have not been set up properly on the remote database. ... Recently the SQL part was moved to a new server. ... SQL Server execute permission denied on object ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Export to Excel
    ... maybe your dts-script has no permission to the file/directory ... server through Enterprise Manager. ... package from SQL server. ...
    (microsoft.public.sqlserver.dts)
  • Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
    ... try a colon after the server IP before the port number. ... > I checked that the Collation of 192.x.x.x is ... > perhaps devices support only English/Default Collation for SQL Server. ... >> ..NET Compact Framework MVP ...
    (microsoft.public.sqlserver.ce)
  • Re: how to: non-admin user sending email from a SP ?
    ... Check out using XPSMTP for sending emails from inside of SQL Server. ... All you would have to do then is grant the appropriate people permission ... > states that "Only members of the sysadmin fixed server role can run ...
    (microsoft.public.sqlserver.programming)
  • Re: Recommended Procedure for Importing From Access Across LAN
    ... For this the SQL server Service startup account should be ... >a domain account with read only permission in the folder where the file ...
    (microsoft.public.sqlserver.programming)
Loading