Failed to copy table objects - DTS Wizard

From: Paula (paula.potter@telequip.co.uk)
Date: 04/23/03 

From: "Paula" <paula.potter@telequip.co.uk>
Date: Wed, 23 Apr 2003 00:46:45 -0700

Thanks for your response.

I am only trying to copy a couple of table objects from
one SQL 2000 database to another - both on the same
server. No application roles set up.

I am using Enterprise Manager which is using SQL
Authentication and logging in as "sa".
When I go to "Security" and double click on "sa" I get the
following error:

Microsoft SQL-DMO
Error 21776: [SQL-DMO]The name 'dbo' was not found in the
Users collection. If the name is a qualified name, use []
to separate various parts of the name, and try again.

It then lets me look at the properties and I can see that
sa is a member of Server Role "System Administrators"

Looked up error 21776 on TechNet - article 305711 talks
about dbo user's SID in [sysusers] table not matched with
the SID in [syslogins] table - but I can't find a
[syslogins] table at all, only [sysxlogins] - is this the
same thing?

Running Exec sp_change_users_login 'REPORT' brings up no
results.

Ran following TSQL in Query Analyzer:
use DBName
GO
select u.[name] AS UserName, s.[name] As MatchedLogin
from sysusers u
left join master.dbo.sysxlogins s
on u.sid = s.sid
where u.[name] = 'dbo'
GO
Got expected result with Null in MatchedLogin, but how do
I fix this?
Tried following TSQL in Query Analyzer:
sp_change_users_login @Action = 'Update_One'
,@UserNamePattern = 'sa'
,@LoginName = 'dbo'
but then get following error:
Server: Msg 15291, Level 16, State 1, Procedure
sp_change_users_login, Line 88
Terminating this procedure. The User name 'sa' is absent
or invalid.

HELP!!!!!! It's all getting very frustrating !!!!

>-----Original Message-----
>Administrator does not appear anywhere in SQL Server
>unless you add it. The admin accounts are sa (login) and
>dbo (database user).
>See if there is an Application Role in the database you
>are copying - these will always fail because you cannot
>import their passwords. make sure if you are copying
>objects that you do not copy database users and roles if
>this is the case.
>
>>-----Original Message-----
>>When using SQL Enterprise Manager "DTS Import/Export
>>Wizard" to copy table objects from one SQL2000 database
>to
>>another on the same server the DTS fails with
>>message "Failed to copy objects from Microsoft SQL
Server
>>to Microsoft SQL Server" then when I double click on the
>>failed line I have error message "[Microsoft][ODBC SQL
>>Server Driver][SQL Server]User or role 'Administrator'
>>does not exist in this database."
>>Administrator is surely built in and exists in all
>>databases?
>>The tables were created and are owned by DBO.
>>I am using SQL Authentication with sa account and
>password.
>>This worked fine last month and nothing should have been
>>changed since then (or at least no-one is owning up to
>>changing anything!)
>>Please can anyone help or at least point me in the right
>>direction?
>>.
>>
>.
>

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
Quantcast