InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 01:01:33 GMT20http://www.sqlservercentral.com/Forums/Topic867911-146-1.aspxThank you very much for the tipFri, 19 Feb 2010 02:06:18 GMTriver1http://www.sqlservercentral.com/Forums/Topic867911-146-1.aspxThese are Certificate-based SQL Server Logins Server principals with names enclosed by double hash marks (##) are for internal system use only. The following principals are created from certificates when SQL Server is installed, and should not be deleted.##MS_SQLResourceSigningCertificate## ##MS_SQLReplicationSigningCertificate## ##MS_SQLAuthenticatorCertificate## ##MS_AgentSigningCertificate## ##MS_PolicyEventProcessingLogin## ##MS_PolicySigningCertificate## ##MS_PolicyTsqlExecutionLogin## http://msdn.microsoft.com/en-us/library/ms181127.aspxGlad I could help!MJThu, 18 Feb 2010 11:30:44 GMTMANU-J.http://www.sqlservercentral.com/Forums/Topic867911-146-1.aspxYour link resolved my problem, but i have dificulty in undestand something.what are this users:##MS_AgentSigningCertificate####MS_SQLAuthenticatorCertificate####MS_SQLReplicationSigningCertificate####MS_SQLResourceSigningCertificate##Do they exist in all SQL Server 2005?Thank youThu, 18 Feb 2010 08:49:08 GMTriver1http://www.sqlservercentral.com/Forums/Topic867911-146-1.aspxThank you , my problem was solved with your help.Thu, 18 Feb 2010 07:25:51 GMTriver1http://www.sqlservercentral.com/Forums/Topic867911-146-1.aspxNote: Stop the SQL Server Agent service before connecting to an instance of SQL Server in single-user mode; otherwise, the SQL Server Agent service uses the connection, thereby blocking it. When you start an instance of SQL Server in single-user mode, SQL Server Management Studio can connect to SQL Server. Object Explorer in Management Studio might fail because it requires more than one connection for some operations. To manage SQL Server in single-user mode, execute Transact-SQL statements by connecting only through the Query Editor in Management Studio, or use the sqlcmd utility.MjThu, 18 Feb 2010 07:05:58 GMTMANU-J.http://www.sqlservercentral.com/Forums/Topic867911-146-1.aspxHow can i connect throught SSMS in single user mode?Thu, 18 Feb 2010 06:00:00 GMTriver1http://www.sqlservercentral.com/Forums/Topic867911-146-1.aspxconnect thru ssms or sqlcmd to run the commandThu, 18 Feb 2010 05:32:40 GMTSqlfrenzyhttp://www.sqlservercentral.com/Forums/Topic867911-146-1.aspxHi, I'm Trying to get in to SQL Server instance in single user mode through command prompt to enable the SA account that i have disabled by mistake.i Have stoped the SQL Server service and the SQL Server Agent service and then i have typed the folowing command on the CMD:sqlservr.exe -mThe following messages appeared:C:\Programas\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>sqlservr.exe -m2010-02-18 11:35:03.42 Server Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)2010-02-18 11:35:03.42 Server Error: 17054, Severity: 16, State: 1.2010-02-18 11:35:03.42 Server The current event was not reported to the Windows Events log. Operating system error = 1502(O ficheiro de registo de eventosestá cheio.). You may need to clear the Windows Events log if it is full.2010-02-18 11:35:03.42 Server (c) 2005 Microsoft Corporation.2010-02-18 11:35:03.42 Server All rights reserved.2010-02-18 11:35:03.42 Server Server process ID is 3012.2010-02-18 11:35:03.42 Server Authentication mode is MIXED.2010-02-18 11:35:03.42 Server Logging SQL Server messages in file 'C:\Programas\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.2010-02-18 11:35:03.42 Server This instance of SQL Server last reported using a process ID of 3196 at 18-02-2010 11:34:46 (local) 18-02-2010 11:34:46 (UTC). This is an informational message only; no user action is required.2010-02-18 11:35:03.42 Server Registry startup parameters:2010-02-18 11:35:03.42 Server -d C:\Programas\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf2010-02-18 11:35:03.42 Server -e C:\Programas\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG2010-02-18 11:35:03.42 Server -l C:\Programas\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf2010-02-18 11:35:03.42 Server Command Line Startup Parameters:2010-02-18 11:35:03.42 Server -m2010-02-18 11:35:03.45 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.2010-02-18 11:35:03.45 Server Detected 2 CPUs. This is an informational message; no user action is required.2010-02-18 11:35:03.70 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.2010-02-18 11:35:03.78 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.2010-02-18 11:35:03.83 Server The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.2010-02-18 11:35:03.84 Server Database Mirroring Transport is disabled in the endpoint configuration.2010-02-18 11:35:03.85 spid5s Warning ******************2010-02-18 11:35:03.85 spid5s SQL Server started in single-user mode. Thisan informational message only. No user action is required.2010-02-18 11:35:03.85 spid5s Starting up database 'master'.2010-02-18 11:35:03.91 spid5s Recovery is writing a checkpoint in database'master' (1). This is an informational message only. No user action is required.2010-02-18 11:35:03.96 spid5s SQL Trace ID 1 was started by login "sa".2010-02-18 11:35:03.99 spid5s Starting up database 'mssqlsystemresource'.2010-02-18 11:35:04.03 spid5s The resource database build version is 9.00.4035. This is an informational message only. No user action is required.2010-02-18 11:35:04.37 spid5s Server name is 'FSCG28'. This is an informational message only. No user action is required.2010-02-18 11:35:04.37 spid8s Starting up database 'model'.2010-02-18 11:35:04.58 spid8s Clearing tempdb database.2010-02-18 11:35:04.94 spid8s Starting up database 'tempdb'.2010-02-18 11:35:05.11 Server A self-generated certificate was successfully loaded for encryption.2010-02-18 11:35:05.15 Server Server is listening on [ 'any' <ipv4> 1433].2010-02-18 11:35:05.16 Server Server local connection provider is ready toaccept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].2010-02-18 11:35:05.16 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].2010-02-18 11:35:05.17 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].2010-02-18 11:35:05.18 Server Dedicated admin connection support was established for listening locally on port 1434.2010-02-18 11:35:05.22 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.2010-02-18 11:35:05.35 spid8s Starting up database 'teste1'.2010-02-18 11:35:05.35 spid11s Starting up database 'SGCT'.2010-02-18 11:35:05.36 spid10s Starting up database 'msdb'.2010-02-18 11:35:05.84 spid8s CHECKDB for database 'teste1' finished without errors on 2010-02-03 17:31:36.363 (local time). This is an informational message only; no user action is required.2010-02-18 11:35:06.34 spid5s Recovery is complete. This is an informational message only. No user action is required.2010-02-18 11:44:33.70 Logon Error: 18470, Severity: 14, State: 1.2010-02-18 11:44:33.70 Logon Login failed for user 'sa'. Reason: The account is disabled. [CLIENT: <local machine>]2010-02-18 11:45:03.94 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 824, committed (KB): 25292, memory utilization: 3%.2010-02-18 11:50:38.87 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 331 seconds. Working set (KB): 2492, committed (KB): 22988, memory utilization: 10%.2010-02-18 11:55:11.02 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 602 seconds. Working set (KB): 5088, committed (KB): 22988, memory utilization: 22%.2010-02-18 12:00:37.19 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 928 seconds. Working set (KB): 5096, committed (KB): 22988, memory utilization: 22%.It seems that SQL Server is started , but then i wnat to type the command "alter login 'sa' enable" and i can't because the cursor don't let me write anything.Can someone help, please?Thank you. Thu, 18 Feb 2010 05:08:25 GMTriver1