Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: Ms-sql

  1. #1
    Regular Coder
    Join Date
    Nov 2002
    Location
    Loughborough (UK)
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Ms-sql

    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?

  • #2
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    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/sq...plication.html

    Post specifics if you're having problems.

  • #3
    Regular Coder
    Join Date
    Nov 2002
    Location
    Loughborough (UK)
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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!

  • #4
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    Cool - let us know how it works out.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •