Post reply

passwords not working after migration,please help me out

  • June 19, 2008 at 6:38 am

    #192944

    We are working on a migration tool coded in VB 6.0 which can migrate all database objects from Sybase 12.5 to SQL Server 2000,SQLServer 2005,SQL Server 2008.We are unableto migrate the login password from the syslogins table of the sybase databaseas the recordset control in Vb 6.0 is unable to hold encrypted password.Using linked server we try to fetch the same encrypted password from Sybase database and using sp_addlogin and sp_password sp we tried to restore the exact password in the syslogins table of the SQL database.But unfortunately nothing is working out. I just want a way out so that we can either decrypt the password in sybase itself or after fetching it using linked server if it is possible to decrypt it.Please suggest me.

  • June 23, 2008 at 12:11 pm

    #832965

    Sorry dude... I really doubt SQL and sybase are keeping the same password algorithms anymore so converting them prob isn't going to be an option. Nor would I hold my breath on being able to decrypt them in sybase itself.

    I ran a quick google on it and didn't come up with anything really, so I'm not sure what your next option is. My guess would be that you just have to reset everyone's password to something generic and have them change it in SQL themselves.

    That's all I've got.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • June 24, 2008 at 5:38 am

    #833241

    I think you are out of luck. I do not remember ever being able to move the psswords over from sybase to SQL.


    Stacey W. A. Gregerson

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

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