Changing the provider to SQL Client rather OLE DB did the trick for me. As a precaution I also changed the server name from localhost to the actual server name.