Integrity Server Connecting to SQL Server

Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
" A problem was encountered when trying to connect to the database JDBC.
[Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
for user SA, Reason: Not associated with a trusted SQL Server
connection"
Can please help
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...4603ecbf9ea539
*****************************************
The error message indicates you are trying to connect to SQL
Server using SQL authentication and a SQL Server login.
However, your SQL Server is configured for Windows
Authentication only. It's not a good idea to use sa but if
that's what is required you need to change SQL Server to use
both Windows and SQL Server authentication.
-Sue
On Wed, 10 Nov 2004 16:14:23 GMT, "jaimoon patel via
SQLMonster.com" <forum@.SQLMonster.com> wrote:

>Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
>At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
>" A problem was encountered when trying to connect to the database JDBC.
> [Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
> for user SA, Reason: Not associated with a trusted SQL Server
> connection"
>Can please help
>*****************************************
>* This message was posted via http://www.sqlmonster.com
>*
>* Report spam or abuse by clicking the following URL:
>* http://www.sqlmonster.com/Uwe/Abuse...4603ecbf9ea539
>*****************************************

Integrity Server Connecting to SQL Server

Installing Integrity Server on MS Server 2003 but having problems when Speci
fing the Database, prior to this install i've already installed JDBC driver
on this server version 3.
At this stage of install of the Integrity Server its trying to connect to th
e SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is
sitting in the same Domain. An Error appears
" A problem was encountered when trying to connect to the database JDBC.
[Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login fa
illed
for user SA, Reason: Not associated with a trusted SQL Server
connection"
Can please help
****************************************
*
* This message was posted via http://www.droptable.com
*
* Report spam or abuse by clicking the following URL:
* [url]http://www.droptable.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539[/u
rl]
****************************************
*The error message indicates you are trying to connect to SQL
Server using SQL authentication and a SQL Server login.
However, your SQL Server is configured for Windows
Authentication only. It's not a good idea to use sa but if
that's what is required you need to change SQL Server to use
both Windows and SQL Server authentication.
-Sue
On Wed, 10 Nov 2004 16:14:23 GMT, "jaimoon patel via
droptable.com" <forum@.droptable.com> wrote:

>Installing Integrity Server on MS Server 2003 but having problems when Spec
ifing the Database, prior to this install i've already installed JDBC driver
on this server version 3.
>At this stage of install of the Integrity Server its trying to connect to t
he SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is
sitting in the same Domain. An Error appears
>" A problem was encountered when trying to connect to the database JDBC.
> [Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login
failled
> for user SA, Reason: Not associated with a trusted SQL Server
> connection"
>Can please help
> ****************************************
*
>* This message was posted via http://www.droptable.com
>*
>* Report spam or abuse by clicking the following URL:
>* [url]http://www.droptable.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539[/
url]
> ****************************************
*

Integrity Server Connecting to SQL Server

Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
" A problem was encountered when trying to connect to the database JDBC.
[Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
for user SA, Reason: Not associated with a trusted SQL Server
connection"
Can please help
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539
*****************************************The error message indicates you are trying to connect to SQL
Server using SQL authentication and a SQL Server login.
However, your SQL Server is configured for Windows
Authentication only. It's not a good idea to use sa but if
that's what is required you need to change SQL Server to use
both Windows and SQL Server authentication.
-Sue
On Wed, 10 Nov 2004 16:14:23 GMT, "jaimoon patel via
SQLMonster.com" <forum@.SQLMonster.com> wrote:
>Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
>At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
>" A problem was encountered when trying to connect to the database JDBC.
> [Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
> for user SA, Reason: Not associated with a trusted SQL Server
> connection"
>Can please help
>*****************************************
>* This message was posted via http://www.sqlmonster.com
>*
>* Report spam or abuse by clicking the following URL:
>* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539
>*****************************************

integratedSecurity issues with Microsoft SQL Server 2005 JDBC Driver

I am using Microsoft SQL Server 2005 JDBC Driver to connect to SQL Server 2000 database, I am using the following connection URL

boolean iSecurity = true;

String connectionUrl = "jdbc:sqlserver://machine_name:1433;" + "databaseName=dbname;integratedSecurity=" + iSecurity;

I am getting the following error.

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

How do I resolve it? I have the following set

VMOPTIONS = -Xrs -Djava.compiler=NONE -Djava.library.path=C:\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth\x86\sqljdbc_auth.dll

Any help will be highly appreciated.

Regards

Arup

Hi Arup,

Try the following instead:

-Djava.library.path=C:\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth\x86\

The java.library.path JVM argument takes the location of a directory and not the .dll file itself.

Regards,

Jaaved Mohammed