Post reply

In SQL 2005 - sp_change_users_login ''Report'' no output

  • January 10, 2007 at 7:24 am

    #122229

    In trying to resolve orphaned users in SQL 2005 (no service pack) I tried to run the sp

    use PAT

    go

    sp_change_users_login 'Report'

    And I get no output other than Command(s) completed successfully. Also tried

    USE <database_name>;GO sp_change_users_login @Action='Report'
    Any idea's?

  • January 10, 2007 at 11:40 am

    #682503

    This procedure cann't be used with windows logins...

    If there is nothing to report it will give you nothing...

    May be you don't have orphand logins in your db.

    MohammedU
    Microsoft SQL Server MVP

  • January 10, 2007 at 12:32 pm

    #682526

    No, I did have orphaned users. I tried SQL 2000 Query analyzer from a suggestion by another admin. Sure enough, it worked. Cleared up the orphaned users and then I was able to create a DSN in ColdFusion.

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

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