bi to sql connection

[Former Member]

Hi,

hai i built the bi system and i need to configure or connect bi to sql .plz help me to set the connecton. i need the connection steps.plz help me.

[JPReyes]

• provide enough information

• Do not use text message language

Read the "Rules of Engagement"

Regards

Juan

[Former Member]

Hi,

I installed the sap netweaver abap 2004s and setted the bi in that. And mssql server is setted in other system .now i need a connection to sql server from bi for further work by accessing data from sql.

[Former Member]

Hi,

Please check this Note 512739 - BW external DB Connect for MS SQLServer.

Hope this solves your problem.

Thanks Rishi Abrol

[Former Member]

pugazh raj

We found the following document to be very helpful.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2f0fea94-0501-0010-829c-d6b5c2ae...

u201CTransferring Data with DB Connectu201D

It also mentions database specific notes, such as the note listed by Rishi above.

Hope this helps.

PJ

[Former Member]

Hi,

are you looking for this

[http://msdn.microsoft.com/en-us/library/dd299430.aspx]

Regards,

Muralidhar

[Former Member]

Can you please be more clear in you findings.

for Question :What do I have to configure in SQL Server for the access of the NT users "<sid>adm" and "SAPService<SID>"

Answer:

The configuration within the SQL Server is normally done by r3setup or sapinst. In some rare cases it might be necessary to create and/or configure the logins for the SAP system by hand. As there are different logins for different R/3 releases and configurations, you should consider the notes 151603, 551915 and 28893 to ensure the correct configuration of the logins and user.