Post reply

I have SQL Server and Backup Server in different domain.

  • April 3, 2012 at 2:16 am

    #254248

    I have SQL Server and Backup Server in different domain1 and domain2 respectively.

    and the backup folder which exist on Backup server is shared with full Permission to everyone.

    When I run SQL service account with domain1/Administrator then Backup files are creating on the Remote Backup server.

    and it fails with Error: Operating system error ,Bad user name and Password If I run SQL service account with domain1/dummyuser then Backup files are not creating on the Remote Backup server.

    While this dummyuser is sysadmin in sql server.

    If both server are in different domain then why the backup file is creating for domain1/Administrator user.

    Thanks

  • April 3, 2012 at 4:48 am

    #1468104

    I'm sorry but I can't really understand your problem 100%. I think you said that when you run the job with an "administrator" account it works, but with another account it doesn't. Is that right? Could you please try to rephrase your problem?

    Any way I found a blog about cross domain authentication, I hope it helps http://blogs.msdn.com/b/anthonw/archive/2006/08/02/686041.aspx



    My blog

  • April 3, 2012 at 4:50 am

    #1468107

    Thanks,Yes you have got right.

    Thanks

  • April 3, 2012 at 5:22 am

    #1468131

    From Sql Server I can access the backup server using: \\Backup_Server\d$\Backup

    Thanks

  • April 3, 2012 at 6:38 am

    #1468170

    Are both the share level and NTFS permissions set to everyone full control?

  • April 3, 2012 at 6:46 am

    #1468176

    share level and NTFS permissions

    I have shared it with everyone full permission.

    Thanks

  • April 3, 2012 at 7:34 am

    #1468206

    ok, you are using the D$ share, you need to be an admin account to use that, I guess there is a trust between the 2x domains if domain administrator of dom1 can do it without issue, the fix is to create another share on the D:\ drive without the $ or create the share on the d:\backup folder and use that.

  • April 3, 2012 at 9:11 am

    #1468288

    You have 2 domains. Say you have domain1\user and domain2\user. Just because they are both named "user" does not mean they will authenticate properly. You cannot, without special cross-domain changes, authenticate using Windows Authentication.

    Jared
    CE - Microsoft

  • April 3, 2012 at 9:14 am

    #1468289

    Let me rephrase that a bit... domain1\dummyuser is a domain user. Administrator is not and can therefore authenticate.

    Jared
    CE - Microsoft

  • April 3, 2012 at 9:28 am

    #1468297

    the only way to resolve the issue is to some how authenticate between domain1 and domain2 whether running a batch file to link the users or linking the domains some how.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply