MSQL server and Windows Authenticaton

[huubvandemortel]

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

[huubvandemortel]

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

[albertosaez]

Re:MSQL server and Windows Authenticaton

Your login/pass is incorrect:

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

[huubvandemortel]

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

<domainname>\\<username>

does not seem to work.

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

[albertosaez]

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 username@domain syntax.