I'm moving the master & resource databases as described on MSDN... http://msdn2.microsoft.com/en-us/library/ms345408.aspx
I've completed step 7... "Start the instance of SQL Server in master-only recovery mode...." and am up to step 8 which requires me to login to SQL Management Studio to run a query, but I receive the following error...
Login failed for user 'sa'. Reason: Server is in single user mode. Only one administrator can connect at this time. (Microsoft SQL Server, Error: 18461)
Further details produces... "Error: 18461, Severity: 14, State: 1"
I have no other open connection that I can think of.
I have a big problem with a SQL 6.5 (no SP) running in a production environment on NT 3.51 SP 4 since 2,5 years.
Suddenly Friday at 99/10/01 14:17:38.93 we started having problems and we could'nt connect to the DB from our client server application written in VB4.
We rebooted the server and we had other errors at 99/10/01 16:15:40.96.
The error code is 605-21-1 and it seems like the main table (FILMS) of our db (VISPO) has phisical allocation problems.
here is en extract from the SQLServer error log of the first problem:
99/10/01 14:17:38.93 kernel udread: Operating system error 23(Data error (cyclic redundancy check)) on device 'E:MSSQLDATAvispodat.DAT' (virtpage 0x05000f35). 99/10/01 14:17:43.62 spid13 Buffer 9531a0 from database 'vispo' has page number -1 in the page header and page number 3893 in the buffer header 99/10/01 14:17:43.69 kernel mirrorproc: i/o error on primary device 'E:MSSQLDATAvispodat.DAT'
And here is what we had at 16:15
99/10/01 16:15:40.96 spid11 Getpage: bstat=0x1008/0, sstat=0x80010130, disk99/10/01 16:15:40.96 spid11 pageno is/should be:objid is/should be:99/10/01 16:15:40.96 spid11 0xffffffff(-1)0xffffffff(-1)99/10/01 16:15:40.96 spid11 0xf34(3892)0xe4e2b2e(240003886)99/10/01 16:15:40.96 spid11 ... retry bufget after purging bp 0x943a8099/10/01 16:15:40.98 spid11 Error : 605, Severity: 21, State: 1 99/10/01 16:15:40.98 spid11 Attempt to fetch logical page 3892 in database 'vispo' belongs to object '-1', not to object 'FILMS'.
We are thinking about restoring the BackUp of the previous night that should be OK, but I would like what we can try to do in order to have the db working properly.
Even if the restore would be fine, maybe we are starting to have problems on the disk subsystems?
What can we check, something like scandisk in DOS?
I attach here in ZIP format the 2 log files and plese ignore the MAPI errors that are "normal", we just don't care. I don't know if it's possible to attach files to a newsgroup or a discussion group but I will try
I synch 4 databases everyday and on one of them I get the Error 823, Severity 24, State 2 error (Yes I know you have heard this before but I am a new, LOL). I have tried detaching the database and copying it, renaming that database and then copying back to the original name with the same error; therefore, I think the error is somewhere in the database structure. If it is the database structure would it still give the error above or is that simply a hardware error? I have been searching for solution and I am at a loss. Any help would be appreciated.
Ignore the error below, It's got to do with isolation levels (nolock in this case): refer http://support.microsoft.com/?kbid=834290 for details.
Error: 644, Severity: 21, State: 6 Could not find the index entry for RID '1631393920202020202020202020202033392020202020202 020202020202019bcd3113230303037333120202020202020' in index page (1:420134), index ID 0, database 'DBName'..
What I'd like to know is how to get the table name that was affected out of this error message. Do I query sysindexes, sysobjects, use a function or something else?
Hi, i encounter a problem with my sql. What my system does is that it restore/dump database from some backup. it will then send email using the xp_sendmail. After that it will send out sms using a command line script.
The timing as per the attachment i put in here. Pls kindly help. production issue.
Here are some other events that caused the error
Using 'dbghelp.dll' version '4.0.5' *Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0003.txt
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
Error: 18456, Severity: 14, State: 8. Login failed for user 'sa'. [CLIENT: <ip address>]
With what Ive searched.. State: 8 is wrong password. What Ive encountered I believed is not State: 8 I guess... I have 2 pc.. PCX and PCY.. PCY has SQL Server 2005 so does PCX.. when I run my application that stores data to PCY DB it prompts me an error just like the one above.. but what seems to be confusing me is both of them have the same DB password. Did I miss something... please help..
------------------- Real Programmer dont document
If its hard to write Then its easy to undertand. End If
While my production sql server was running, suddenly i got the error below and the connection was lost. Can anyone pls guide what is this error for, why this occured and how to resolve it. I got this error 2 times in two months.
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 232 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
I run SQL Server 2000 with SP4 with OS Win 2003. I found this error in event viewer. I am assuming that some procedure was running at this time.
SQL Server version 6.5 pack 4 and Windows NT 4.0 pack 3
"Error 1105, Severity: 17, State: 2 Can't allocate space for object 'Syslogs' in Database 'TNGDB' because the 'logsegment' segment is full. If you run out of space in 'Syslogs', dump the transaction log. Otherwise use Alter database or sp_extendsegment to increase the size of the segment" The database size was 20 and the log size 15. Yesterday after I got the same message I went to edit the database and expanded the database size and log to DB 23 and log 20. Backup of the log and maintenance was done last night. However, the error message is still there. Also I went to edit the database device and for the DB device I see -795 and I am not able to change the size at all. The same with the log it shows -798 and no option to change the size. Please advice. Shashu
2006-05-26 11:35:22.76 server Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2006-05-26 11:35:22.76 server Copyright (C) 1988-2002 Microsoft Corporation. 2006-05-26 11:35:22.76 server All rights reserved. 2006-05-26 11:35:22.76 server Server Process ID is 1868. 2006-05-26 11:35:22.76 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL$MSFWLOGERRORLOG'. 2006-05-26 11:35:22.85 server SQL Server is starting at priority class 'normal'(2 CPUs detected). 2006-05-26 11:35:23.65 server SQL Server configured for thread mode processing. 2006-05-26 11:35:23.68 server Using dynamic lock allocation.  Lock Blocks,  Lock Owner Blocks. 2006-05-26 11:35:24.01 spid3 Starting up database 'master'. 2006-05-26 11:35:24.31 spid3 Error: 9003, Severity: 20, State: 1. 2006-05-26 11:35:24.45 spid3 Cannot recover the master database. Exiting.
We have a customized package which uses 2 middle layers before it hits the database. yesterday the sqlserver rebooted all of sudden and I got this error
Process ID 96 attempting to unlock unowned resource KEY: 7:167671645:4 (8d021bb2cdf2)..
Error: 1203, Severity: 20, State: 1
Error 1203 Severity Level 20 Message Text Process ID %d attempting to unlock unowned resource %.*ls.
Explanation This error occurs when Microsoft® SQL Server™ is engaged in some activity other than normal post-processing cleanup and it finds that a particular page it is attempting to unlock is already unlocked. The underlying cause for this error may be related to structural problems within the affected database. SQL Server manages the acquisition and release of pages to maintain concurrency control in the multi-user environment. This mechanism is maintained through the use of various internal lock structures that identify the page and the type of lock present. Locks are acquired for processing of affected pages and released when the processing is completed.
Action Execute DBCC CHECKDB against the database in which the object belongs. If DBCC CHECKDB reports no errors, attempt to reestablish the connection and execute the command.
Important If executing DBCC CHECKDB with one of the repair clauses does not correct the index problem, or if you are unsure what effect DBCC CHECKDB with a repair clause has on your data, contact your primary support provider
Can anyone help with this.DBCC checkdb returned without errors.
C:Program FilesMicrosoft SQL ServerMSSQLBinn>sqlservr -c -T3608 2005-12-05 09:56:50.81 server Microsoft SQL Server 2000 - 8.00.760 (Intel X8 6) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2005-12-05 09:56:50.82 server Copyright (C) 1988-2002 Microsoft Corporation.
2005-12-05 09:56:50.82 server All rights reserved. 2005-12-05 09:56:50.82 server Server Process ID is 5548. 2005-12-05 09:56:50.82 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQLlogERRORLOG'. 2005-12-05 09:56:50.84 server SQL Server is starting at priority class 'norma l'(2 CPUs detected). 2005-12-05 09:56:50.88 server SQL Server configured for thread mode processin g. 2005-12-05 09:56:50.90 server Using dynamic lock allocation.  Lock Bloc ks,  Lock Owner Blocks. 2005-12-05 09:56:50.90 server Attempting to initialize Distributed Transactio n Coordinator. 2005-12-05 09:56:52.93 spid4 Recovering only master database 2005-12-05 09:56:52.95 spid4 Starting up database 'master'. 2005-12-05 09:56:53.07 spid4 Error: 9003, Severity: 20, State: 1. 2005-12-05 09:56:53.07 spid4 Cannot recover the master database. Exiting.
and get Dedicated Admin Connection <domain><user> CONNECT SQL GRANT TSQL Local Machine <domain><user> CONNECT SQL GRANT TSQL Named Pipes <domain><user> CONNECT SQL GRANT TSQL Default TCP <domain><user> CONNECT SQL GRANT TSQL Default VIA <domain><user> CONNECT SQL GRANT
I am running SQL Server 2005 x64 SP2 and have problem connecting to database with the SQL logins I created. I test the database login using Microsoft ODBC Administrator to connect the the database locally, only 'sa' can login. All other sql logins I created fails and returns this message:
--------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'doteasylogin'.
--------------------------- OK ---------------------------
In the SQL Logs, it shows: Error: 18456, Severity: 14, State: 12.
I have SQL 2005 Expess installed on Windows Server 2003 SP1.
My application is running as a service and is set to depend on SQL Server instance... During the startup my app attempts to connect to the databes and it fails to do so, after 30 retries (1second appart). SQL Server log has this error msg: Error: 18456 "Severity: 14, State: 10"
Once the server has started, I cam manually start my application and it then sucesfully opens a connection to the database.
i am new to sql server 2005 express. I am trying to set up xp embedded database. I am trying to allow remote access to a central xp embedded database. i have the database on the sql server machine.
i am using the component database manager toll on a remote machine so that i can connect to the remote xp embedded database. when i try to connect to the db through sql server i get the following error in the log file.
2006-09-12 17:15:10.18 Logon Error: 18456, Severity: 14, State: 11. 2006-09-12 17:15:10.18 Logon Login failed for user 'HOSTNAMEGuest'. [CLIENT: XX.XX.XX.XX]
where HOSTNAME is the hostname of the pc that sql server 2005 is running.
XX.XX.XX.XX is the ip address of the client which is running component database manager tool.
I installed a verisign test certificate (and their root cert) and got the above mentioned error. Googling that error resulted in this link- http://support.microsoft.com/kb/900495 and not much else. Their "cause" does not apply to me because my SQL Server runs under the local system account, not a service account.
So, can anyone suggest another fix besides the one listed in that link? BTW, I did compile and run the code on that page. The only thing it did was throw a bunch of errors......
I am running on Windows Server 2003 Enterprise SP1 with SQL Server 2005 SP2.
Error: 18456, Severity: 14, State: 16. Login failed for user 'PRIsqlservice'. [CLIENT: 172.16.9.2]
in the log repeated every 15 seconds or so. I am logged into the server as prisqlservice, I have started the sql server and sql server agent with prisqlservice and I can access databases and tables inside the Server Management studio. I have set up the login prisqlservice and given it dbo owner access to all databases.
I am in the process of upgrading from 2000 to 2005. I have installed a new sql server 2005, restored backups of databases from 2000. I have also converted all packages and uploaded those to the new server (although they all point to the 2000 server). I have imported the jobs, but all but one are disabled and the one that is enabled ran okay when I ran it manually.
I have researched and researched this issue, and none seem to apply to my specific issue.
This is an extract of my errorlog:
2006-12-20 16:23:16.95 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2006-12-20 16:23:16.98 Server (c) 2005 Microsoft Corporation. 2006-12-20 16:23:16.98 Server All rights reserved. 2006-12-20 16:23:16.98 Server Server process ID is 1780. 2006-12-20 16:23:16.98 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'. 2006-12-20 16:23:16.98 Server This instance of SQL Server last reported using a process ID of 4532 at 12/20/2006 4:23:52 PM (local) 12/20/2006 9:23:52 PM (UTC). This is an informational message only; no user action is required. 2006-12-20 16:23:16.98 Server Registry startup parameters: 2006-12-20 16:23:17.00 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf 2006-12-20 16:23:17.00 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG 2006-12-20 16:23:17.00 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf 2006-12-20 16:23:17.23 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2006-12-20 16:23:17.23 Server Detected 2 CPUs. This is an informational message; no user action is required. 2006-12-20 16:23:17.93 Server Set AWE Enabled to 1 in the configuration parameters to allow use of more memory. 2006-12-20 16:23:19.65 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. 2006-12-20 16:23:22.07 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required. 2006-12-20 16:23:23.21 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required. 2006-12-20 16:23:23.48 Server Database Mirroring Transport is disabled in the endpoint configuration. 2006-12-20 16:23:23.79 spid5s Starting up database 'master'. 2006-12-20 16:23:25.01 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 2006-12-20 16:23:26.17 spid5s SQL Trace ID 1 was started by login "sa". 2006-12-20 16:23:26.37 spid5s Starting up database 'mssqlsystemresource'. 2006-12-20 16:23:27.93 spid9s Starting up database 'model'. 2006-12-20 16:23:27.95 spid5s Server name is 'KSDBT01'. This is an informational message only. No user action is required. 2006-12-20 16:23:29.06 spid9s Clearing tempdb database. 2006-12-20 16:23:29.54 Server A self-generated certificate was successfully loaded for encryption. 2006-12-20 16:23:29.62 Server Server is listening on [ 'any' <ipv4> 1433]. 2006-12-20 16:23:29.62 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalMSSQLSERVER ]. 2006-12-20 16:23:29.62 Server Server local connection provider is ready to accept connection on [ \.pipesqlquery ]. 2006-12-20 16:23:29.64 Server Server is listening on [ 127.0.0.1 <ipv4> 1434]. 2006-12-20 16:23:29.64 Server Dedicated admin connection support was established for listening locally on port 1434. 2006-12-20 16:23:29.68 Server SQL Server is now ready for client connections. This is an informational message; no user action is required. 2006-12-20 16:23:32.56 spid9s Starting up database 'tempdb'. 2006-12-20 16:23:32.67 spid13s Starting up database 'msdb'. 2006-12-20 16:23:32.67 spid12s Starting up database 'test'. 2006-12-20 16:23:32.67 spid14s Starting up database 'bravoAztecnology'. 2006-12-20 16:23:32.67 spid15s Starting up database 'bravoKNE'. 2006-12-20 16:23:32.67 spid16s Starting up database 'bravoKNS'. 2006-12-20 16:23:32.67 spid17s Starting up database 'bravoKNSBelgium'. 2006-12-20 16:23:32.68 spid18s Starting up database 'bravoKNSCanada'. 2006-12-20 16:23:32.68 spid19s Starting up database 'bravoKNSEngland'. 2006-12-20 16:23:34.79 spid20s The Service Broker protocol transport is disabled or not configured. 2006-12-20 16:23:34.81 spid20s The Database Mirroring protocol transport is disabled or not configured. 2006-12-20 16:23:35.01 spid12s Starting up database 'bravoKNSKennedy'. 2006-12-20 16:23:35.20 spid17s Starting up database 'bravoKNSSuperior'. 2006-12-20 16:23:35.35 spid13s Starting up database 'bravoKNSSuperiorSS'. 2006-12-20 16:23:35.48 spid19s Starting up database 'stamp'. 2006-12-20 16:23:35.83 spid20s Service Broker manager has started. 2006-12-20 16:23:38.59 spid14s Starting up database 'KNSSpecial'. 2006-12-20 16:23:39.31 spid18s Starting up database 'knsRPCS'. 2006-12-20 16:23:39.39 spid14s Analysis of database 'KNSSpecial' (16) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required. 2006-12-20 16:23:43.03 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required. 2006-12-20 16:23:43.03 spid5s Recovery is complete. This is an informational message only. No user action is required. 2006-12-20 16:23:50.95 spid51 Using 'xpsqlbot.dll' version '2005.90.1399' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required. 2006-12-20 16:23:55.85 spid51 Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required. 2006-12-20 16:23:57.10 spid51 Using 'xplog70.dll' version '2005.90.1399' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required. 2006-12-20 16:24:00.02 Logon Error: 18456, Severity: 14, State: 16. 2006-12-20 16:24:00.02 Logon Login failed for user 'PRIsqlservice'. [CLIENT: 172.16.9.2] 2006-12-20 16:24:00.06 Logon Error: 18456, Severity: 14, State: 16. 2006-12-20 16:24:00.06 Logon Login failed for user 'PRIsqlservice'. [CLIENT: 172.16.9.2] 2006-12-20 16:24:01.06 Logon Error: 18456, Severity: 14, State: 16. 2006-12-20 16:24:01.06 Logon Login failed for user 'PRIsqlservice'. [CLIENT: 172.16.9.2] 2006-12-20 16:24:01.07 Logon Error: 18456, Severity: 14, State: 16. 2006-12-20 16:24:01.07 Logon Login failed for user 'PRIsqlservice'. [CLIENT: 172.16.9.2] 2006-12-20 16:24:03.84 Logon Error: 18456, Severity: 14, State: 16. 2006-12-20 16:24:03.84 Logon Login failed for user 'PRIsqlservice'. [CLIENT: 172.16.9.2] 2006-12-20 16:24:03.85 Logon Error: 18456, Severity: 14, State: 16. 2006-12-20 16:24:03.85 Logon Login failed for user 'PRIsqlservice'. [CLIENT: 172.16.9.2] 2006-12-20 16:24:03.96 Logon Error: 18456, Severity: 14, State: 16. 2006-12-20 16:24:03.96 Logon Login failed for user 'PRIsqlservice'. [CLIENT: 172.16.9.2] 2006-12-20 16:24:03.98 Logon Error: 18456, Severity: 14, State: 16. 2006-12-20 16:24:03.98 Logon Login failed for user 'PRIsqlservice'. [CLIENT: 172.16.9.2] 2006-12-20 16:24:41.41 Logon Error: 18456, Severity: 14, State: 16. 2006-12-20 16:24:41.41 Logon Login failed for user 'PRIsqlservice'. [CLIENT: 172.16.9.2] 2006-12-20 16:24:41.41 Logon Error: 18456, Severity: 14, State: 16. 2006-12-20 16:24:41.41 Logon Login failed for user 'PRIsqlservice'. [CLIENT: 172.16.9.2]
I am running SQL Server 2005 SP2 on Windows Server 2003.
I am continously geting below error.Please tell me how to avoid this error.and How I can supress this error popping into error logs?
Date 3/31/2008 8:46:58 AM Log SQL Server (Current - 3/31/2008 8:48:00 AM)
Message Error: 18456, Severity: 14, State: 11.
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: xx.xx.xx.xx]
I am not using any linked server or replication.I have Sharepoint services connecting to this database.I want to learn step to troubleshoot this error.I have gone through many link during search but not found anything relevant.
Can you please suggest me troubleshooting steps so I can narrow down this problem and solve it.
Over the weekend my C drive got full due to my transaction log files ballooning up.
At that point none of my users were able to log into their the VB application and enter data.
I freed up some disk space, and then the users were able to log in fine, except for a certain column variable(aggregate) values were negative.
I deattached the DBs and Ldf files and made copies of them on to a test envirnoment. Within the test environment, I ran SQL Query Analyzer with SQL statments that did give me the aggregate values as negative. This matched my VB application values aswell.
DBCC CHECKDB -- no errors
DBCC DBREINDEX -- no errors
Our programming vendor tells us the DBs are corrupt.
I have a SQL 2005 SP1 test server running Developer Edition on top of Windows Server 2003 SP1. We're testing out a 3rd party application that is using Windows Authentication to connect to SQL 2005. The SQL Error Log is saturated with the error message listed in the subject line. The text accompanying the message alternates between "Login failed for user 'MYDOMAINTESTDA1$'. [CLIENT: <named pipe>]" and "Login failed for user 'MYDOMAINTESTDA1$'. [CLIENT: xxx.xxx.xxx.xxx]".
There are two strange parts to this: 1) The application appears to be working fine on the surface, and, 2) The MYDOMAINTESTDA1$ account mentioned in the error text is not the user account that we are using to connect the application to SQL 2005. TESTDA1 is the server name that the 3rd party software is running remotely from.
I've looked up "error state 11" using the following resource:
When I try to make a connection to my SQL Database I get the following error in the ERRORLOG file for SQL:
Error: 18456, Severity: 14, State: 5 Login failed for user 'xxx'. [CLIENT: <local machine>]
I can verify that the user 'xxx' does exist and has the proper password in Active Directory. This error did not start happening until I re-installed SQL Server 2005 (I had another issue that has been resolved). I cannot pin-point this problem. Any help???