J2ee can't connect the database

[Former Member]

Hello gurus,

I've installed XI3.0 system (ABAP+JAVA) on windows 2003

SQL server 2000 SP4+collation and for some reason the java side

can't start up. in the work directory, in dev* files I get error:

OpenOledbConnection: line 22091. hr: 0x8000ffff [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

C sloledb.cpp [OpenOledbConnection,line 22091]: Error/Message: (err 17, sev 10), [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22091]: Error/Message: (err 0, sev 10), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Failed to initialize provider SQLNCLI. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: Failed to set MARS property.

Then I get error:

• LOCATION SAP-Gateway on host XI-SAP / sapgw00

• ERROR program SLD_UC not registered

Some facts:

-ABAP system is up.

-I've checked the SQL server settings, nothing looks wrong.

Please advice,

Dimitry Haritonov

[Former Member]

hi Dimitry,

Check this document. You can find the solution

http://support.microsoft.com/?kbid=888228

Regards,

Ganesh N

Reward useful answers

[Former Member]

Hello Ganesh,

Thanks for the answer but I can't see how it is connected to my problem.

Dimitry

[Former Member]

Hi Dimitry,

1. Check that you SQL server permits both SQL Server and Windows authentications:

http://help.sap.com/saphelp_erp2005/helpdata/en/f2/31ad92810c11d288ec0000e8200722/frameset.htm

(you should have both methods activated)

2. Check if you are able to access J2EE-schema on MSSQL by logging to the J2EE ConfigTool. If you failed to logon there, correct driver's and/or user's settings,

Regards,

Mike

[Former Member]

Hello mike,

the help link is forwads to "starting and stopping SQL server ...". How is this connected ? I've checked the authentications method, it is both.

J2ee config tool shows error:

MSG:Error while connecting to DB

Please advice,

Dimitry Haritonov

[Former Member]

Hello,

the problem still isn't solved. maybe someone has an idea ?

Please advice,

Dimitry Haritonov

[Former Member]

Hi,

The problem might be due to,

"The number of programs that can be connected to the gateway in parallel is exceeded"

SAP Note 894100 suggests to

"Increase the value of the gw/max_sys parameter, or insert a new line into the instance profile of the server"

Also refer Note 384971 that describes additional gateway parameters.

Hope this helps,

Regards

Srinivasan T

[Former Member]

Hello,

Thanks for the answer but I got a clue for my problem.

In sql server I get:

"Bind failed on TCP port 1433"

I can't reach the port via: telnet <server_name> 1433

What did I check ?

-services file is okay.

-netstat -a shows that nobody uses this port.

-I've checked that SQL server uses this port.

-There is no other instance of sql server on the server.

Please advice,

Dimitry Haritonov

[Former Member]

Hello,

Finally I've solved this problem.

The problem accured due the changing IP to the SQL IP resource in my server.

I've found an KB article:

http://support.microsoft.com/kb/244980/

Best Regards,

Dimitry Haritonov