SQL Server clients must use the following data-source provider:
Select the Microsoft OLE DB Provider for SQL Server from the list:
Enter the connection information necessary to log onto the data source.
Go to Database>>Set Datasource Location to confirm that the data-source provider was selected properly. Expand the database tree and review the properties. They should look something like this: