By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,017 Members | 1,158 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,017 IT Pros & Developers. It's quick & easy.

JDBC with MSDE

P: n/a
I have a MSDE database that I am trying to connect to with JDBC. I don't
have SQL Server installed. Is this possible? When I try to connect I get
the error:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.

From what I've read on the web it looks like I need to set the security
settings to allow
for SQL authentication as well as NT authentication. Is that correct? And
can that
be done with just MSDE?

I think that I have MSDE 2000 installed (it actually came with a different
application).
I just downloaded the latest SQL Server JDBC driver.

Thanks,

Bruce
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
hi,
"dfdfd" <df**@aol.com> ha scritto nel messaggio
news:Uehab.184609$xf.152570@lakeread04...
I have a MSDE database that I am trying to connect to with JDBC. I don't
have SQL Server installed. Is this possible? When I try to connect I get
the error:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

From what I've read on the web it looks like I need to set the security
settings to allow
for SQL authentication as well as NT authentication. Is that correct? And can that
be done with just MSDE?


you connection failed becouse you MSDE installation is set to WinNT
authebtication (trusted authetication), default setting for WinNT platform
that can be changed during setup by filling SECURITYMODE = SQL parameter..
have a look at
http://support.microsoft.com/default...b;en-us;285097
for more info about this and for hints on how to change Authentication
setting by hacking the registry..
new switches info for service pack 3a can be found at
http://support.microsoft.com/?kbid=810826
hth
Andrea Montanari
an********@virgilio.it
mo**************@virgilio.it
http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.4.0 - DbaMgr ver 0.50.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.