How to set up data source for SQL SERVER in JDE

Hi all,

We have installed SQL Server 2008 on fat client.We want to set up data source for SQL Server in JDE.

I tried to create a Data source but end up with an error "ADD FOR ODBC DATA SOURCE FAILED"

If any one did with such set up your comments are warmly welcome.

We stuck in following parameters :

1) Data Source use:
2) Data source type :
3) Platform :
4) Database server name :


Database name :
Database instance :

We have created a Database succesfully in SQL, but we don't what would be instance for that database ?

Thanks in advance.

Rahul Vaneldas
E.900 TechnIal consultant
Database : SQL SERVER - 2008