Announcement

Collapse
No announcement yet.

MSQL server and Windows Authenticaton

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MSQL server and Windows Authenticaton

    I'm having trouble connecting to a Microsoft SqlServer 2005 database with a windows account (including domain). If I use <domainname><backslash><UserName> in the UserName field. I always get a connection error. Caused by: java.sql.SQLException: Login failed.

    When I use a local account I can read the database ??

    Can or should I specify the domainname before the username seperated with a backslash ?

    Post edited by: huubvandemortel, at: 05/02/2007 03:24 cannot type a backslash as backslash !!!

    Post edited by: huubvandemortel, at: 05/02/2007 03:25

  • #2
    Re:MSQL server and Windows Authenticaton

    Someone any idea ????

    org.mule.providers.FatalConnectException: ReconnectStrategy "org.mule.providers.SingleAttemptConnectionStrateg y" failed to reconnect receiver on endpoint "jdbc://query"
    at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:34 )
    at org.mule.providers.AbstractConnectionStrategy.conn ect(AbstractConnectionStrategy.java:67)
    at org.mule.providers.AbstractMessageReceiver.start(A bstractMessageReceiver.java:396)
    at org.mule.providers.AbstractConnector.registerListe ner(AbstractConnector.java:518)
    at org.mule.impl.model.AbstractModel.registerListener s(AbstractModel.java:221)
    at org.mule.impl.model.AbstractModel.start(AbstractMo del.java:353)
    at org.mule.MuleManager.start(MuleManager.java:730)
    at org.mule.config.builders.MuleXmlConfigurationBuild er.configure(MuleXmlConfigurationBuilder.java:207)
    at org.mule.config.builders.MuleXmlConfigurationBuild er.configure(MuleXmlConfigurationBuilder.java:194)
    at com.webreach.mirth.server.Mirth.startMule(Mirth.ja va:163)
    at com.webreach.mirth.server.Mirth.restartMule(Mirth. java:145)
    at com.webreach.mirth.server.Mirth.run(Mirth.java:101 )
    Caused by: org.mule.providers.FatalConnectException: ReconnectStrategy "org.mule.providers.SingleAttemptConnectionStrateg y" failed to reconnect receiver on endpoint "jdbc://query"
    at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:34 )
    at org.mule.providers.AbstractConnectionStrategy.conn ect(AbstractConnectionStrategy.java:67)
    at org.mule.providers.AbstractMessageReceiver.connect (AbstractMessageReceiver.java:353)
    at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:32 )
    ... 11 more
    Caused by: org.mule.providers.ConnectException: Initialisation Failure: Login failed for user

    Comment


    • #3
      Re:MSQL server and Windows Authenticaton

      Your login/pass is incorrect:

      org.mule.providers.ConnectException: Initialisation Failure: Login failed for use

      Comment


      • #4
        Re:MSQL server and Windows Authenticaton

        I know see start of the topic ....

        The problem is windows authentication (with Active Directory) and Sql Server authentication....

        a login like
        Code:
        <domainname>\\<username>
        does not seem to work.

        Post edited by: huubvandemortel, at: 05/07/2007 06:28

        Comment


        • #5
          Re:MSQL server and Windows Authenticaton

          Sorry. I answered too quick.

          As the problem is related to jdbc access, perhaps using a Java generic dbmanager software as Aqua Data Studio, dbConnector ,etc.. you could get what is the right user/password.

          On the other hand, you can test with [email protected] syntax.

          Comment

          Working...
          X