Runtime error while connecting from SAP to MS-SQL DB

[Former Member]

Hi,

I am writing a program to send data from SAP to MS SQL DB.

The stored procedure when run alone works fine.

I have defined connection 'C04' in DBCO with correct attributes.

But the 'CONNECT TO C04' statement gives me runtime error DBIF_DSQL2_CONNECTERR saying that 'Connection to Database system with the identifier C04 is not possible;.

First of all, I am not very clear if it is a ABAP problem or BASIS problem.

I did a lot of research but could not find a solution.

Please help me.

Thanks & Regards,

Shubha.

[Former Member]

Shubha,

Please check the transaction code SM59 for the remote logon. Remote logon to the system has to be enabled. Also verify if you are supplying the correct "Application Server Name", "System Number", "UserID" and "Password" for the SAP system from MS SQL side. In case all these things are fine and still you are unable to connect please get in touch with your networking team and the networking team of the SAP server. It could be a problem of privileges for connection.

[Former Member]

Hi Subha,

Check the information provided in the DBCON table entry is correct. <b>Also, ensure that the server is in the same network as that of SAP.</b>

Example entry in DBCON:

Field Name Description Value

CON_NAME Logical name for db connection RAJ

DBMS Database system MSS

USER_NAME Database user <username>

PASSWORD Password <pwd>/<pwd>

CON_ENV MSSQL_SERVER=depotserver MSSQL_DBNAME=HOF_INDORE

DB_RECO

Regards,

Raj

[Former Member]

Hi,

I tried to resolv the same error : 'Connection to Database system with the identifier XXX is not possible'.

I read the user guides (notes), blogs, forums.

I created correctly a DBCO record for my MSSQL server connexion.

Our SAP: ECC5 640 / Oracle / NT (external server)

My MSSQL Server installed on my computer (with a fixed IP address): 2000.

When do we use to meet this error ?

Did you manage to correct your error ?

Thanks in advance,

Arni

[Former Member]

Hi shubha,

1. If your application server

is unix/aix,

then connection to MSSQL db

is not possible.

(Bcos both OS are different,

and the connector is not provided

by sap / not available)

2. After making an entry in DBCON Table,

probably something may be required to

be done on the application server,

by the basis team.

3. If this connection is required

to be made to oracle server,

then basis definitely requires

to make a connection string

on the application server

(apart from the dbcon entry)

regards,

amit m.