(SQL Server 2014, SQL Server 2012, SQL Server 2008, and SQL Server 2005)ġ. To resolve this issue, configure SQL Server in Mixed Authentication Mode. The login may be a SQL Server login but the server only accepts Windows Authentication This problem can occur in the following scenarios: Actual result: I get a connection failed for user error message. Expected result: I continue setting up the repository.

Also have the box checked for 'Connect to SQL Server to obtain default settings for this additional configuration options. In response to 'How should SQL Server verify the authenticity of the login ID?', choose the 'With Integrated Windows authentication' radio button and click 'Next'. Add in the name, description, and server that you want to connect to:ħ. In the 'Create a new Data Source' window, select the driver 'SQL Server Native Client 10.0' and click 'Finish'.Ħ. In the 'ODBC Data Source Administrator' window, under the 'User DSN' tab and 'User Data Sources', choose 'dBASE files- Microsoft Access dBASE driver', and click 'OK'.ĥ. In the 'Database Type' tab, for the question 'What type of database is being used for your Test Data Repository?', choose Microsoft SQL Server.Ĥ. In the 'Create connection profile for Test Data Repository' window, choose the 'I need to provide credentials for my Test Data Repository' radio button.ģ. Launch Datamaker by right-clicking on the icon and choosing the 'Run as elevated' option.Ģ. When trying to connect to my SQL Server database in Datamaker, I am receiving the following error:

Sql error 18456 sql native client