[OT] RE: ojb with mssqlserver2000

["Gelhar, Wallace Joseph" <GE...@uwec.edu>]

Christian,

By default, MSSQL installs with ONLY Windows Authentication.  To enable SQL Server Authentication, you must open the server properties, open the security tab, and enable SQL Server and Windows Authentication.

Wally

-----Original Message-----
From: Christian Eugster [mailto:christian.eugster@bluewin.ch] 
Sent: Tuesday, March 16, 2004 11:32 AM
To: OJB Users List; charles.anthony@hpdsoftware.com
Subject: AW: ojb with mssqlserver2000


Hi Charles,

thank you for answering!

a) Is the host SERVER your local machine ?    YES
b) Can windows resolve "SERVER" to a TCP/IP host address ? (try ping SERVER at the command line)  YES
c) Is TCP/IP enabled on your MS SQLServer database ? (try Start/Programs/MS Sql Server/Server Network Utility) NO
d) Is your SQL Server listening on the standard port of 1433 ? YES
e) try replacing SERVER in your URL to 127.0.0.1 e.g.

jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=database;SelectMethod
=cursor


i finally found the place to activate that TCP/IP channel. Now  i meet that following problem:

[org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR: Error getting Connection from DriverManager with url (jdbc:microsoft:sqlserver://SERVER:1433;Database=database;SelectMethod=curso
r) and driver (com.microsoft.jdbc.sqlserver.SQLServerDriver)
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Fehler bei der Anmeldung für den Benutzer 'SERVER\username'. Ursache: Keiner vertrauten SQL Server-Verbindung zugeordnet.

/* that means: not bound to a trusted sqlserver connection (sorry for my
english)

How can i establish a trusted connection?

Thank you twice!

Christian


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org