| Groups | Blog | Home |
sql server replication : replication error
I'm tryng replying a SQL Server 2000 database vs SQL Server Mobile 2005 database I belive that I need is: 1) SQL Server 2000 (Publisher and distributer) with the publication created (OK) 2) IIS with web sincronization configured (OK). I have Configured Virtual Directory for the publication using "Configure Web Sync" wizard. I Have created the virtual directory an i have the sqlcesa30.dll file in the selected path y and the web aplication in IIS with the alias seleccionated too 3) SQL Server Mobile. In my PDA i have installed SQL Server Mobile 2005 and I have a database where i want to create the subscription In the server where I have the sql server 2000 and iis i have installed SQL Server Management Studio and i have a connection to my pda's dadabase (.sdf) and i'am using the wizard to create a subscription to the sql server 2000 publication When i select "How will the subscriber connect to the web server?" i choose "anonymously" (In the web site i have enable anonymouys access") When i select "How will the subscriber connect to sql server?" i choose "sql server authentication" and select a user account with logon sesion permitted in sql server 2000 In the following step the wizard gives me an connection error: "No se pudo establecer conexión con el servidor SQL Server con la información proporcionada. El servidor no existe, se ha denegado el acceso porque el usuario de IIS no es válido en el servidor SQL Server o la contraseña es incorrecta. HRESULT 0x80004005 (29060)" Translated: user invalid in IIS or wrong password... I have added "IUSR_Server" in logon sesions in sql server with the same result. Then i have changed the connection method to web server with a valid user account and now the error says: "Error al inicializar el Reconciliador de SQL Server. Vuelva a intentarlo. HRESULT 0x80045901 (29045) El proceso de mezcla no pudo inicializar el archivo de mensajes del suscriptor 'C:\Archivos de programa\Microsoft SQL Server 2005 Mobile Edition\server\Replicaciones\30.87E7785D3BB8_C3B56239-A550-F8EC-EFBD-DC7E5C7264B9.IN:C:\Archivos de programa\Microsoft SQL Server 2005 Mobile Edition\server\Replicaciones\30.87E7785D3BB8_C3B56239-A550-F8EC-EFBD-DC7E5C7264B9.OUT'. HRESULT 0x80045901 (0)" translated: Error initializing the reconcilier. the mix process can't initialize the messages file of subscriber 'c.... In the virtual directory`s sqlcesa30.log appears: 2006/07/03 13:25:47 Hr=80004005 ERR:OpenDB failed getting pub version 28627 2006/07/03 16:13:03 Thread=1090 RSCB=2 Command=SCHK Hr=80045901 El proceso de mezcla no pudo inicializar el archivo de mensajes del suscriptor 'C:\Archivos de programa\Microsoft SQL Server 2005 Mobile Edition\server\Replicaciones\30.29F9F099EC77_C7B23E20-1CE3-44DC-B5F0-26CDC4FFE29A.IN:C:\Archivos de programa\Microsoft SQL Server 2005 Mobile Edition\server\Replicaciones\30.29F9F099EC77_C7B23E20-1CE3-44DC-B5F0-26CDC4FFE29A.OUT'. -2147198719 Help please and sorry my poor english
Did you configure a snapshot share and give the IUSER_Machine name rights to
read and list files and folders? Make sure that you pointed to this snapshot share when you configured your virutal directory. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Kintela" <rquintela@fulcrum.es> wrote in message news:ehFD0GAoGHA.3348@TK2MSFTNGP03.phx.gbl... > Hi. > > I'm tryng replying a SQL Server 2000 database vs SQL Server Mobile 2005 > database > > I belive that I need is: > > 1) SQL Server 2000 (Publisher and distributer) with the publication > created (OK) > > 2) IIS with web sincronization configured (OK). > > I have Configured Virtual Directory for the publication using "Configure > Web Sync" wizard. > I Have created the virtual directory an i have the sqlcesa30.dll file in > the selected path y and the web aplication in IIS with the alias > seleccionated too > > 3) SQL Server Mobile. In my PDA i have installed SQL Server Mobile 2005 > and I have a database where i want to create the subscription > > In the server where I have the sql server 2000 and iis i have installed > SQL Server Management Studio and i have a connection to my > pda's dadabase (.sdf) and i'am using the wizard to create a subscription > to the sql server 2000 publication > > When i select "How will the subscriber connect to the web server?" i > choose "anonymously" > (In the web site i have enable anonymouys access") > > When i select "How will the subscriber connect to sql server?" i choose > "sql server authentication" > and select a user account with logon sesion permitted in sql server 2000 > > In the following step the wizard gives me an connection error: > > "No se pudo establecer conexión con el servidor SQL Server con la > información proporcionada. > El servidor no existe, se ha denegado el acceso porque el usuario de IIS > no es válido en el servidor SQL Server > o la contraseña es incorrecta. > HRESULT 0x80004005 (29060)" > > Translated: user invalid in IIS or wrong password... > > I have added "IUSR_Server" in logon sesions in sql server with the same > result. > > Then i have changed the connection method to web server with a valid user > account and now the error says: > > "Error al inicializar el Reconciliador de SQL Server. Vuelva a intentarlo. > HRESULT 0x80045901 (29045) > > El proceso de mezcla no pudo inicializar el archivo de mensajes del > suscriptor 'C:\Archivos de programa\Microsoft SQL Server 2005 Mobile > Edition\server\Replicaciones\30.87E7785D3BB8_C3B56239-A550-F8EC-EFBD-DC7E5C7264B9.IN:C:\Archivos > de programa\Microsoft SQL Server 2005 Mobile > Edition\server\Replicaciones\30.87E7785D3BB8_C3B56239-A550-F8EC-EFBD-DC7E5C7264B9.OUT'. > HRESULT 0x80045901 (0)" > > translated: Error initializing the reconcilier. the mix process can't > initialize the messages file of subscriber 'c.... > > In the virtual directory`s sqlcesa30.log appears: > > 2006/07/03 13:25:47 Hr=80004005 ERR:OpenDB failed getting pub version > 28627 > 2006/07/03 16:13:03 Thread=1090 RSCB=2 Command=SCHK Hr=80045901 El proceso > de mezcla no pudo inicializar el archivo de mensajes del suscriptor > 'C:\Archivos de programa\Microsoft SQL Server 2005 Mobile > Edition\server\Replicaciones\30.29F9F099EC77_C7B23E20-1CE3-44DC-B5F0-26CDC4FFE29A.IN:C:\Archivos > de programa\Microsoft SQL Server 2005 Mobile > Edition\server\Replicaciones\30.29F9F099EC77_C7B23E20-1CE3-44DC-B5F0-26CDC4FFE29A.OUT'. > -2147198719 > > Help please and sorry my poor english > > >
Hi.
I have started again in other machine with sql server 2000 and IIS named "SERVIDOR" In the snapshot share folder, the IUSR_SERVIDOR has rights to read and list folder and subfolder files and the virtual directory points to this snapshot share folder. I have created the virtual directory and I have configured the clients access anonymously. Then I try to create the subscription with SQL Server 2005 Management Studio Wizard, in the url to sql server mobile 2005 virtual directory on the web server i give http://servidor/alias/sqlcesa30.dll and the subscriber connects anonymously to web server and with windows authentication to sql server (The IUSR_SERVIDOR account has rights to login) but now the last step gives me: "Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect. HRESULT 0x80004005 (29061)" I swear to god that in the login folder in SQL Server connection is the IUSR_SERVIDOR Account- I have tried with SQL Server Authentication using the Domain' Administrator account and gives me the same error and this account is in login folder too. I don´t understand Thanks for all "Hilary Cotter" <hilary.cotter@gmail.com> escribió en el mensaje news:%2383gA5CoGHA.3836@TK2MSFTNGP04.phx.gbl... [quoted text, click to view] > Did you configure a snapshot share and give the IUSER_Machine name rights Edition\server\Replicaciones\30.87E7785D3BB8_C3B56239-A550-F8EC-EFBD-DC7E5C7to > read and list files and folders? Make sure that you pointed to this snapshot > share when you configured your virutal directory. > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Kintela" <rquintela@fulcrum.es> wrote in message > news:ehFD0GAoGHA.3348@TK2MSFTNGP03.phx.gbl... > > Hi. > > > > I'm tryng replying a SQL Server 2000 database vs SQL Server Mobile 2005 > > database > > > > I belive that I need is: > > > > 1) SQL Server 2000 (Publisher and distributer) with the publication > > created (OK) > > > > 2) IIS with web sincronization configured (OK). > > > > I have Configured Virtual Directory for the publication using "Configure > > Web Sync" wizard. > > I Have created the virtual directory an i have the sqlcesa30.dll file in > > the selected path y and the web aplication in IIS with the alias > > seleccionated too > > > > 3) SQL Server Mobile. In my PDA i have installed SQL Server Mobile 2005 > > and I have a database where i want to create the subscription > > > > In the server where I have the sql server 2000 and iis i have installed > > SQL Server Management Studio and i have a connection to my > > pda's dadabase (.sdf) and i'am using the wizard to create a subscription > > to the sql server 2000 publication > > > > When i select "How will the subscriber connect to the web server?" i > > choose "anonymously" > > (In the web site i have enable anonymouys access") > > > > When i select "How will the subscriber connect to sql server?" i choose > > "sql server authentication" > > and select a user account with logon sesion permitted in sql server 2000 > > > > In the following step the wizard gives me an connection error: > > > > "No se pudo establecer conexión con el servidor SQL Server con la > > información proporcionada. > > El servidor no existe, se ha denegado el acceso porque el usuario de IIS > > no es válido en el servidor SQL Server > > o la contraseña es incorrecta. > > HRESULT 0x80004005 (29060)" > > > > Translated: user invalid in IIS or wrong password... > > > > I have added "IUSR_Server" in logon sesions in sql server with the same > > result. > > > > Then i have changed the connection method to web server with a valid user > > account and now the error says: > > > > "Error al inicializar el Reconciliador de SQL Server. Vuelva a intentarlo. > > HRESULT 0x80045901 (29045) > > > > El proceso de mezcla no pudo inicializar el archivo de mensajes del > > suscriptor 'C:\Archivos de programa\Microsoft SQL Server 2005 Mobile > > 264B9.IN:C:\Archivos [quoted text, click to view] > > de programa\Microsoft SQL Server 2005 Mobile Edition\server\Replicaciones\30.87E7785D3BB8_C3B56239-A550-F8EC-EFBD-DC7E5C7> > 264B9.OUT'. [quoted text, click to view] > > HRESULT 0x80045901 (0)" Edition\server\Replicaciones\30.29F9F099EC77_C7B23E20-1CE3-44DC-B5F0-26CDC4F> > > > translated: Error initializing the reconcilier. the mix process can't > > initialize the messages file of subscriber 'c.... > > > > In the virtual directory`s sqlcesa30.log appears: > > > > 2006/07/03 13:25:47 Hr=80004005 ERR:OpenDB failed getting pub version > > 28627 > > 2006/07/03 16:13:03 Thread=1090 RSCB=2 Command=SCHK Hr=80045901 El proceso > > de mezcla no pudo inicializar el archivo de mensajes del suscriptor > > 'C:\Archivos de programa\Microsoft SQL Server 2005 Mobile > > FE29A.IN:C:\Archivos [quoted text, click to view] > > de programa\Microsoft SQL Server 2005 Mobile Edition\server\Replicaciones\30.29F9F099EC77_C7B23E20-1CE3-44DC-B5F0-26CDC4F> > FE29A.OUT'. [quoted text, click to view] > > -2147198719 > > > > Help please and sorry my poor english > > > > > > > >
Hi
I run into the same problem few minutes ago. In my case, the problem was that I made a typo in the database name, so the PublisherDatabase referred to a non-existing database.. I corrected the typo and now it works. Janos
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
October 2008
| home · blog · groups | Questions? Comments? Contact the dn |