Hi

Following the Microsoft Access Expert 24 lesson and trying to get our tables on SQL server, While logging in from access I get the following message:

"Connection failed:
SQLState: '01000'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(ParseConnectParams()).
Connection failed:
SQLState: '08001'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid
connection

Any help appreciated! Thanks