connect-problems abap -> ms sql server

120 Views

Hello!

I've problems getting contact to a workgroup-server (ms sql server) from my abap (crm 4.0).

I've made these entries in table dbcon:

DB-Verbindung WG-SERVER

DBMS MSS

Benutzername ides

DB-Passwort ****************************** / ******************************

Verb.Info MSSQL_SERVER=tcp:webrmcmc;MSSQL_DBNAME=ides;

...and this is my code:

REPORT ZCRM_WGSERVER_ABGLEICH.

exec sql.

connect to 'WG-SERVER' as 'WGS'

endexec.

exec sql.

set connection 'WGS'

endexec.

While connecting at "...connect to 'WG-SERVER' as 'WGS'..."

This error raises:

Runtime error DBIF_DSQL2_CONNECTERR

Exception CX_SY_NATIVE_SQL_ERROR

From my SQL Query Analyzer i've no problems to connect to

webrmcmc to make my selections on the smokna1. In the dbcon

i've tried with "tcp:" and without "tcp:" ... nothing helps.

Perhaps there's someone out there with a hint or an advice for me?

Thanks in advance!!!

Best regards,

Ingo