Post reply

import data in sql table from sql server database from another domain

  • August 20, 2015 at 5:51 am

    #307027

    Hi,

    I have read right on production environment and read-write access on development environment.

    Production database in on xyz domain and Development environment on abc doman. I have different login for each of db as domain is different.

    logins are : xyz\akash , abc\akash

    How can i import data to development environment from production using SSIS using windows authentication login only.

    Thanks,

    Akash

  • August 20, 2015 at 8:21 am

    #1821420

    Are the two domains trusted?

  • August 20, 2015 at 8:37 am

    #1821429

    Yes

  • August 20, 2015 at 8:53 am

    #1821436

    so can you add the xyz\akash login onto the dev SQL server as read write access and run the connection under that domain account?

  • August 20, 2015 at 9:15 am

    #1821441

    Is there any other way?

  • August 20, 2015 at 9:18 am

    #1821442

    not in ssis i believe. but if you have a trusted domain, so cross domain authentication should work.

  • August 20, 2015 at 9:37 am

    #1821450

    what if domains are non trusted? just #curious 🙂

  • August 20, 2015 at 9:49 am

    #1821457

    If domains are not trusted you have no way of connecting to the other sql server with windows authentication. xyz does not trust any users from abc so on your sqlserver in xyz you cannot add a user from domain abc.

Viewing 8 posts - 1 through 7 (of 7 total)

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