Replication Problems 32bit IIS 64 bit SQL 2005??

Hello, I have a several PPC app that use replication on seperate IIS
and SQL (2000) boxes with great success. We recently set up our first
2005 SQL install. It happens to be on a x64 machine. I am trying to
use the same IIS set up and just have it replicate with the same
database that has been migrated from 2000 to 2005.

>From the pocket IE browser I get the message "SQL Server Mobile Server
Agent 3.0" so all is good there. At the point where the replication
object in my app tries to synch I get the error message:
"An instance of the SQL Server Reconciler error object cannot be
created. Try reinstalling the replication components."
That is the only error. I have done a little digging and see mention
of repication not working between a 32 bit IIS box and a 64 bit SQL
2005 box. However the messages were from early 2006.
The snapshot share all seem to have the correct rights. I can creat my
publication with the correct articles. And as stated the hand held
gets the success message to PIE.
Can anyone shed a little light on this? Do I need a 32 bit version of
SQL 2005? Is there any other sort of tools I need to install on the
IIS or SQL side?
Any and all help greatly appreciated.
On Feb 21, 11:41 am, rplac...@.yahoo.com wrote:
> Hello, I have a several PPC app that use replication on seperate IIS
> and SQL (2000) boxes with great success. We recently set up our first
> 2005 SQL install. It happens to be on a x64 machine. I am trying to
> use the same IIS set up and just have it replicate with the same
> database that has been migrated from 2000 to 2005.
>
> Agent 3.0" so all is good there. At the point where the replication
> object in my app tries to synch I get the error message:
> "An instance of the SQL Server Reconciler error object cannot be
> created. Try reinstalling the replication components."
> That is the only error. I have done a little digging and see mention
> of repication not working between a 32 bit IIS box and a 64 bit SQL
> 2005 box. However the messages were from early 2006.
> The snapshot share all seem to have the correct rights. I can creat my
> publication with the correct articles. And as stated the hand held
> gets the success message to PIE.
> Can anyone shed a little light on this? Do I need a 32 bit version of
> SQL 2005? Is there any other sort of tools I need to install on the
> IIS or SQL side?
> Any and all help greatly appreciated.
No ideas at all?
Should I try posting to a different group?
Please help.
|||Please have a look at this thread form MS support and see if it helps:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=202038&SiteID=1
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||On Feb 22, 9:07 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Please have a look at this thread form MS support and see if it helps:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=202038&SiteID=1
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Thanks for the reply. That is not my set up the one referenced in the
article is SQL 2000...but I have my systems guys adding the client
tools as the article suggests.
Can anyone confirm or refute that if IIS is running on at 32 bit
processor box and SQL 2005 is running on a 64 bit processor box that
replication will NOT work? I saw some post mentioning to try WOW and
SQL 2005 in 32 bit install. I'd like to get some MS confirmation that
SQL 2005 on a x64 box is not compatible first.
Thanks a ton!
|||On Feb 22, 1:47 pm, rplac...@.yahoo.com wrote:
> On Feb 22, 9:07 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
>
> Thanks for the reply. That is not my set up the one referenced in the
> article is SQL 2000...but I have my systems guys adding the client
> tools as the article suggests.
> Can anyone confirm or refute that if IIS is running on at 32 bit
> processor box and SQL 2005 is running on a 64 bit processor box that
> replication will NOT work? I saw some post mentioning to try WOW and
> SQL 2005 in 32 bit install. I'd like to get some MS confirmation that
> SQL 2005 on a x64 box is not compatible first.
> Thanks a ton!
I'm at the end of my rope here. But the powers that be do not want to
try a 32 bit version of SQL 2005 on a 64 bit box unless they know that
is the problem. I do not have the option of running 2005 on a 32 bit
box.
If anyone knows this answer or can point me in the right direction
please help. I just want to know if a 64 bit install of SQL 2005 will
not work with replication to a PPC device when IIS is on a seperate
machine running 32 bit.
Thanks!