Login failed for user 'x', Error: 18456
in [Programming SQL]
|
From: Jeff on 25 Feb 2010 04:54 It says: Login failed for user 'x'. [CLIENT: 192.168.1.183] 2010-02-24 22:24:26.68 Server Server is listening on [ 'any' <ipv4> 4344]. 2010-02-24 22:24:27.15 spid11s The Service Broker protocol transport is disabled or not configured. 2010-02-24 22:24:27.16 spid11s The Database Mirroring protocol transport is disabled or not configured. 2010-02-24 23:45:19.03 Logon Error: 18456, Severity: 14, State: 5. I made an exception for port 4344 in the firewall. I've been google and learned so far that Error 18456, severity 14, state 5 means invalid user. but I think there cannot be anything wrong with the user. I've just created a new user here and the same problem occur with that user to. I typed the username and password correctly.
From: Tibor Karaszi on 25 Feb 2010 07:27 Make sure you connect to the expected database. Make sure the user exists in the database. Make sure the user isn't orphaned, by matching the SID for the user to the SID of the login it is supposed to use (look in syts.server_principals and sys.database_principals). -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Jeff" <it_consultant1(a)hotmail.com.NOSPAM> wrote in message news:#xIfQCgtKHA.4220(a)TK2MSFTNGP05.phx.gbl... > It says: > > Login failed for user 'x'. [CLIENT: 192.168.1.183] > 2010-02-24 22:24:26.68 Server Server is listening on [ 'any' <ipv4> > 4344]. > 2010-02-24 22:24:27.15 spid11s The Service Broker protocol transport > is disabled or not configured. > 2010-02-24 22:24:27.16 spid11s The Database Mirroring protocol > transport is disabled or not configured. > 2010-02-24 23:45:19.03 Logon Error: 18456, Severity: 14, State: 5. > > I made an exception for port 4344 in the firewall. > > I've been google and learned so far that Error 18456, severity 14, state 5 > means invalid user. but I think there cannot be anything wrong with the > user. I've just created a new user here and the same problem occur with > that user to. I typed the username and password correctly. >
From: sloan on 25 Feb 2010 09:07 Quote//I made an exception for port 4344 in the firewall.//EndQuote MSSQL$SQLEXPRESS You need to read the second url (in an earlier post) that I gave you **very **very **very carefully. The port could be "moving" on you. Here it is again. http://msdn.microsoft.com/en-us/library/cc646023.aspx#BKMK_dynamic_ports The short advice is "Try adding the ~~program as a firewall exception, not the port". Please post back your results. "Jeff" <it_consultant1(a)hotmail.com.NOSPAM> wrote in message news:%23xIfQCgtKHA.4220(a)TK2MSFTNGP05.phx.gbl... > It says: > > Login failed for user 'x'. [CLIENT: 192.168.1.183] > 2010-02-24 22:24:26.68 Server Server is listening on [ 'any' <ipv4> > 4344]. > 2010-02-24 22:24:27.15 spid11s The Service Broker protocol transport > is disabled or not configured. > 2010-02-24 22:24:27.16 spid11s The Database Mirroring protocol > transport is disabled or not configured. > 2010-02-24 23:45:19.03 Logon Error: 18456, Severity: 14, State: 5. > > I made an exception for port 4344 in the firewall. > > I've been google and learned so far that Error 18456, severity 14, state 5 > means invalid user. but I think there cannot be anything wrong with the > user. I've just created a new user here and the same problem occur with > that user to. I typed the username and password correctly. >
From: Jeff on 25 Feb 2010 09:30 I turned off the firewall and it didn't have any effect, still the same problem But have some news to report: When I try to login to sql management studio using the user I just created I get this error: Shared Memory Provider, error: 0 - No process is on the other end of the pipe "sloan" <sloan(a)ipass.net> wrote in message news:OY03PPitKHA.4752(a)TK2MSFTNGP04.phx.gbl... > Quote//I made an exception for port 4344 in the firewall.//EndQuote > > MSSQL$SQLEXPRESS > > You need to read the second url (in an earlier post) that I gave you > **very **very **very carefully. > > The port could be "moving" on you. > > > Here it is again. > http://msdn.microsoft.com/en-us/library/cc646023.aspx#BKMK_dynamic_ports > > The short advice is > "Try adding the ~~program as a firewall exception, not the port". > > > Please post back your results. > > > > > > "Jeff" <it_consultant1(a)hotmail.com.NOSPAM> wrote in message > news:%23xIfQCgtKHA.4220(a)TK2MSFTNGP05.phx.gbl... >> It says: >> >> Login failed for user 'x'. [CLIENT: 192.168.1.183] >> 2010-02-24 22:24:26.68 Server Server is listening on [ 'any' <ipv4> >> 4344]. >> 2010-02-24 22:24:27.15 spid11s The Service Broker protocol transport >> is disabled or not configured. >> 2010-02-24 22:24:27.16 spid11s The Database Mirroring protocol >> transport is disabled or not configured. >> 2010-02-24 23:45:19.03 Logon Error: 18456, Severity: 14, State: 5. >> >> I made an exception for port 4344 in the firewall. >> >> I've been google and learned so far that Error 18456, severity 14, state >> 5 means invalid user. but I think there cannot be anything wrong with the >> user. I've just created a new user here and the same problem occur with >> that user to. I typed the username and password correctly. >> > >
From: sloan on 25 Feb 2010 09:56
I've hit issues like these 2 or 3 times in the past years. Each and everytime, when I've went through the URL's I gave you (esp the first one), I found the little thing that I missed. http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/ I don't know what is happening. But my advice is to start at the top of his list, and go down one by one. Dont' assume any step. ~Then if you're still getting bombed, send the details. I'm not trying to be a butt, just saying........his list is pretty comprehensive, and my second url gets past the one missing item on dynamic ports. "Jeff" <it_consultant1(a)hotmail.com.NOSPAM> wrote in message news:eycJkcitKHA.5036(a)TK2MSFTNGP02.phx.gbl... >I turned off the firewall and it didn't have any effect, still the same >problem > > But have some news to report: > When I try to login to sql management studio using the user I just created > I get this error: > Shared Memory Provider, error: 0 - No process is on the other end of the > pipe > > > > > "sloan" <sloan(a)ipass.net> wrote in message > news:OY03PPitKHA.4752(a)TK2MSFTNGP04.phx.gbl... >> Quote//I made an exception for port 4344 in the firewall.//EndQuote >> >> MSSQL$SQLEXPRESS >> >> You need to read the second url (in an earlier post) that I gave you >> **very **very **very carefully. >> >> The port could be "moving" on you. >> >> >> Here it is again. >> http://msdn.microsoft.com/en-us/library/cc646023.aspx#BKMK_dynamic_ports >> >> The short advice is >> "Try adding the ~~program as a firewall exception, not the port". >> >> >> Please post back your results. >> >> >> >> >> >> "Jeff" <it_consultant1(a)hotmail.com.NOSPAM> wrote in message >> news:%23xIfQCgtKHA.4220(a)TK2MSFTNGP05.phx.gbl... >>> It says: >>> >>> Login failed for user 'x'. [CLIENT: 192.168.1.183] >>> 2010-02-24 22:24:26.68 Server Server is listening on [ 'any' <ipv4> >>> 4344]. >>> 2010-02-24 22:24:27.15 spid11s The Service Broker protocol transport >>> is disabled or not configured. >>> 2010-02-24 22:24:27.16 spid11s The Database Mirroring protocol >>> transport is disabled or not configured. >>> 2010-02-24 23:45:19.03 Logon Error: 18456, Severity: 14, State: 5. >>> >>> I made an exception for port 4344 in the firewall. >>> >>> I've been google and learned so far that Error 18456, severity 14, state >>> 5 means invalid user. but I think there cannot be anything wrong with >>> the user. I've just created a new user here and the same problem occur >>> with that user to. I typed the username and password correctly. >>> >> >> > > |