Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 37

Thread: Merge replication

  1. #16
    Join Date
    Jan 2007
    Posts
    5
    ok fair enough,

    Are you trying to use the replicated db (on server b) as a mirror/backup or will the server B database be actively used by users?

  2. #17
    Join Date
    Jan 2007
    Posts
    25
    We want to have the server B actively used by users.

  3. #18
    Join Date
    Jan 2007
    Posts
    5
    ah right, that makes more sense ;-)

  4. #19
    Join Date
    Jan 2007
    Posts
    25
    Hi,

    I have just run the 'dts copy logins task' to copy the logins from server A to server B and the database that I copied was the master database. I am honestly not sure how to test it to make sure the logins on server B is working. Any ideas how?

    Thanks in advance for input!

    -whitebelt

  5. #20
    Join Date
    Jan 2007
    Posts
    5
    Try setting up a sql datasource on a client machine to Server b, specifying username and password to connect with, then try a query using that data source (alternatively I think theres a "test datasource" button), if it fails on uid/pwd it will report a login failure

  6. #21
    Join Date
    Jan 2007
    Posts
    25
    Hi,

    Thanks for your response! I guess I am not familiar with this test, is there anyway you can walk me through step-by-step how to test it?

    I really appreciate your help!

    -whitebelt

  7. #22
    Join Date
    Sep 2002
    Posts
    5,938
    Just open query analyzer, choose sql server b to connect to, put in that user id and password.

  8. #23
    Join Date
    Jan 2007
    Posts
    5
    yeah thats probably the easiest thing to do

  9. #24
    Join Date
    Jan 2007
    Posts
    25
    Thank you both for your quick responses!

    I tried to log onto Query Analyzer but I got an error message 'sql server does not exist or access denied', I used the same userid and password to log onto Enterprize Manager to the same server (serverB), and it worked fine. Does it have anything to do with access right? I mean if I can log onto the Enterprize Manager, I should be able to log onto the Query Analyzer correct? I had no problem logging onto this server before though.

    Looking forward to your responses!

    -whitebelt

  10. #25
    Join Date
    Sep 2002
    Posts
    5,938
    If it works in em, should work in query analyzer. Is it windows account or standard sql account? Right click the server b in em and go to edit sql server registration to see what kind of authentication used.

  11. #26
    Join Date
    Jan 2007
    Posts
    25
    Hi 'rmiao',

    Thank you so much for your quick reply!

    I have checked the sql server registration, it's used 'window authentication', so I logged onto serverB again using window authentication connection, and it worked fine, but if I used 'sql server authentication', it does not work. How do I change/edit my userid so that I can also log onto the serverB using 'sql server authentication' ?

    -whitebelt

  12. #27
    Join Date
    Sep 2002
    Posts
    5,938
    No you can't since they are different type of sql logins.

  13. #28
    Join Date
    Jan 2007
    Posts
    25
    I see! so I guess it's the only way to test is to log onto the serverB with whatever the authentication is set in the sql server registration for that particular userid and password ? Am I correct?

    -Whitebelt

  14. #29
    Join Date
    Sep 2002
    Posts
    5,938
    That's right.

  15. #30
    Join Date
    Jan 2007
    Posts
    25
    Thanks again for all your responses!

    -whitebelt

Posting Permissions

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