Skip to Content

Introduction

A comprehensive, step-by-step guide on How to connect to Microsoft SQL Server 2000 from SAP xMII 12.0.

Step – 1 : Getting the Driver jar file 

a) Download the

*SQL Server 2000 Driver for JDBC Service Pack 1*

from the Microsoft website. Scroll down and select the mssqlserver.tar file and download it on your local machine.

b) Unzip *mssqlserver.tar *to get a couple of files along with the *msjdbc.tar *file.

c) Unzip the msjdbc.tar file.

d) Go to the folder where you just unzipped the msjdbc.tar file. Find the following files under the lib folder in the same directory :

msbase.jar0.1.

mssqlserver.jar0.1.

msutil.jarThese are the files we require.

Step – 2 Uploading and Deploying the files on SAP xMII 12.0 Server 

a) In the SAP xMII 12.0 server go to *System Management->JDBC Drivers.  *Click on *Upload *to upload the driver.

 

b) On the screen that pops up browse to select the mssqlserver.jar file that you had saved on your machine and click on save. Repeat the same for the *msbase.jar *and msutil.jar file as well.

c) Now select the three files that you deployed just now on the screen and click on the  Deploy button to deploy them. After deploying check that their status has changed to Deployed. That indicates a successful deployment.

 

 

Step – 3 : Setting up the connection

a)  In the SAP xMII 12.0 server go to *Data Services->

Data Servers. *Click on New to create a new Data Server.

b) Choose IDBC as the connector.

c) In the configuration screen that comes next enter the following values : 

0.1.

Name : Give a Name for your Data Server0.1.

*Enabled : Check it to enable this server.</li><li>JDBCDriver : *Enter com.microsoft.jdbc.sqlserver.SQLServerDriver!https://weblogs.sdn.sap.com/weblogs/images/251690412/JDBCDriverString.gif|height=345|alt=|width=454|src=https://weblogs.sdn.sap.com/weblogs/images/251690412/JDBCDriverString.gif!0.1.

*ServerURL : *Enter the connection string in this format : *jdbc:microsoft:sqlserver://<servername>:1433;databaseName= (Note* : Username and Password : Username and Password for the selected Database.d) Click on *Save *to save the Server configuration.

e) Verify you have successfully connected to the server by clicking on the Status button.

!https://weblogs.sdn.sap.com/weblogs/images/251690412/ConnStatus.gif|height=235|alt=|width=321|src=https://weblogs.sdn.sap.com/weblogs/images/251690412/ConnStatus.gif!</body>

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. Udayan Upreti
    Abesh,
    Is there an advantage in using these 3 Jar files when one can accomplish the same using Una2000.jar (which is part of the 11.5 installation).

    Probably Una2000 may not be available for the client base who are starting with xMII 12.0 but still, technically, is there any advantage OR is this a recommendation from SAP?

    (0) 
    1. Abesh Bhattacharjee Post author
      Hi Udayan,
      Una2000.jar is one of the many 3rd Party MSSQL drivers that are available on the internet. What I have used here are the standard Microsoft Drivers for MSSQL 2000. Since they are from microsoft, i would assume that they would be more optimised for their product MSSQL Server 2000. You can use mssql.tar/Una2000.jar or any driver to connect to the database. There are no recommendations as to how you connect to a database 🙂
      (0) 
  2. Antonio Maradiaga
    Hi,

    Excellent blog by the way…

    I’m trying to upload the SQL Server 2000 Driver for JDBC Service Pack 3 to xMII 12, but I always get the following error message: DRIVER_NOT_UPLOADED….Do you what can be happening?

    Thanks in advance

    (0) 
    1. Gregory Powers
      Antonio,

      What was the outcome…Strange it worked fine on out Corporate Server, but when I went the client site..I got this message…Same Windows 2003, SQL 2005…How did you fix this?

      (0) 
  3. Kevin Iuliano
    First off THANKS for this doc – it is extreamly helpful!!!  I have not seen this detail info anywhere else.

    Questions –
    What would you change to access a SQL 7 DB?
    What would you change to access an AS400 DB2 DB?
    What would you change to access an AIX DB2 DB?

    Thanks in advance,

    Kevin

    (0) 
  4. Prashant Annaiahvondla
    hi,
    i read your blog this give a good info. i was windering if you could provide a blog how to connect to the analytical services provided by MS SQL a.k.a. MSOLAP.
    Regards,
    A Prashant Kiran
    (0) 
  5. Gregory Powers
    I am getting a message…Driver_Not_Loaded message when I try to setup the JDBC for MS SQL.  Strange it worked on our Corporate Server and it worked, but didn’t work at the client site.  Same operating system and SQL database version.  Windows 2003 and MSSQL 2005…Strange…Any help.
    (0) 
  6. Thomas Roeser
    Thanks Abhesh, very useful documentation !

    For 12.1 – we found no documentation , how to configure “dataserver”. According to note 1109274, we deployed JDBC driver from kernel. Connect to internal database MSSQL2005 with values for 12.0 don’t work (connection stopped). No documenation found …

    Any suggestions ?

    Thanks very much in advance

    Thomas Roeser

    (0) 

Leave a Reply