Creating a connection to SQL Server

[Former Member]

Hi all,

I am new to BOE, so maybe my question will be phrased no so accurately.

I have an SQL Server database, which i want to use with Web Intelligence / Xcelsius.

How to i add this database to the universe? to the connection list?

i tired also to find some documentation in the SDN but could not.

please assist.

-Doron

[Former Member]

Issue is solved

[Former Member]

Hi Doron,

I am having the same issue, could you post your solution ?

Thx a lot.

[Former Member]

Hi,

I am having an issue with SIA and Sql Server db communication.  I have created a copy of the SQL server database on a test server and installed SAP 4.1 on the same server.  I provided the DSN connection pointing to the database located on the test server.  After installation it's saying I can't connect to he CMS.  The error says "Account Information not recognized: Could not reach CMS........(FWM 20031)".  I created another node and still not working.  I checked via CCM and SIA is running. 

I think the problem seems to be, the communication between SQL server and SIA.  But I need an expert advice.

The ports are open and the firewall and the antivirus were suspended during installation.

Any help is appreciated.

Regards.

Aaron.