Skip to main content



      Home
Home » Archived » BIRT » MSSQL trusted connection doesn't work
MSSQL trusted connection doesn't work [message #263718] Tue, 25 December 2007 08:24 Go to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous message
Eclipse UserFriend
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:
  


Current Time: Thu Jul 24 03:41:56 EDT 2025

Powered by FUDForum. Page generated in 0.05985 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top