Eclipse Community Forums: BIRT » MSSQL trusted connection doesn't work

Home » Archived » BIRT » MSSQL trusted connection doesn't work

MSSQL trusted connection doesn't work [message #263718]

Tue, 25 December 2007 08:24

Eclipse User

Originally posted by: ibmer.mail.ru

Hi all.
I have a java program that is converted to a windows service running by
particular domain user. In that service I can connect via trusted
connection to an MSSQL server. But when I try to produce BIRT report which
also should work by a trusted connection it doesn't work. It says:
java.sql.SQLException: Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.
at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDia gnostic.java:367)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java :2217)

As I understand BIRT Engine cannot get a service username. How can I fix
that?

I start BIRT Engine this way:

config = new EngineConfig();
String engHome =
configProps.getProperty(ICommonConst.engHomeParam);
config.setEngineHome(engHome);

config.setLogConfig(engHome + "logs", Level.ALL); //todo
set to Level.error

Platform.startup(config);
IReportEngineFactory factory = (IReportEngineFactory)
Platform

createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_EN GINE_FACTORY);
birtEngine = factory.createReportEngine(config);

The BIRT_HOME is a separate directory outside the calling program.
I placed the ntlmauth.dll in system path so it is not a problem of missing
dll.
Any guesses?

Re: MSSQL trusted connection doesn't work [message #263731 is a reply to message #263718]

Tue, 25 December 2007 19:56

Eclipse User

The cause of this error is that the SQL server has been configured to
operate in 'Windows Authentication Mode (Windows Authentication)' and
doesn't allow the use of SQL accounts.

In order to resolve this problem, change the Authentication Mode of the
SQL server from 'Windows Authentication Mode (Windows Authentication)'
to 'Mixed Mode (Windows Authentication and SQL Server Authentication)'.

Snjeza

vasiliy wrote:
> Hi all.
> I have a java program that is converted to a windows service running by
> particular domain user. In that service I can connect via trusted
> connection to an MSSQL server. But when I try to produce BIRT report
> which also should work by a trusted connection it doesn't work. It says:
> java.sql.SQLException: Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection.
> at
> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDia gnostic.java:367)
>
> at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java :2217)
>
> As I understand BIRT Engine cannot get a service username. How can I fix
> that?
>
> I start BIRT Engine this way:
>
>
> config = new EngineConfig();
> String engHome =
> configProps.getProperty(ICommonConst.engHomeParam);
> config.setEngineHome(engHome);
> config.setLogConfig(engHome + "logs",
> Level.ALL); //todo set to Level.error
>
> Platform.startup(config);
> IReportEngineFactory factory = (IReportEngineFactory)
> Platform
>
> createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_EN GINE_FACTORY);
> birtEngine = factory.createReportEngine(config);
>
>
> The BIRT_HOME is a separate directory outside the calling program. I
> placed the ntlmauth.dll in system path so it is not a problem of missing
> dll.
> Any guesses?
>

Re: MSSQL trusted connection doesn't work [message #263734 is a reply to message #263731]

Wed, 26 December 2007 04:14

Eclipse User

Originally posted by: ibmer.mail.ru

Snjezana,
The trusted connection is allowed. I mentioned in my message that I can
connect to MSSQL via trusted connection the only problem is to connect via
trusted connection in .rptdesign.

Anyway thanks for your message.

Re: MSSQL trusted connection doesn't work [message #263826 is a reply to message #263734]

Tue, 01 January 2008 01:05

Eclipse User

Originally posted by: m.n.com

Are you just running the report in eclipse? If you are running this via
tomcat or another server, it should work just like the service.

What driver are you using?

vasiliy wrote:
> Snjezana,
> The trusted connection is allowed. I mentioned in my message that I can
> connect to MSSQL via trusted connection the only problem is to connect
> via trusted connection in .rptdesign.
>
> Anyway thanks for your message.
>

Previous Topic:	Urgent: X and Y axis label disappear
Next Topic:	how to display a BIRT report in swing?

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 01:18:05 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter