Eclipse Community Forums: Newcomers » issues connecting eclipse birt report to sqlserver

Home » Newcomers » Newcomers » issues connecting eclipse birt report to sqlserver(trouble connecting eclipse birt report to sqlserver)

issues connecting eclipse birt report to sqlserver [message #1403930]

Mon, 28 July 2014 11:36

Eclipse User

Hello All,

Please i need assistance with how to connect Eclipse birt report to sql server.
Please i will really appreciate if any body can give a detail step by step approach on how to connect birt report from the report designer to sqlserver 2008r2 with all the necessary jay files. because all the videos i hv seen seem to be very vague and this process is-meant to be smooth.and after downloading the sqljdbc drivers am still getting this error

org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Cannot open database "AdventureWorks2014" requested by the login. The login failed. ClientConnectionId:440a81e4-4c36-4edb-a5d8-dfce720075d4.

when i try to connect using this parameter:

jdbc:sqlserver://localhost\NEWSQLEXPRESS:1433;databaseName=AdventureWorks2014;

but when i try to connect using this one:

jdbc:jtds:sqlserver://BBT-SAS-PC:1433;databaseName=AdventureWorks2014;

I get the following error :

There is an error in get connection, I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property..

Please I will appreciate a very clear cut and understanding response as this is very urgent.

Thank you

Re: issues connecting eclipse birt report to sqlserver [message #1403987 is a reply to message #1403930]

Mon, 28 July 2014 19:50

Eclipse User

On 07/28/2014 11:01 AM, Francis White wrote:
> Hello All,
>
> Please i need assistance with how to connect Eclipse birt report to sql
> server.
> Please i will really appreciate if any body can give a detail step by
> step approach on how to connect birt report from the report designer to
> sqlserver 2008r2 with all the necessary jay files. because all the
> videos i hv seen seem to be very vague and this process is-meant to be
> smooth.and after downloading the sqljdbc drivers am still getting this
> error
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error
> in get connection, Cannot open database "AdventureWorks2014" requested
> by the login. The login failed.
> ClientConnectionId:440a81e4-4c36-4edb-a5d8-dfce720075d4.
>
> when i try to connect using this parameter:
>
> jdbc:sqlserver://localhost\NEWSQLEXPRESS:1433;databaseName=AdventureWorks2014;
>
>
>
>
> but when i try to connect using this one:
>
> jdbc:jtds:sqlserver://BBT-SAS-PC:1433;databaseName=AdventureWorks2014;
>
> I get the following error :
>
> There is an error in get connection, I/O Error: SSO Failed: Native SSPI
> library not loaded. Check the java.library.path system property..
>
> Please I will appreciate a very clear cut and understanding response as
> this is very urgent.
>
> Thank you

There's a separate BIRT forum for this.

Previous Topic:	Kepler Service Release 2 and Java 8 support
Next Topic:	error getting Eclipse running on Windows Server 2008R2?

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 08 21:18:02 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter