How to connect MS-SQL Server??

[former_member198905]

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?

[former_member184473]

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

[former_member198905]

Hi

Thank for reply But I don't have ID and Password. Any other option??

[Former Member]

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ú

[Nibu]

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-d6b5c2ae5...

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

Regards,

Nibu Antony

[markus_doehr2]

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