• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • Last Modified:

SQL 2000 Add new user in restored database.

Hi:

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.

Thanks,
JC
0
feferefe
Asked:
feferefe
  • 2
3 Solutions
 
Paul JacksonCommented:
How are you calling sp_change_users_login ?
0
 
Paul JacksonCommented:
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'
0
 
Anthony PerkinsCommented:
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.
0
 
feferefeAuthor Commented:
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.

Regards,
JC
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now