Login failed for user 'x', Error: 18456
in [Programming SQL]
|
From: Jeff on 26 Feb 2010 09:58 Hi I lost my last hair... Still struggeling with this problem In my subnet I have a win2k3 machine with a working sql server 2005 express installation. I cannot use it anymore, because it's a 180-days trail version of win2k3 enterprise. And I have trouble dowloading win2k3 trail again, not easy to find. Suppose MS wants us to use win2k8 instead. But my "server" is a 450MHz computer, to slow for win2k8 - This is only a home office thing. Something I've set up at home. DOn't wants to over invest in hardware etc.. have other things to use my money on.. As long as it works then it's great.... I suppose I've been through all the settings suggested in the article without creating aliases. I created exceptions for ports 4344 and 1344, in addition created exception for sqlbrowser.exe. The installation have remote connections enabled I've been double checking my settings on my winxp machine with the working settings on my win2k3 computer. I didn't spot any major differences there. Only that it uses port 1062 instead of 1344 or 4344 I've double checked the connectingstring, checked if database name, user id and password is correct. Didn't find anything wrong there still I get the login failed for user 'x' in my asp.net application "sloan" <sloan(a)ipass.net> wrote in message news:OQOxzqitKHA.928(a)TK2MSFTNGP04.phx.gbl... > > 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. >>>> >>> >>> >> >> > >
From: sloan on 26 Feb 2010 15:28 Throw this in your asp.net application: private string FindIIdentity() { try { string returnValue = string.Empty; WindowsIdentity ident = WindowsIdentity.GetCurrent(); returnValue = ident.Name; try { returnValue += " on " + System.Environment.MachineName; } catch (Exception ex) { Conditionals.Trace.WriteMessage(ex.Message); } return returnValue; } catch (Exception ex) { Conditionals.Trace.WriteMessage(ex.Message); return "Error Finding Identity"; } } And make a dummy page to output those values. Make sure that account that is running the asp.net account has a sql server login. ............... You can also take asp.net out of the equation and use sqlcmd. http://msdn.microsoft.com/en-us/library/ms188247.aspx http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4 (search for "Microsoft SQL Server 2008 Native Client") (search for "Microsoft SQL Server 2008 Command Line Utilities") Or get http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en You can also "poor man it" by doing to control panel / ODBC / Add New System DSN, and add a new entry.........based on Sql Server. That's a quick and dirty poor man's way to test a sql server connection. "Jeff" <it_consultant1(a)hotmail.com.NOSPAM> wrote in message news:u0ztjQvtKHA.4796(a)TK2MSFTNGP02.phx.gbl... > Hi > > I lost my last hair... Still struggeling with this problem > > In my subnet I have a win2k3 machine with a working sql server 2005 > express installation. I cannot use it anymore, because it's a 180-days > trail version of win2k3 enterprise. And I have trouble dowloading win2k3 > trail again, not easy to find. Suppose MS wants us to use win2k8 instead. > But my "server" is a 450MHz computer, to slow for win2k8 - This is only a > home office thing. Something I've set up at home. DOn't wants to over > invest in hardware etc.. have other things to use my money on.. As long as > it works then it's great.... > > I suppose I've been through all the settings suggested in the article > without creating aliases. I created exceptions for ports 4344 and 1344, in > addition created exception for sqlbrowser.exe. > > The installation have remote connections enabled > > I've been double checking my settings on my winxp machine with the working > settings on my win2k3 computer. I didn't spot any major differences there. > Only that it uses port 1062 instead of 1344 or 4344 > > I've double checked the connectingstring, checked if database name, user > id and password is correct. Didn't find anything wrong there > > still I get the login failed for user 'x' in my asp.net application > > > > > > "sloan" <sloan(a)ipass.net> wrote in message > news:OQOxzqitKHA.928(a)TK2MSFTNGP04.phx.gbl... >> >> 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. >>>>> >>>> >>>> >>> >>> >> >> > >
From: Jeff on 28 Feb 2010 07:04 That method gives my name, not the database user I try to connect to db with. So the string is "Jeff on PC3" (I called my computer PC3, not a very original name)
From: Tibor Karaszi on 28 Feb 2010 13:31 Did you check the things I asked/suggested in my last reply? -- 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:#G4dn4GuKHA.1796(a)TK2MSFTNGP02.phx.gbl... > That method gives my name, not the database user I try to connect to db > with. > > So the string is "Jeff on PC3" (I called my computer PC3, not a very > original name) > > >
From: Jeff on 2 Mar 2010 09:44
Yes, I've checked it, except the SID thing wasn't sure about how to do it. But regarding orphaned users: I've created a dozens users (new database login and create user which I assign to the new login)... All gives the same error : Login failed for user... I've checked many times that database, username etc is spelled correct I found this in the errorlog, maybe it can help find the error: The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies. And this is from errorlog aswell: Server is listening on [ 'any' <ipv4> 4344] any suggestions? "Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> wrote in message news:udX%23ZQKuKHA.5940(a)TK2MSFTNGP02.phx.gbl... > Did you check the things I asked/suggested in my last reply? > > -- > 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:#G4dn4GuKHA.1796(a)TK2MSFTNGP02.phx.gbl... >> That method gives my name, not the database user I try to connect to db >> with. >> >> So the string is "Jeff on PC3" (I called my computer PC3, not a very >> original name) >> >> >> |