Unable to connect to SQL Server 2016 - Login failed for user

building semantic layer
1

I have created two data sources called ‘test’ in System DNS, one for 32 bit and one for 64 bit. Both of these connections work fine when clicking test connection within windows.

Then I tried to add the connection in Universe Designer but it is unable to connect and I get an error ‘[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ‘Username’.’

sql-server-16-faield-connection.png

I know I am definitely using the correct credentials. What could the problem be?

BO Version: 4.2

dcullen (BOB member since 2019-02-19)

2

What SQL Server version of are you using for your System DSNs?

What are you using for the middleware selection when you create your connection?

While Business Objects does list that you can choose SQL Server 2016, it is still using the SQL Native Client 11 middleware. You may need install SQL Native Client 11 in order to get it to work.