How to Create JDBC Connection

Hi,

I have read the help files but just wanted to check that I've not left anything out.

1. Created the database on SQL Server with stored procedures.

2. Created a JDBC connection on the portal.

3. User mapping set to admin, user

4. Create system alias, mapped system alias to my username and entered the username and password for the SQL database.

Connection test fails with error message :

Connection failed. Make sure user mapping is set correctly and all connection properties are correct.

Can anyone offer some advice ?

Thanks

Sue