Error 18456 State 11 -- Login Failed For Wrong User
Apr 3, 2008
A user is trying to connect to a server via windows authentication from SQL management studio on her desktop.
The log file on the server gives:
Login failed for user: domain1user1
Error : 18456, Severity: 14, State: 11
The strange thing is that the user in the error above is not the user she's trying to connect as (domain2user2, say).
user2 can remote desktop to the server and log in there.
I know this state implies "Valid login but server access failure".
Has anyone run into this, and what more information would be useful to know? Thanks!
I get this error when I try to connect to my SQL Server with JDBC:
Excepcion en MyPool Pool.getNewConnection() [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open database "lituania" requested by the login. The login failed.
can someone help me with this error. Error: 18456, Severity: 14, State: 16 Login failed for user 'NT AUTHORITYSYSTEM' [CLIENT:<local machine>] I've found several Threads but not with the NT AUTHORITYSYSTEM.
We recently upgraded to SQL 2005 from SQL 2000. We have most of our issues ironed out however about every 1 minute there is a message in the Application Event log and the SQL log that states:
EVENT ID 18456 Login Failed for the users DOMAIN/ACCOUNT [CLIENT: <local machine>]
This is a state 16 message which I thought meant that the account does not have access to the default database. The account is actually the account that the SQL services run under.
Any ideas? We can't seem to figure this one out. We actually upgraded to 2005 from 2000 and had an error appear after every reboot that prevented the SQL Agent from running(This application has failed to start because GAPI32.dll was not found. Re-installing the application may fix this problem.) We did a full uninstall of SQL and reinstalled fresh and restored the databases from .bak files and that is when the EVENT ID 18546 started occuring every minute.
We don't have any SQL heavy hitters here so please be detailed with any possible solutions. That you very much for any help you can provide!
I get this error when trying to connect. I'm using the sa id and password for all of my odbc connections. It fails when trying to connect to this one but it's ok on a couple of others I've set up with the same id etc. Where is this "" coming from and how to avoid it in the future?
I've removed and recreated the connection to be sure that I didn't actually type that in as the id....hey it's monday...it could happen.
I just upgraded SQL Server 2000 to 2005 without any errors. Afterwards, I tried registering with sa and it failed. I registered with another sysadmin login to get into most of my databases, but I need sa to work for my backup software Idera SQLSafe to login to the database.
Does anyone have any experience or recommendations? I know my password is correct.
Last night I setup my MOSS 2007 server and SQL 2005, I got everything working fine in short order.
I had forgotten to look for updates for SQL 2005 so i decided I would run Windows Update.
SQL Server 2005 Critical Update for SQL Server 2005 Service Pack 2 (KB 934458)
Tuesday, March 04, 2008 Microsoft Update
SQL Server 2005 Microsoft SQL Server 2005 Service Pack 2 (KB 921896)
Those two updates were applied, then after a reboot I began getting the login failed error.
I can login using windows authentication as DOMAINAdministrator, I can also login as SA, but i am trying to figure out why it is denying me logins as DOMAINSharepoint
Has anybody had prior experience with this or know what the deal is?
Please help I keep getting this message when I log on to my data base. Not sure what state 1 relates too
TITLE: Connect to Server ------------------------------ Cannot connect to <server_name> ------------------------------ ADDITIONAL INFORMATION: Login failed for user <user_name>. (Microsoft SQL Server, Error: 18456)
------------------------------ BUTTONS: OK ------------------------------ Server Name: <server~name>Error Number: 18456 Severity: 14 State: 1 Line Number: 65536
hi, i am getting the following error message while i am trying to login to the SQL Server 2005 on my vista laptop. i installed the server with dual authentication modes.
Login failed for the user'xxxx'(Microsoft SQL Server 2005. Error:18456)
if you have solution for my problem please send a reply as early as possible.
I am trying to create a linked server between 2 SQL Server 2005 boxes. When I create the linked server I specify a login for the connection. The strange part is that I get the following error when it goes to test the connection:
The test connection to the linked server failed Login failed for user 'Domainuser'. (Microsoft SQL Server, Error: 18456)
I can use the SQL mangement studio to conenct to the database using this same login. The login has all the server roles assigned to it also.
Can anyone shed some light as to what may be the problem?
I wanted to check the asymmetric key option in sql 2005. I copied the books online code for creating a asymmetric key and then used this key for creating a login. Now when I try to login without entering any password I am receiving 18456 error. I would like to know what I am missing here. If I use CREATE LOGIN from asymmetric key or certificate how do I login and with what credentials. Do I need to provide any password.CREATE ASYMMETRIC KEY PacificSales09 WITH ALGORITHM = RSA_2048 ENCRYPTION BY PASSWORD = 'bmsA$dk7i82bv55foajsd9764'; GO
CREATE LOGIN asm FROM ASYMMETRIC KEY PacificSales09;
I am running several instances of SQL Server 2005 sp2 on a W2k3 sp2 box (member server).
This morning, I installed reporting services to one of my instances and shortly after noticed I was getting the following two messages in my SQL Server log file:-
08/08/2007 11:05:03,Logon,Unknown,Login failed for user 'DOMAINDOMCONTROLLER$'. [CLIENT: xxx.xxx.xxx.xxx] 08/08/2007 11:05:03,Logon,Unknown,Error: 18456, Severity: 14, State: 16.
The above entries were each repeated 6 times every 15 minutes but with State 11. I created a logon for the above, and now get the above messages (state 16) repeated 3 times every 15 minutes!
SQL2000 SP4 (SQL and Windows authentication) on Win2000SP4. Event ID 17055 (18456: Login failed for user 'sa'.) is being logged at an average of 20 times an hour. Tried to run SQL Profiler but it no trace information on the source (host, ip or application) of the failed login. Some forums suggest to unplug the server from network to know if its a local or networked issue but this is not possible in my case. Acquiring firewall/router logs from Network team is a headache. Any help on pinpointing what/where is this failed login coming from is very much appreciated.
Hi, I have a service using SQL 2005 Express database, the service is started automatically on system startup, most of the times it can logon to the database successfully, however, sometimes, I got the following error:
"Error: 18456, Severity: 14, State: 16"
Any suggestions?
Thanks in advance!
Yuxi
2006-11-22 11:09:49.90 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-11-22 11:09:49.92 Server (c) 2005 Microsoft Corporation. 2006-11-22 11:09:49.92 Server All rights reserved. 2006-11-22 11:09:49.93 Server Server process ID is 1956. 2006-11-22 11:09:49.93 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'. 2006-11-22 11:09:49.93 Server This instance of SQL Server last reported using a process ID of 1952 at 11/22/2006 11:08:07 AM (local) 11/22/2006 7:08:07 PM (UTC). This is an informational message only; no user action is required. 2006-11-22 11:09:49.95 Server Registry startup parameters: 2006-11-22 11:09:49.95 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf 2006-11-22 11:09:49.95 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG 2006-11-22 11:09:49.95 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf 2006-11-22 11:09:49.98 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2006-11-22 11:09:50.00 Server Detected 4 CPUs. This is an informational message; no user action is required. 2006-11-22 11:09:50.95 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-11-22 11:09:50.96 Server Database mirroring has been enabled on this instance of SQL Server. 2006-11-22 11:09:50.96 spid4s Starting up database 'master'. 2006-11-22 11:09:51.06 spid4s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 2006-11-22 11:09:51.18 spid4s SQL Trace ID 1 was started by login "sa". 2006-11-22 11:09:51.23 spid4s Starting up database 'mssqlsystemresource'. 2006-11-22 11:09:51.25 spid4s The resource database build version is 9.00.2047. This is an informational message only. No user action is required. 2006-11-22 11:09:51.59 spid8s Starting up database 'model'. 2006-11-22 11:09:51.60 spid4s Server name is 'TestMachineTestSQLServer'. This is an informational message only. No user action is required. 2006-11-22 11:09:51.60 spid4s Starting up database 'msdb'. 2006-11-22 11:09:51.93 Server A self-generated certificate was successfully loaded for encryption. 2006-11-22 11:09:51.93 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalTestSQLServer ]. 2006-11-22 11:09:51.93 Server Server local connection provider is ready to accept connection on [ \.pipeMSSQL$TestSQLServersqlquery ]. 2006-11-22 11:09:51.93 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required. 2006-11-22 11:09:51.95 Server SQL Server is now ready for client connections. This is an informational message; no user action is required. 2006-11-22 11:09:52.12 spid8s Clearing tempdb database. 2006-11-22 11:09:53.12 spid8s Starting up database 'tempdb'. 2006-11-22 11:09:53.21 Logon Error: 18456, Severity: 14, State: 16. 2006-11-22 11:09:53.21 Logon Login failed for user 'sa'. [CLIENT: <local machine>] 2006-11-22 11:09:53.70 spid4s Recovery is complete. This is an informational message only. No user action is required. 2006-11-22 11:09:53.70 spid11s The Service Broker protocol transport is disabled or not configured. 2006-11-22 11:09:53.70 spid11s The Database Mirroring protocol transport is disabled or not configured. 2006-11-22 11:09:54.09 spid11s Service Broker manager has started. 2006-11-22 11:10:19.26 spid51 Starting up database 'TestDatabase'. 2006-11-22 11:10:19.42 spid51 Recovery is writing a checkpoint in database 'TestDatabase' (5). This is an informational message only. No user action is required. 2006-11-22 11:18:08.92 spid51 Starting up database 'TestDatabase'.
I then try to run the same app from the client computer, it gives me:
Login failed for user 'LAPTOPGuest'.
After looking up the web for solution, I found that I can test the connection from the HOST computer in this way:
C:Documents and Settingskit>sqlcmd -E -S laptopsqlexpress 1> 2>
The test is successful
Now I run the same command on the CLIENT computer
C:Documents and SettingsKit>sqlcmd -E -S laptopsqlexpress Msg 18456, Level 14, State 1, Server LAPTOPSQLEXPRESS, Line 1 Login failed for user 'LAPTOPGuest'.
Now I can sure that from the client computer it cannot make a connection to it, then I look at the errorLog from my host computer
2006-08-13 21:41:00.34 Logon Error: 18456, Severity: 14, State: 11. 2006-08-13 21:41:00.34 Logon Login failed for user 'LAPTOPGuest'. [CLIENT: 192.168.0.5] 2006-08-13 21:45:10.64 Logon Error: 18456, Severity: 14, State: 11. 2006-08-13 21:45:10.64 Logon Login failed for user 'LAPTOPGuest'. [CLIENT: 192.168.0.5] 2006-08-13 21:48:41.80 Logon Error: 18456, Severity: 14, State: 11. 2006-08-13 21:48:41.80 Logon Login failed for user 'LAPTOPGuest'. [CLIENT: 192.168.0.5]
Now I know it is actually Error: 18456, Severity: 14, State: 11.
From this site : http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
11 and 12
Valid login but server access failure
It tells the connection string and SQL Express seem to be set up properly but the server access failed the remote connection
I have previously had SQL Server 2000 installed. I uninstalled SQL 2000 before I install SQL express but somehow the SQL Server Service Manager is still running at startup, and C:Program FilesMicrosoft SQL Server80 and its files are still exist after uninstallation..... Could this be a problem?
The Knowledge base suggestion on "enabling remote connection" is very simple and I do not understand why it is so difficult to me just to make a remote connection test work..... please, I need your help.
Recently, one of my clients began receiving this error. My team gave them sysadmin permissions, but this is terrible practice. I have read into disablying simple file sharing, but I don't even think I have the option to do it. I look in mycomputer > tools > view and don't see any option for this. Besides, the problem just started occuring recently, within the last week. The server is a cluster with veritas clustering and the edition is sql server 2000. Has anybody ever had a problem like this and have a good fix? Thanks for any help in advance... -Kyle
i'm using the Enterpirse library logger to write logs into a database. When choosing connection string i choose the database i want in the "connection properties" dialog box and push 'Test connection' button. everything goes well.
then i open the SQL Server Management studio express and connect to the databse to check some things, from that point on , when i push the 'Test Connection' button in the Enterprise library i get the error:
"cannot open user default database. Login failed. login failed for user My'server/MyuserName'"
even when i close the sql server manager , it is still stuck - the connection test doesn't work anymore.... it only work when i restart the computer.
Hi, Im getting this error when attempting to retrieve data from an sql database.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database requested in login 'projectAllocations'. Login fails. Login failed for user 'sa'.
Source Error:
Line 13: objConn = New SqlConnection( "Server=LAB303-066NETSDK; Database=projectAllocations; User ID=sa;Password=mypassword") Line 14: objCmd = New SqlCommand("SELECT * FROM project_descriptions", objConn) Line 15: objConn.Open() Line 16: objRdr = objCmd.ExecuteReader() Line 17: While objRdr.Read()
Hi when i try and open a database in sql server management studio i get the error "Cannot open user default database. Login failed. Login failed for user 'DOMAINUser'. (.Net SqlClient Data Provider)", what can i do to rectify this, i have googled around and still havent found no answers.
Hey Microsoft: this affects development that will eventually sell a lot of seats on SharePoint Server 2007. If you guys and gals can't straighten out this mess, you can't expect custom solutions with custom web parts. So pay attention for your own good. Yes, SPS 2007 is what this is all about. I've created simpe web parts and deployed them, same VS 2005, but I need local development and debugging for more complex stuff. I'm really disappointed that you have no solution for this problem.
I've seen other posts on this, but the result seems to be the same: if you fix it, it's by accident, not by design.
1. I created a blank ASP.NET web site
2. I added a web part manager
3. I added a web part zone
I get the error described above. I have no idea why SQL Server settings are so screwed up.
I've tried all the stuff in the other posts - security settings, command line installation, etc. None of those worked.
The default template(s) don't copy anything into App_Data, nor create an empty folder. I don't know why that is. I have other web sites working just fine, but they use remote SQL databases, or local ones I created, and didn't need profile management (no forms authentication, no web parts, no web zones).
I've also started out with a local database, using SQL Authentication, later moving it to a remote server, and never had any problems. The SQL Server developer edition and Express seem to work just fine. I can also debug stored procs when the .mdf is in App_Data. So the problem isn't one of connectivity.
What would cause the default screw-up? This would seem to point from all directions to a problem with Visual Studio (2005)? The installation is defalt - perhaps some extras included (copy local), but nothing unusual. AJAX for ASP.net is installed, but not used in the above "default web site" trial. Likewise Syncfusion's tools, which work fine on other developer workstations at this same location, all of which are from the same image (purchased at the same time & imaged). That web parts work on other boxes, running all the same management tools (anti-virus, remote sys admin/sms etc.) makes none of those suspect.
I think Microsoft needs to have a clean problem solution and publish it. SP1 certainly doesn't fix it. What's worse is the stupid, lame error message. "I can't open the default database". Well, what did you try? What do you think the default is? What settings are you using? Why is there no debugging information other than the usual worthless trace information showing it's all deep within the ProviderBase and SqlClient namespace code? How is that supposed to be helpful?
If anyone has anything solid, not guesses, I'd like to know.
Many a times see the below error in SQL Error log.
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
Is this something to do here?
Note: If I run the below statement I know that the SQL Error log entry will go off, but wanted to know the real significance of this error?
CREATE LOGIN [NT AUTHORITYANONYMOUS LOGON] FROM WINDOWS
I am trying to connect to a remote SQL server via Management Studio. I am using the windows credentials I use to log into the computer but when I enter the same domainusername and password I get error 18456. I check the logs and see it is a state 6 error. After checking http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx I see that means Attempt to use a Windows login name with SQL Authentication
Is it possible for me to access a SQL server remotely?
This error has come up time and again and I can't seem to find a solution.
Specs: SQL Server 2005 v9.00.3054 on x64, Windows Server 2003 SP2
The user is a member of an active directory group. When he connects from his workstation via Management Stuidio, the error is:
Login failed for user '<domain><user>'. [CLIENT: xx.xx.xx.xxx]
I've dropped and re-created the login for the group, but to no avail. I've tried
SELECT * FROM sys.server_principals and I get a valid entry <domain>/<user> 81 0x0105... G WINDOWS_GROUP 0 2008-04-04 13:05:00.667 2008-04-04 13:05:00.673 <dbname> us_english NULL
I've verified that the user is a db_owner in the database and that this database is the default for the group.
I also tried SELECT endpnt.name,
suser_name(perms.grantee_principal_id) as grantee_principal,
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.
Since some days, i have this problem : i changed RTCcomponentService password, and now, when the SQL Server RTC service start (correctly, with network service), i have this log error message : Login failed for user 'CGAUPARTCComponentService'. [CLIENT: <named pipe>] ErrorReportingManager: Error raised, major=184, minor=56, severity=14, attempting to create sym
so, the service run with network (nt authority) correctly, but i have this error message. I think that the sql server database connect with rtccomponentservice old password. How I can change the password on this connection ? or what is de default password for RTCcomponentService ?
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]
