Jdeveloper BSSV setup

[striker]

I set up a database connection using the connection navigator. Its connecting.

I used the following URL to connect:
jdbc:sqlserver://<machinename>\JDESSELOCAL:1862;databaseName=JdeData;
( DB is SQL server )

Now the problem comes when I create a DB Value Object Class, I fill in a table name (eg: F0101) then hit 'FIND' then I get an error.

Can not load Table/View records - [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Object Librarian Local.class com.jdedwards.database.base.JDBException
Log off E1 system

Am I missing some setting?

 

[ONYX]

I had a similar error with sql server log message
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

Login failed for user 'JDE'. [CLIENT: 127.0.0.1]
Error: 18456, Severity: 14, State: 8.

For me the solution was to change JDE user password from uppercase to lowercase - JDE->jde

alter login JDE WITH PASSWORD = 'jde'

Now database value object works fine.