we've got troubles trying to set up new universe connection using the OLE DB provider for MSSQL Server 2008. Environment is BO 3.1 SP3 FP7 (188.8.131.528).
When I open the Universe Designer to create a new connection and chose the MSSQL OLE DB provider it won't work using a Windows AD user.
The used Windows AD user is also the user who runs the BO services, the user has permission to log on to the database and could log on to the database using SQL management studio. Also, the ODBC connections using this AD user are working fine.
But trying to set up a OLE DB connection, chosing "Use specified username and password", I get an error message: "The Server is not responding (SBO0001): DBD: [Microsoft SQL Server Native Client 10.0] : Login Failed for user 'Domain\Username'."
Testing the OLE DB connection with an SQL Server 2008 user worked fine, also. The only thing that won't work is to set up the connection for the Windows AD user.
Could anyone help me with this issue?