>>>Another thing to check. If you are running Windows 7, you may have to open VFP as Administrator. Or the program from which you are connecting to SQL Server.
>>
>>it worked yesterday and I made no changes to my VFP
>>the only difference is yesterday I was connected to my work network domain and today I am working from home, but the SQLserve is installed locally on my laptop
>>
>>the only difference is yesterday I was connected to my work network domain and today I am working from home, but the SQLserve is installed locally on my laptop
>
>Big difference. The trusted Connection that worked yesterday was using your domain credentials. You can act as admin on the server because of your local credentials.
>
>Follow the advice in the link I sent you (the Dmitri whomever answer). It tells you how to enable the sa account (it's disabled by default - hence it doesn't work) and how to set a password on it. Then put the password in the connectionstring using username and password, and use that to connect.

Instead of using sa password in the connection string (and sa account) he needs to create a new login and a new user.