Please help...Not able to connect SQL server.

[jjonney]

Hello All,

I need your help.
I am getting the following error when ever I am trying to create a DSN on CF
administrator to connect SQL server database.

Floowing error is displayed:
Connection verification failed for data source: cf_var
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Could not establish
a connection using integrated security: No LoginModules configured for
JDBC_DRIVER_01
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver]Could not establish a connection using integrated security: No
LoginModules configured for JDBC_DRIVER_01

[SQLMenace]

Looks like the SQL server is set for windows authentication only
right click on the server go to security and you can change it there

[jjonney]

I have selected SQL server and Windows authentication radio button.Still it isn't working for me.

[SQLMenace]

what about your connection string? it looks like you are trying to connect by
using Windows Authentication (Could not establish a connection using integrated
security:)
Can the CF machine see the SQL server is it on the same domain and if not is
there a thrust between the 2 domains?

[jjonney]

Everything is local on my machine.I am not familiar with connection string ,Do
I have to specify anything there.
You said:
it looks like you are trying to connect by using Windows Authentication (Could
not establish a connection using integrated security
Please let me know what this means and what is the solution to it.

[sdupre]

You probably are best off using the 3.5 drivers on the /support site which have
the DDJDBCAuth03.DLL.

[url]http://www.macromedia.com/go/42dcb10a[/url]

Then you need to add "AuthenticationMethod=Type2" to the URL.

As you'll read in the technote, the MS SQL Server datasource type has a bug in
that it doesn't use the "Connect String" arguments (where you'd normally put
"AuthenticationMethod=").

The technote shows the workaround using the "Other" datasource.

Stephen Dupre
Adobe Systems, Inc.

[The ScareCrow]

You did not read SQLMenace's reply correctly

At the moment you only have windows authentication
You need to also have sql authentication, so you can create a login and use
that to access the database.

Ken

[jjonney]

All,

Thanks .I was able to resolve the issue .I had uninstall and reinstall SQL server again having username sa and no password.

[The ScareCrow]

You have now told the world that you have an unsecure sql server.

I would adivse that you set a password for the sa user as soon as possible.

Ken