Failure To Connect To Microsoft Sql Server At First Attempt

I have an Access accdb file in which all the tables are linked (not imported) to a Microsoft SQL Server (2008 R2). When I Load the program I get this error message: Now, after clic

Solution 1:

These sorts of errors can be avoided by choosing the "Save password" option of the link tables dialog:

However, a much cleaner solution is to configure the SQL Server and its database to use integrated Windows authentication whenever possible.