Skip to Content

How to connect MS-SQL Server??

hi

Currently BI server is install in Linux and connected to our Oracle Server which also in Linux now I need to connect MS-SQL Server which is windows base to get some data.

What is the procedure to do this?

Please mention in steps?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 11, 2010 at 10:51 AM

    The only way to do this in an easy manner is to install a Windows application server into your BI landscape and use that one to connect to the SQL Server system.

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 11, 2010 at 12:59 PM

    Hi Ishkan,

    I hope the below theads will shed some light to your requirement .

    /people/gilad.weinbach2/blog/2007/03/20/leveraging-your-sap-bi-data-using-the-microsoft-bi-platform

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2f0fea94-0501-0010-829c-d6b5c2ae5e40?quicklink=index&overridelayout=true

    http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/58f4db47-0501-0010-a2bf-ff01b150fdff

    Regards,

    Nibu Antony

    Add comment
    10|10000 characters needed characters exceeded

  • May 25, 2010 at 07:44 PM

    Hi,

    As mentioned before you need an Windows application server to connect to the SQL Server db as the necessary database library are only available for Windows.

    You can also follow notes [178949 |https://service.sap.com/sap/support/notes/178949]and [738371 |https://service.sap.com/sap/support/notes/738371]for the necessary steps.

    Regards,

    Eduardo

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Imran Shafiq

      Hi dude!

      You should set a DBCON connection. It is explained in the notes below:

      178949 - MSSQL: Database MultiConnect with EXEC SQL

      738371 - Creating DBCON multiconnect entries for SQL Server

      Do not worry about the password; in general in a SQL Server database you have two options to connect: with a user (DB login) and password, or through "Windows authentication". The 2nd one is the standard way of connecting for SAP, as if you use the user adm user is local).

      Find more information on users and their settings at note 592514 ("MSSQL: internal database users, permissions and security").

      Cheers!!

      -Jesú