SQL Server Developer Center > SQL Server Forums > SQL Server Replication > Setup replication to sql compact on windows7 IIS7 500 server error
Ask a questionAsk a question
 

AnswerSetup replication to sql compact on windows7 IIS7 500 server error

  • Tuesday, November 03, 2009 9:05 PMforwheeler4 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I set this up on a XP dev pc a couple of weeks ago and it works fine. I am trying to set this up on my windows 7 x64 pc.
    I am using sql2005 sp3 and sql compact 3.5 sp1. 
    I setup the replication folder under C:\inetpub\wwwroot\sqlpublisher using a transactional publication and created a sql user and an IIS user.
    I shared the sqlpublisher directory.
    When I run the Web Synchronization Wizard, everthing seems to go fine. 
    The IIS virtual directory is created and is setup as an application in IIS. This will not work because there is no web.config file there so I remove the application and leave the virtual directory.

    I get a 500.0 internal server error when I try to access the sqlcesa35.dll using my browser. I tried creating another application pool and moving the default web site there and gave the pool the network service identity. I then added the network service to the ACLs in the directory. I still get the same error.

    What does the sqlcesa35.dll do? Does it try to access something else that it doesn't have permission to?

Answers

All Replies