What's necessary to connect SQL server to XI?

[Former Member]

I have the following scenario "File - XI - JDBC"

The following steps were followed:

- Configuration of Visual Administration Drivers

- Configuration of Integration Builder

But I still getting the following error on the adapter monitor

Receiver Adapter v2604 for Party '', Service 'ATIS_BS':

Configured at 2006-04-17 12:52:31 VET

History:

- 2006-04-17 12:52:31 VET: Error: Accessing database connection 'jdbc:microsoft:sqlserver://middlewaredev:1433;DataBaseName=Z_prueba_Xi' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://middlewaredev:1433;DataBaseName=Z_prueba_Xi': SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

Help.

Thank's

Xime

[Former Member]

Hi

I think you should better to check whether JDBC Driver was successfully deployed.

->Start J2ee Visual Admin -> goto Cluster-Server-Libraries-com.sap.aii.af.jmsproviderlib ->Check JDBC Driver is displayed in list.

if none of JDBC Driver is displayed.

->deploy JDBC Drivers via SDM (also see note:831162)

regards

yuki fujioka

[Former Member]

thans to al of youfor your help, finally making deploy was the problem.

The steps to follow to solve the problem were taken by the guide "HOW TO INSTALL AND CONFIGURE EXTERNAL DRIVERS FOR THE JDBC & JMS ADAPTER"

thanks to all of you

Regards

Xime

[Former Member]

Ximena

Atlast your hardwork have worked out. Keep rocking!!!!!!

---Mohan

[moorthy]

Hi,

I think, there is problem with connection parameters given

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

To connection parameters pls have a look into this

http://support.microsoft.com/default.aspx?scid=kb;en-us;313100

Hope this helps,

Regards,

Moorthy

[Former Member]

what do you mean with "Configuration of Visual Administration Drivers"?

Did you deploy the JDBC driver files? According to Microsoft Documentation you need Msbase.jar, MSutil.jar and Mssqlserver.jar. Refer to this link for a way to check if your driver has been deployed:

Additionally i think, there's an error in the connection string, according to the documentation it should read DatabaseName and not DataBaseName.

Regards

Christine

[Former Member]

Christine,

Configuration of Visual Administration Driver

i'm making reference to...

- Open Visual Asministrator

- Navigate to server>services>JDBC Conector >drivers

- Create a new driver MSSQLD

- installed .jar

Soon

- Create data source

- Create new Conector Container, add library:MSSQLD

But, the error keeps repeating...

History:

- 2006-04-17 19:04:13 VET: Error: Accessing database connection 'jdbc:microsoft:sqlserver://10.233.50.42:1433;DatabaseName=Z_prueba_XI' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://10.233.50.42:1433;DatabaseName=Z_prueba_XI': SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

Regards,

Xime

Message was edited by: Ximena Gonzalez

[Former Member]

Now, Log in to Adapter monitor the status be green (They copied jar in J2EE directory).

Active the complete scenario File -> Xi -> JDBC

Checked message and flag status in SXMB_MONI and this one appears with state.

Status : Error

Descripcion : <i>Attempt to establish database connection failed with SQL error Cannot establish connection to URL 'jdbc:microsoft:sqlserver://10.233.50.42:1433;DatabaseName=Z_prueba_XI': SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver</i>

Please Help.!

Message was edited by: Ximena Gonzalez

[moorthy]

Hi,

I think there is a problem with connection Parameters.

Pls check this.

Let us know if any..

Hope this helps,

regards,

Moorthy

[Former Member]

are you able to telnet to the server ?

telnet 10.233.50.42 1433

If you are not able to connect to the telnet then it is the network issue.

Regards

Shravan