SQL State S0001 error code 18456 for named sql server : jdbc errors RRS feed

  • Question

  • When I try to connect to named instance of SQL Server 2005,the error I get it
    The database user has data reader and writer rights.
    I have used sqljdbc4.jar

    url is jdbc:sqlserver://SERVER_NAME:1433;databaseName=DATABSE_NAME;user=USERNAME;password=USER_PASSWORD

    I also tried using the jtds driver and I get State 28000 error

    Sunday, August 9, 2009 2:34 PM


All replies

  • Hi there

    18456 is login failed, have a look here.

    Troubleshooting: Login Failed for User 'x'

    Perhaps you are connecting to the wrong server/database?


    This posting is provided "AS IS" with no warranties.
    Monday, August 10, 2009 7:13 AM
  • You might want to make sure that the instance is specified.

    For example, when connecting to SQL Server 2008 using DBVisualizer (free) with SingleSignOn authentication, you need to use the jTDS driver AND you have to specify the instance on the server in order to connect.

    Instance-less connection requests are rejected with the same error message as wrong password:

    java.sql.SQLException Error Code: 18456

    Wednesday, April 29, 2015 11:13 PM
  • I've the same issue but not wihtin access, but a java program 

    with mySQL it work like a charm and I start to hate ms sql server .... 

    because I'm loosing my time for something basic 
    a simple connection 

    Friday, May 27, 2016 1:34 PM