SQL2000 - Can NOT add a user to a DB

From: Lint (lintadsl_at_yahoo.com)
Date: 06/25/03 

Date: Wed, 25 Jun 2003 10:33:25 -0700

Hello, I am trying to add a user to TEST DB which I got
it from another SQL server. The test DB originally from
SQL01 and I moved the DB to SQL02 which is our new SQL
server. So the DB has a user called testgod and SQL02 did
not have that user so I created it on Security. When I
looked at the Test DB's users section, nothing in it. So
I click on New Database user, and tried to add testgod
user to that DB, I get an Erro 15023: User or
role 'testgod' already exists in the current database. I
am a newbie DBA and the DBA class is coming up. So,
please give me a little more details on your idea.

Thanks in advance.
Sunny

Relevant Pages

  • Re: SQL2000 - Can NOT add a user to a DB
    ... Columnist, SQL Server Professional ... I click on New Database user, and tried to add testgod ... am a newbie DBA and the DBA class is coming up. ...
    (microsoft.public.sqlserver.security)
  • Re: Granting EXEC for read only SPs
    ... Then, I created a database user, added it to the role 'X' to inherit the ... as the procedure and the accessed tables has the same owner. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • RE: Can you script preset values for forms?
    ... you can use the Load event of the form to populate the text boxes on ... login screen that requires a few pieces of information (SQL Server Name, ... number, SQL Database name, ID and Password) in addition to the Database User ...
    (microsoft.public.access.forms)
  • Re: master db
    ... In this case you can have a common database user and keep a application ... Hari ... SQL Server Mvp ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: Can you script preset values for forms?
    ... login screen that requires a few pieces of information (SQL Server Name, Port ... number, SQL Database name, ID and Password) in addition to the Database User ...
    (microsoft.public.access.forms)