Results 1 to 13 of 13
  1. #1
    Join Date
    Mar 2008
    Posts
    7

    Login failed for the user'xxxx'(Microsoft SQL Server 2005. Error:18456)

    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.

    thanks,
    ravi kishore.ch

  2. #2
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    can you not remember the 'sa' account password you set when installing ? - have you tried sa account and blank password
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

  3. #3
    Join Date
    Mar 2008
    Posts
    7

    Re:

    i tried with sa and its password, it is working, but i need to login to the database using windows authentication as it is required by the application

    thanks,
    ravikishore

  4. #4
    Join Date
    Mar 2008
    Posts
    1
    Hello,
    i am using sql server 2005 and installed in mixed mode withe user name sa and password #sa
    and from Sql Server Surface Area Configuration i select the Using both TCP/IP and named pipes for remote settings under Database Engine
    version is [@@version]
    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

    My os is Xp with service pack2

    I am using asp.net 2.0 and using connection string in web.config
    <configuration>
    <appSettings>
    <add key="brian" value="server=SOURAV;uid=sa;pwd=#sa;database=test"/>
    </appSettings>

    SOURAV is my local Database Server name.

    I can connect server with the user name password from the SQL Server Management Studio,
    But the problem arise when i hit con.open() from asp.net page

    error message show login fauled for user 'sa'

    Please help how to solve,
    Thanks in advance
    Sourav

  5. #5
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Hi

    Quote Originally Posted by chravikishore
    i tried with sa and its password, it is working, but i need to login to the database using windows authentication as it is required by the application

    thanks,
    ravikishore
    Does the user that you are trying to login with exist in the user list of sql server ??
    Greetz Marvels -^.^-
    Developments : VB4 Through .Net; Basic; DOS ; CNC ; Sinclair
    Databases : SQL Server Through 2005; Access 3 Through 2003 ; Oracle 8 & 9.i ;
    OS : Win 3.11 Through XP ; NortonComander ; DOS

  6. #6
    Join Date
    Mar 2008
    Posts
    7

    Re

    yes it is in the list of SQL Server users list


    thanks,
    ravi kishore.ch

  7. #7
    Join Date
    Mar 2008
    Posts
    7
    hi,
    your error message is not giving me full data however try the following
    add your asp.net user to administrators group and reset the IIS using resetiis utility then you may not get the problem
    if the problem exists try the following
    add the key like this
    <add key="brain" value="server=SOURAV;User Id=sa;Password=#sa; database=test;Connection Reset=FALSE;Max Pool Size=500;Connection Timeout=360"/>

    i hope this may be useful to you.


    thanks,
    ravi kishore.ch
    Last edited by chravikishore; 03-04-08 at 09:54.

  8. #8
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,554
    First of all, using sa for your application is just an invitation to hackers to download all of your data, and take over your server. Look up SQL Injection attacks for more information.

    As to the error, look at the state passed with the error number, and cross reference here: http://blogs.msdn.com/sql_protocols/...21/536201.aspx

  9. #9
    Join Date
    May 2007
    Posts
    49
    Also make sure that TCP / IP and Named Pipes are enabled in
    Sql Server Configuration Manager.
    Mihir Mehendale
    DB Team @ Clarion
    Clarion Technologies
    (SEI CMMI Level 3)
    Pune, India
    www.clariontechnologies.co.in
    www.vEmployee.com

  10. #10
    Join Date
    Mar 2008
    Posts
    7
    Quote Originally Posted by mihirclarion
    Also make sure that TCP / IP and Named Pipes are enabled in
    Sql Server Configuration Manager.
    both are enabled

  11. #11
    Join Date
    Mar 2008
    Posts
    7
    hi,
    how ever finally i got the solution for the problem myself.

    Thanks,
    Ravi kishore.ch

  12. #12
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,138
    Care to share your solution with us - it will certainly be helpful for future readers
    George
    Home | Blog

  13. #13
    Join Date
    Mar 2014
    Posts
    10

    how to solve error 18456 sql server 2005

    hi
    need help.
    how to resolve this error. i cant login into windows mode and authentication mode.
    gave error 18456 .
    can someone help me ?

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •