Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Failed Connection SAP Portal With SQL SERVER

former_member223090
Participant
0 Likes
994

Hi Experts, im triying to connect a Web Dynpro Portal with SQL SERVER with the connector JDBC but i have this error:

SQLException:ResourceException

in method ConnectionFactoryImpl.getConnection():

com.sap.engine.services.dbpool.exceptions.BaseResourceException:

SQLException thrown by the physical connection: java.sql.SQLException:

[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

In the attached Files are the images of the error, and the configuration of the DataSource

Thanks

1 ACCEPTED SOLUTION
Read only

former_member223090
Participant
0 Likes
928

Thanks Glen, I already solve the problem, the solution was:
the name of the database in the datasource is
written  "databaseName" and i had
"database_name", and the server name is "PORTAL/SQLEXPRESS" and I had PORTAL.


Thanks Glen, I already solve the problem, the solution was:
the name of the database in the datasource is
written  "databaseName" and i had
"database_name", and the server name is "PORTAL/SQLEXPRESS" and I had PORTAL.


2 REPLIES 2
Read only

former_member201275
Active Contributor
0 Likes
928

I think you might be better off logging this under

SAP NetWeaver Portal

instead of

ABAP Development

Read only

former_member223090
Participant
0 Likes
929

Thanks Glen, I already solve the problem, the solution was:
the name of the database in the datasource is
written  "databaseName" and i had
"database_name", and the server name is "PORTAL/SQLEXPRESS" and I had PORTAL.