Re: Problem connecting to SqlServer 2005

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi;

How do I tell? The manifest file in the jar file has no version info.
The file is dated 1-17-02 and is 231,949 in size. It does handle SSPI
ok for SqlServer 2000.

Also, how can I get more information when it throws an exception like
this? The exception below gives almost no information as to the
problem.

thanks - dave



On Tue, 12 Sep 2006 18:17:43 GMT, evanba@xxxxxxxxxxxxxxxxxxxx (Evan T.
Basalik (MSFT)) wrote:

The integratedSecurity flag only works in the 1.1 release of the SQL Server 2005 driver. Which version are you using?

Evan
--------------------
From: David Thielen <david@xxxxxxxxxxxx>
Subject: Problem connecting to SqlServer 2005
Date: Mon, 11 Sep 2006 17:36:56 -0600
Reply-To: david@xxxxxxxxxxxx
Message-ID: <8msbg2l8h4qgftblioushneude987cb67q@xxxxxxx>
X-Newsreader: Forte Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: microsoft.public.sqlserver.jdbcdriver
NNTP-Posting-Host: vc4-2-0-321a.dsl.netrack.net 199.45.247.98
Lines: 1
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.jdbcdriver:8071
X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver

I can connect to SqlServer 2000 fine but 2005 I get this problem:

Error: net.windward.datasource.DataSourceException: JdbcDataSource
could not ope
n
jdbc:sqlserver://T1-Databases;databaseName=AdventureWorks;integratedSecurity=t
rue;
net.windward.datasource.DataSourceException:
net.windward.datasource.DataSourceE
xception: JdbcDataSource could not open
jdbc:sqlserver://T1-Databases;databaseNa
me=AdventureWorks;integratedSecurity=true;
at
net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid
integratedSe
curity property value:true
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more
Exception in thread "main"
net.windward.datasource.DataSourceException: net.wind
ward.datasource.DataSourceException: JdbcDataSource could not open
jdbc:sqlserve
r://T1-Databases;databaseName=AdventureWorks;integratedSecurity=true;
at
net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid
integratedSe
curity property value:true
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more


any ideas?

thanks - dave

david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com



david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com
.

Relevant Pages

  • sqlmangr.exe generated errors
    ... I looked in the log file and the error displayed ... 11:04:52.941 Exception number: c0000005 ' ... The sqlagent and sqlserver are running successfully in services but the ...
    (microsoft.public.sqlserver.setup)
  • Re: Insert data into table from text file using sqlceresultset
    ... I am trying to import from a csv file into a sqlserver ce table. ... I am using parameters to improve performance of insert into query. ... A first chance exception of type ... I converted my pocket pc code to desktop code and it worked there. ...
    (microsoft.public.dotnet.framework.compactframework)
  • How can I handle the exception when the connection fail??
    ... I have a program that connect to SQLServer. ... when the connection fail suddenly ... How can I handle the exception and take some action when the connection ...
    (borland.public.delphi.database.ado)