Problem with SQL Server

[Former Member]

Hi ,

I am doing File to Jdbc Scenario. I have installed drivers for JDBC(SQLServer).I gave all the

required parameters in the reciver JDBC adapter.It is saying authorization problem(user name and password) in RWB.

I know I have to give correct user name and password. I went to instance of SQLServer.There I found "use windowsauthentication" button.

There I change it to "USE SQL server authentication button" and tried to give user name and pwd.

It is saying "SQL Server regestration Failed because of the connection failure displayed below"

and Login failed for user "sapuser".

How to solve this issue and How can I access My database from XI? please help me..

Thanks,

Nandini

[Former Member]

try with user name SCOTT and password tiger.

[Former Member]

Nandini,

The problem is you are not giving a valid user id/ password for SQL server. Get a valid user Id/ Pwd from SQL administrators.

Regards,

Jai Shankar.