Hello --
We have a SQL Server 2000 machine that has approximately 500 user databases.
Don't ask why -- I did not create this mess.
Anyway, we have about 200 users access the SQL Server as a DSS machine
using SA. We've finally weaned all users off of SA and each have their on
ID per customer.
Tonight, I was finally trying to change the "SA" password from within
Enterprise Manager and received the following message:
Error 21776: [SQL-DMO] The name 'XXXX' 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 looks like I'm receiving this message for every database we have.
I brought up another instance of Enterprise Manager and looked at each
database property and noticed that the owner of database was either "SA",
"NT user that happens to be logged into server most of the time", or some
other local SQL Server user.
How do I fix this problem?
All databases should simply belong to DBO and no one inparticular.
The problem is, I have multiple people that create databases and they all
log into the server differenently and use different steps in creating the
database.
Can I simply ignore these error messages?
If I do need to change the owner of all 500 databases, is there an easier
way than manually running sp_changedbowner?
--
...david
http://www.micro-mess.com
http://www.va-mustang.com
If you wish to reply to me personally, please remove
the "underline" from scandal_123@.cox.net. The is done to avoid SPAM!All databases need to be owned by a valid login or you may get errors in
Enterprise Manager. You can use a script below to generate a script that
changes database ownership to the login of your choosing.
SELECT 'EXEC ' +
CATALOG_NAME +
'..sp_changedbowner ''sa'''
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE CATALOG_NAME NOT IN
(
'master',
'model',
'msdb',
'tempdb',
'distribution'
)
--
Hope this helps.
Dan Guzman
SQL Server MVP
"DavidM" <scandal_123@.cox.net> wrote in message
news:uYTjmAcxDHA.2448@.TK2MSFTNGP12.phx.gbl...
> Hello --
> We have a SQL Server 2000 machine that has approximately 500 user
databases.
> Don't ask why -- I did not create this mess.
> Anyway, we have about 200 users access the SQL Server as a DSS machine
> using SA. We've finally weaned all users off of SA and each have their on
> ID per customer.
> Tonight, I was finally trying to change the "SA" password from within
> Enterprise Manager and received the following message:
> Error 21776: [SQL-DMO] The name 'XXXX' 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 looks like I'm receiving this message for every database we have.
> I brought up another instance of Enterprise Manager and looked at each
> database property and noticed that the owner of database was either "SA",
> "NT user that happens to be logged into server most of the time", or some
> other local SQL Server user.
> How do I fix this problem?
> All databases should simply belong to DBO and no one inparticular.
> The problem is, I have multiple people that create databases and they all
> log into the server differenently and use different steps in creating the
> database.
> Can I simply ignore these error messages?
> If I do need to change the owner of all 500 databases, is there an easier
> way than manually running sp_changedbowner?
> --
> ...david
> http://www.micro-mess.com
> http://www.va-mustang.com
> If you wish to reply to me personally, please remove
> the "underline" from scandal_123@.cox.net. The is done to avoid SPAM!
>
Showing posts with label xxxx. Show all posts
Showing posts with label xxxx. Show all posts
Friday, February 17, 2012
Error 21776: [SQL-DMO] The name 'XXXX' was not found in the Users collection
Hello --
We have a SQL Server 2000 machine that has approximately 500 user databases.
Don't ask why -- I did not create this mess.
Anyway, we have about 200 users access the SQL Server as a DSS machine
using SA. We've finally weaned all users off of SA and each have their on
ID per customer.
Tonight, I was finally trying to change the "SA" password from within
Enterprise Manager and received the following message:
Error 21776: [SQL-DMO] The name 'XXXX' 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 looks like I'm receiving this message for every database we have.
I brought up another instance of Enterprise Manager and looked at each
database property and noticed that the owner of database was either "SA",
"NT user that happens to be logged into server most of the time", or some
other local SQL Server user.
How do I fix this problem?
All databases should simply belong to DBO and no one inparticular.
The problem is, I have multiple people that create databases and they all
log into the server differenently and use different steps in creating the
database.
Can I simply ignore these error messages?
If I do need to change the owner of all 500 databases, is there an easier
way than manually running sp_changedbowner?
...david
http://www.micro-mess.com
http://www.va-mustang.com
If you wish to reply to me personally, please remove
the "underline" from scandal_123@.cox.net. The is done to avoid SPAM!All databases need to be owned by a valid login or you may get errors in
Enterprise Manager. You can use a script below to generate a script that
changes database ownership to the login of your choosing.
SELECT 'EXEC ' +
CATALOG_NAME +
'..sp_changedbowner ''sa'''
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE CATALOG_NAME NOT IN
(
'master',
'model',
'msdb',
'tempdb',
'distribution'
)
Hope this helps.
Dan Guzman
SQL Server MVP
"DavidM" <scandal_123@.cox.net> wrote in message
news:uYTjmAcxDHA.2448@.TK2MSFTNGP12.phx.gbl...
databases.
We have a SQL Server 2000 machine that has approximately 500 user databases.
Don't ask why -- I did not create this mess.
Anyway, we have about 200 users access the SQL Server as a DSS machine
using SA. We've finally weaned all users off of SA and each have their on
ID per customer.
Tonight, I was finally trying to change the "SA" password from within
Enterprise Manager and received the following message:
Error 21776: [SQL-DMO] The name 'XXXX' 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 looks like I'm receiving this message for every database we have.
I brought up another instance of Enterprise Manager and looked at each
database property and noticed that the owner of database was either "SA",
"NT user that happens to be logged into server most of the time", or some
other local SQL Server user.
How do I fix this problem?
All databases should simply belong to DBO and no one inparticular.
The problem is, I have multiple people that create databases and they all
log into the server differenently and use different steps in creating the
database.
Can I simply ignore these error messages?
If I do need to change the owner of all 500 databases, is there an easier
way than manually running sp_changedbowner?
...david
http://www.micro-mess.com
http://www.va-mustang.com
If you wish to reply to me personally, please remove
the "underline" from scandal_123@.cox.net. The is done to avoid SPAM!All databases need to be owned by a valid login or you may get errors in
Enterprise Manager. You can use a script below to generate a script that
changes database ownership to the login of your choosing.
SELECT 'EXEC ' +
CATALOG_NAME +
'..sp_changedbowner ''sa'''
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE CATALOG_NAME NOT IN
(
'master',
'model',
'msdb',
'tempdb',
'distribution'
)
Hope this helps.
Dan Guzman
SQL Server MVP
"DavidM" <scandal_123@.cox.net> wrote in message
news:uYTjmAcxDHA.2448@.TK2MSFTNGP12.phx.gbl...
quote:
> Hello --
> We have a SQL Server 2000 machine that has approximately 500 user
databases.
quote:
> Don't ask why -- I did not create this mess.
> Anyway, we have about 200 users access the SQL Server as a DSS machine
> using SA. We've finally weaned all users off of SA and each have their on
> ID per customer.
> Tonight, I was finally trying to change the "SA" password from within
> Enterprise Manager and received the following message:
> Error 21776: [SQL-DMO] The name 'XXXX' 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 looks like I'm receiving this message for every database we have.
> I brought up another instance of Enterprise Manager and looked at each
> database property and noticed that the owner of database was either "SA",
> "NT user that happens to be logged into server most of the time", or some
> other local SQL Server user.
> How do I fix this problem?
> All databases should simply belong to DBO and no one inparticular.
> The problem is, I have multiple people that create databases and they all
> log into the server differenently and use different steps in creating the
> database.
> Can I simply ignore these error messages?
> If I do need to change the owner of all 500 databases, is there an easier
> way than manually running sp_changedbowner?
> --
> ...david
> http://www.micro-mess.com
> http://www.va-mustang.com
> If you wish to reply to me personally, please remove
> the "underline" from scandal_123@.cox.net. The is done to avoid SPAM!
>
Error 21776: [SQL-DMO] The name XXXX was not found in the Database collection.
Hi,
This is the error that I am getting after an unsuccessfuldatabase attachment.
Error 21776: [SQL-DMO] The name 'XXXX' was not found in the Databasecollection. If the name is a qualified name, use [] to separate various partsof the name, and try again.
Any ideas how can I delete that database?
Thanks
Kind regards,
Gift Peddie
|||Hi,
Yes I did try to move from one server to the current one, the solution was to restore it from an existing backup.
Just wondering if the operation fails, nothing should happen. Any way thanks for the ideas.
|||check if thislink helps.
Labels:
attachment,
collection,
database,
error,
microsoft,
mysql,
oracle,
server,
sql,
sql-dmo,
unsuccessfuldatabase,
xxxx
Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
Hi,
Does anyone know how to get over this problem in SQL 2000 without
removing all replication then adding back in?
Could not create a Pull subscription to publication XXX
Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
Thanks
Dave
Is the pull subscriber in the dbo role on the publisher and the distributor?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David Gray" <grayd@.turpin-distribution.com> wrote in message
news:28j6s25v4j97onbjvg6j05pdv1uq56pmob@.4ax.com...
> Hi,
> Does anyone know how to get over this problem in SQL 2000 without
> removing all replication then adding back in?
> Could not create a Pull subscription to publication XXX
> Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
> Thanks
> Dave
|||On Fri, 2 Feb 2007 10:37:32 -0500, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:
>Is the pull subscriber in the dbo role on the publisher and the distributor?
Hi,
I'm not sure what you mean. I'm not able to add the subscriber
because of the error mentioned in the subject line.
The other strange thing is that none of the other subscribers on this
SQL 2K box appear in the Replication | Subscriptions tree (EM Console)
even after I refresh.
Dave
Does anyone know how to get over this problem in SQL 2000 without
removing all replication then adding back in?
Could not create a Pull subscription to publication XXX
Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
Thanks
Dave
Is the pull subscriber in the dbo role on the publisher and the distributor?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David Gray" <grayd@.turpin-distribution.com> wrote in message
news:28j6s25v4j97onbjvg6j05pdv1uq56pmob@.4ax.com...
> Hi,
> Does anyone know how to get over this problem in SQL 2000 without
> removing all replication then adding back in?
> Could not create a Pull subscription to publication XXX
> Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
> Thanks
> Dave
|||On Fri, 2 Feb 2007 10:37:32 -0500, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:
>Is the pull subscriber in the dbo role on the publisher and the distributor?
Hi,
I'm not sure what you mean. I'm not able to add the subscriber
because of the error mentioned in the subject line.
The other strange thing is that none of the other subscribers on this
SQL 2K box appear in the Replication | Subscriptions tree (EM Console)
even after I refresh.
Dave
Labels:
adding,
back,
create,
database,
error,
incould,
microsoft,
mysql,
oracle,
pull,
replication,
server,
sql,
sql-dmo,
subscription,
table,
transpublication,
withoutremoving,
xxxx
Subscribe to:
Posts (Atom)