Ms-sql

[christrinder]

I doubt I will find the answer in this forum because it seems more focussed on MySQL, but does anybody know much about Replication in MS-SQL? I have a server running SQL-Server 2005 Standard and I have set-up a Publication. I now want to pull that down to my SQL-Server 2005 Express Edition on my local machine. However, both instances are set-up for Windows Authentication only and I can't see how you can set this up?

[Brandoe85]

I've only set it up under sql 2000. Does it ask you which account to run it under? I don't know how far along you are but I found a tutorial that may or may not help.
http://www.exforsys.com/tutorials/sql-server-2005/sql-server-configuring-replication.html

Post specifics if you're having problems.

[christrinder]

Thank you! Yes, this page is VERY useful. It's just made me realise why it would never have worked. I was trying to use Windows Authentication over the Internet (which is why I was confused) but as this page link describes... what I'm after is HTTP Replication.

Thank you very much for your help!

[Brandoe85]

Cool - let us know how it works out.