RE: Error 21023
From: Anne Zorner [MSFT] (annez@online.microsoft.com)
Date: 04/16/03
- Next message: Anne Zorner [MSFT]: "RE: Error 916: Server user X is not a valid user in database X"
- Previous message: Stefan Andersson: "RE: Error 916: Server user X is not a valid user in database X"
- In reply to: DMC: "Error 21023"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: annez@online.microsoft.com (Anne Zorner [MSFT]) Date: Wed, 16 Apr 2003 08:09:47 GMT
The message :
| Configuration option 'show advanced options' changed from
| 1 to 1. Run the RECONFIGURE statement to install.
is normal and required when changes are made to the configuration options..
I take it there was no other message in the errorlog?
Is this server a clustered sql server?
Is it a default or named instance?
If you look in the list of logins do you see the user that you are
currently registered as inSQL Enterprise Manager (SEM) ?
What SQL service pack are you running on the client where SEM is running?
If its not the same as the server, can you apply it?
Does it work now?
Could you try changing your registration method for SEM to use sa?
Does it work now?
If it does not could you run profiler and capture actions that are taking
place (TSQLStmt Starting and TSQL stmt Completed and all errors and
warnings, and ensure that you add in the error data column.
regards
Anne
This posting is provided "AS IS" with no warranties, and
confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "DMC" <dcorbett@postandcourier.com>
| Sender: "DMC" <dcorbett@postandcourier.com>
| Subject: Error 21023
| Date: Wed, 9 Apr 2003 08:37:00 -0700
| Lines: 19
| Message-ID: <043101c2fead$dc938d50$3001280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcL+rdyT5lMfqdGJSM+pKK+ETcMNWA==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.security
| NNTP-Posting-Host: TK2MSFTNGXA03 10.40.1.48
| Path: cpmsftngxa08.phx.gbl!cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa08.phx.gbl microsoft.public.sqlserver.security:12940
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| From Enterprise Manager I wanted to enable SQL server for
| auditing both
| successful and failed logins. I right click on the SQL
| server , choose Properties, under Security tab, and select
| ALL under Audit level. When I ok it, I get the
| error message:
| Error 21023:[SQL-DMO]Login name not specified.
|
| I also see in the SQL log a message that reads:
| Configuration option 'show advanced options' changed from
| 1 to 1. Run the RECONFIGURE statement to install.
|
| I stopped and started the MSSQLSERVER and SQLSERVERAGENT in
| services...but I still get the error message when I ok
| it...
|
|
|
|
|
- Next message: Anne Zorner [MSFT]: "RE: Error 916: Server user X is not a valid user in database X"
- Previous message: Stefan Andersson: "RE: Error 916: Server user X is not a valid user in database X"
- In reply to: DMC: "Error 21023"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
