SQL 2000 Add new user in restored database.

Posted on 2011-05-09
Last Modified: 2012-05-11

Last week I restored a database in a new server. Now, the network user (administrator) that I use to connect to the database doesn't have the login information.  I delete it, but when try to add it again, it says that already exist.  I don't want to delete it from the security section, because is the owner of all tables.  I try the Auto Fix command, but it gave me the following error: "Procedure or function sp_change_users_login has too many arguments specified." . I want to know if exist another way to give the loging back to this user.

Question by:feferefe
    LVL 29

    Assisted Solution

    by:Paul Jackson
    How are you calling sp_change_users_login ?
    LVL 29

    Assisted Solution

    by:Paul Jackson
    You can call the following to produce a report of users in the database:
         exec sp_change_users_login 'report'

    call the following to fix a user
        exec sp_change_users_login 'Auto_Fix', 'user'
    LVL 75

    Accepted Solution

    Now, the network user (administrator) that I use to connect to the database doesn't have the login information.  <<
    It does, the login is fine, the problem is the user.  What is happening as you have discovered is that the user is an orphan and can be corrected by using the sp_change_users_login system Stored Procedure.

    Author Comment

    Hi Guys:

    I found that the problem was the account used to start the Business Object servers (Internals). They use a LocalAccount, but now that the SQL instance didn't reside in the same server,  I changed to the domain admin, and all work fine now.  Thaks for the reponse.


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now