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:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 11:32 AM To: OJB Users List; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
