Integration of Active Directory with SQL Server 2005

  • Hi All,

    Actually i want to migrate users from one domain to another and also the password for the user.

    for this AD requires database and i need to integrate AD with SQL server so that all the user and passwords

    of the users are stored in sql database and when i migrate the user it also take the password from the sql database and migrate the password too with the user.

    i have already configured sql server 2005 and prepare a database adpaswd BUT main thing is that how to configured that database so that it can store ad database and can provide the database at the time user get migrate from one domain to another.

    please help me to do this. Thanx for your help in advance.

    If you want some more inf on this you can send me the reply.

    Thanx

    Vijay

  • I don't fully understand

    MS has a sp_help_revlogin (google it) to help you generate login scripts (along with SIDs and passwords)

    If you're moving within the same domain, SQL Server knows to ask AD server to authenticate the user at the new server

    An example may explain your situation better

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005
  • Actually you are taking this wrong i dnt wanna migrate user from one instance to another i am using active directory(domain and i have successfully migrate the user from one forest to another forest without any problem but the thing is that user's password didn't get migrate alongwith user because to do this it needs a MS SQL server 2005 database with which it can migrate the user's paswd to in the another forest so i need to integrate the SQL server with AD

Viewing 3 posts - 1 through 3 (of 3 total)

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