Re: How to change password for sa?

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 11/05/02 

From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Tue, 5 Nov 2002 10:14:37 -0600

The error message is a bit misleading. The problem is that a database
was restored/attached and the database owner recorded in sysdatabases is
out-of-sync with sysusers. This confuses the EM GUI.

You can run a script like the following to correct the mismatch.

USE MyDatabase
EXEC sp_addlogin 'TempOwner'
EXEC sp_changedbowner 'TempOwner'
EXEC sp_changedbowner 'sa'
EXEC sp_droplogin 'TempOwner'
GO

See http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q218172& for
details. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy  Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"Ivan D." <idych@yahoo.com> wrote in message
news:#hX3XROhCHA.1736@tkmsftngp11...
> Hello,
>
> I'm beginner with SQL administration, so probably this question is
trivial
> but... When I'm trying to change password for sa in "SQL Server Login
> Properties - sa" window, I get the message:
>
> Error 21776: [SQL-DMO]The name 'dbo' was not found in the Users
> collection... and the password's change fails.
>
> But this name does exist in every database_name\Users box. So what's
wrong?
>
> Thanks. Ivan.
>
>

Relevant Pages

  • Re: Connecting to a sql server database
    ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
    (microsoft.public.dotnet.general)
  • Re: Invalid OLEVERB structure error 80040000 on DTS job
    ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >- I copied this DTS package from a 32 bit Windows Server 2003 system. ... >I would only get that error message in the Job History logs though. ...
    (microsoft.public.sqlserver.dts)
  • Re: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked
    ... I would still try to import the data into your SQL Server instance instead of running linked server queries as you are doing. ... I can query it with no problem and view tabs in Studio. ... EXEC master.dbo.sp_addlinkedserver ...
    (microsoft.public.sqlserver.programming)
  • Re: Classic ASP connectionstring to SQL Server 2005
    ... So this connection string is in the VB6 dll? ... What is the error message? ... Provider cannot be found. ... can you ping the sql server? ...
    (microsoft.public.inetserver.asp.db)
  • Re: No more indexing on text
    ... Looking for a SQL Server replication book? ... DROP FULLTEXT CATALOG CmpArchivorCat ... exec sp_fulltext_catalog 'CmpArchivorCat', 'create' ... both text/plain and text/html in my file type column. ...
    (microsoft.public.sqlserver.fulltext)
Loading