|
|
You're in the
sql server replication
group:Help w/Merge Repl using Port 8080 to PDA subscriber
sql server replication:
Using SQL 2005 merge replication and we are currently replicating data between the server and multiple (100's) of subscribers that use a PDA (running SQL Mobile). I have to now change the replication to support a non-standard port, Port 8080, in this scenario. And try as I have...I cannot figure out a two things: (1) How to get the replication DLL to be visible or work even...when I browse to something like, http://ServerName.Domain.com:8080/ReplFolder/sqlcesa30.dll. This only yields a Page Not Found error. (2) How I can set the attributes on the client to get to this specific port. Is it as simple as just adding the port to the connection string? If so..then maybe my issue with number one (above) is the problem. Thanks for any help!
Thanks for the speedy reply.
1. Yes the web server responds to: http://serverName.Domain.com:8080 2. No, I get a page not found error when I browse to: http://serverName.Domain.com:8080/ReplFolder/sqlcesa30.dll 3. I can remote desktop to that server and browse to: http://localhost/ReplFolder/sqlcesa30.dll and I get the page, "SQL Server Mobile Server Agent 3.0". 4. I made sure that the virtual folder is configured...I initially set it up using the SQL Mobile server tools wizard thing....and my initial snapshots are created fine in that folder too. would there be anything else for me to check? thanks, - will [quoted text, click to view] "Hilary Cotter" wrote:
> 1) can you see if your web server is responsive on port 8080, do something > like > > http://ServerName.Domain.com:8080 > > If so, then try this > > http://ServerName/ReplFolder/sscesa30.dll > > You should see a message saying SQL CE Agent Started or something like > that - it sounds like you are not getting this far. > > Also make sure your virtual directory is configured. > > Yes you clients need to be configured to address the port/ > > -- > 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 > > > > "dw" <dw@discussions.microsoft.com> wrote in message > news:C4DF1009-F39E-40ED-8D0E-6EBFCDDAE14E@microsoft.com... > > Hello... > > > > Using SQL 2005 merge replication and we are currently replicating data > > between the server and multiple (100's) of subscribers that use a PDA > > (running SQL Mobile). > > > > I have to now change the replication to support a non-standard port, Port > > 8080, in this scenario. And try as I have...I cannot figure out a two > > things: (1) How to get the replication DLL to be visible or work > > even...when > > I browse to something like, > > http://ServerName.Domain.com:8080/ReplFolder/sqlcesa30.dll. This only > > yields > > a Page Not Found error. (2) How I can set the attributes on the client to > > get to this specific port. Is it as simple as just adding the port to the > > connection string? If so..then maybe my issue with number one (above) is > > the > > problem. > > > > Thanks for any help! > > - will > >
1) can you see if your web server is responsive on port 8080, do something
like http://ServerName.Domain.com:8080 If so, then try this http://ServerName/ReplFolder/sscesa30.dll You should see a message saying SQL CE Agent Started or something like that - it sounds like you are not getting this far. Also make sure your virtual directory is configured. Yes you clients need to be configured to address the port/ -- 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] "dw" <dw@discussions.microsoft.com> wrote in message news:C4DF1009-F39E-40ED-8D0E-6EBFCDDAE14E@microsoft.com... > Hello... > > Using SQL 2005 merge replication and we are currently replicating data > between the server and multiple (100's) of subscribers that use a PDA > (running SQL Mobile). > > I have to now change the replication to support a non-standard port, Port > 8080, in this scenario. And try as I have...I cannot figure out a two > things: (1) How to get the replication DLL to be visible or work > even...when > I browse to something like, > http://ServerName.Domain.com:8080/ReplFolder/sqlcesa30.dll. This only > yields > a Page Not Found error. (2) How I can set the attributes on the client to > get to this specific port. Is it as simple as just adding the port to the > connection string? If so..then maybe my issue with number one (above) is > the > problem. > > Thanks for any help! > - will
It looks like your virtual directory is not configured correctly, or the
isapi dll is not there. Browse it in the IIS mmc and make sure it is configured correctly. -- 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] "dw" <dw@discussions.microsoft.com> wrote in message news:32E17967-3706-43F7-8E84-1357A1F210B0@microsoft.com... > Thanks for the speedy reply. > > 1. Yes the web server responds to: > http://serverName.Domain.com:8080 > > 2. No, I get a page not found error when I browse to: > http://serverName.Domain.com:8080/ReplFolder/sqlcesa30.dll > > 3. I can remote desktop to that server and browse to: > http://localhost/ReplFolder/sqlcesa30.dll > and I get the page, "SQL Server Mobile Server Agent 3.0". > > 4. I made sure that the virtual folder is configured...I initially set it > up using the SQL Mobile server tools wizard thing....and my initial > snapshots > are created fine in that folder too. > > would there be anything else for me to check? > > thanks, > - will > > "Hilary Cotter" wrote: > >> 1) can you see if your web server is responsive on port 8080, do >> something >> like >> >> http://ServerName.Domain.com:8080 >> >> If so, then try this >> >> http://ServerName/ReplFolder/sscesa30.dll >> >> You should see a message saying SQL CE Agent Started or something like >> that - it sounds like you are not getting this far. >> >> Also make sure your virtual directory is configured. >> >> Yes you clients need to be configured to address the port/ >> >> -- >> 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 >> >> >> >> "dw" <dw@discussions.microsoft.com> wrote in message >> news:C4DF1009-F39E-40ED-8D0E-6EBFCDDAE14E@microsoft.com... >> > Hello... >> > >> > Using SQL 2005 merge replication and we are currently replicating data >> > between the server and multiple (100's) of subscribers that use a PDA >> > (running SQL Mobile). >> > >> > I have to now change the replication to support a non-standard port, >> > Port >> > 8080, in this scenario. And try as I have...I cannot figure out a two >> > things: (1) How to get the replication DLL to be visible or work >> > even...when >> > I browse to something like, >> > http://ServerName.Domain.com:8080/ReplFolder/sqlcesa30.dll. This only >> > yields >> > a Page Not Found error. (2) How I can set the attributes on the client >> > to >> > get to this specific port. Is it as simple as just adding the port to >> > the >> > connection string? If so..then maybe my issue with number one (above) >> > is >> > the >> > problem. >> > >> > Thanks for any help! >> > - will >> >> >>
As it turned out...the virtual folder was set up in the wrong web folder.
Once I moved the sql ce replication folder beneath the web folder that is using port 8080, it all worked well. - will [quoted text, click to view] "Hilary Cotter" wrote:
> It looks like your virtual directory is not configured correctly, or the > isapi dll is not there. Browse it in the IIS mmc and make sure it is > configured correctly. > > -- > 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 > > > > "dw" <dw@discussions.microsoft.com> wrote in message > news:32E17967-3706-43F7-8E84-1357A1F210B0@microsoft.com... > > Thanks for the speedy reply. > > > > 1. Yes the web server responds to: > > http://serverName.Domain.com:8080 > > > > 2. No, I get a page not found error when I browse to: > > http://serverName.Domain.com:8080/ReplFolder/sqlcesa30.dll > > > > 3. I can remote desktop to that server and browse to: > > http://localhost/ReplFolder/sqlcesa30.dll > > and I get the page, "SQL Server Mobile Server Agent 3.0". > > > > 4. I made sure that the virtual folder is configured...I initially set it > > up using the SQL Mobile server tools wizard thing....and my initial > > snapshots > > are created fine in that folder too. > > > > would there be anything else for me to check? > > > > thanks, > > - will > > > > "Hilary Cotter" wrote: > > > >> 1) can you see if your web server is responsive on port 8080, do > >> something > >> like > >> > >> http://ServerName.Domain.com:8080 > >> > >> If so, then try this > >> > >> http://ServerName/ReplFolder/sscesa30.dll > >> > >> You should see a message saying SQL CE Agent Started or something like > >> that - it sounds like you are not getting this far. > >> > >> Also make sure your virtual directory is configured. > >> > >> Yes you clients need to be configured to address the port/ > >> > >> -- > >> 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 > >> > >> > >> > >> "dw" <dw@discussions.microsoft.com> wrote in message > >> news:C4DF1009-F39E-40ED-8D0E-6EBFCDDAE14E@microsoft.com... > >> > Hello... > >> > > >> > Using SQL 2005 merge replication and we are currently replicating data > >> > between the server and multiple (100's) of subscribers that use a PDA > >> > (running SQL Mobile). > >> > > >> > I have to now change the replication to support a non-standard port, > >> > Port > >> > 8080, in this scenario. And try as I have...I cannot figure out a two > >> > things: (1) How to get the replication DLL to be visible or work > >> > even...when > >> > I browse to something like, > >> > http://ServerName.Domain.com:8080/ReplFolder/sqlcesa30.dll. This only > >> > yields > >> > a Page Not Found error. (2) How I can set the attributes on the client > >> > to > >> > get to this specific port. Is it as simple as just adding the port to > >> > the > >> > connection string? If so..then maybe my issue with number one (above) > >> > is > >> > the > >> > problem. > >> > > >> > Thanks for any help! > >> > - will > >> > >> > >> > >
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
| home · blog · groups | Questions? Comments? Contact the dn |