I had played with SQLserver7 years ago and then the sa account did not have a pw requirement if I remember correctly.
so this time around I missed theat there is a pw on sa

once I changed the password and unchecked the stringend requirements it orks now with sa

Thanks




>>OK I am back in the office connected to the states domain server and my vfp program connects just fine.
>>SO does that mean at home I have to use SQLserver authentication?
>
>No.
>
>When you are at home, go into SSMS and in the Object explorer pane (the left panel) scroll to the Security section. Right Click on Logins and select New Login. Make sure Windows Authentication is selected and click the search button. You should be able to find your user account for the local machine. Create that login. Then in the Login Properties window select Server Roles in the Select a Page panel. There you can set your login to have the sysadmin role.
>
>Someone brought up the point yesterday - is your SQL server set to use mixed authentication (allowing Windows and SQL accounts)?
>
>If it is only set to Windows authentication that would explain problems trying to use SQL logins (like sa).
>
>>
>>Thanks all
>>
>>Peter
>>
>>
>>>>>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.
>>>
>>>>
>>>>
>>>>
>>>>>
>>>>>>that's the name of my laptop
>>>>>>it worked yesterday
>>>>>>
>>>>>>
>>>>>>>To me the server name seems to be "questionable." In my experience the server name usually something like
>>>>>>>computername\SQL2008 or computername\SQLEXPRESS. Check the name you see in the SSMS.
>>>>>>>
>>>>>>>HTH.
>>>>>>>
>>>>>>>>yesterday I installed SQL2008 developer
>>>>>>>>
>>>>>>>>I could connect with this:
>>>>>>>>

>>>>>>>>
>>>>>>>>strConnectionString	= [Driver={SQL Server};Server=OTT-LT1026;Database=kba_sql;Uid=sa;pwd=]
>>>>>>>>strConnectionString	= [Driver={SQL Server};Server=OTT-LT1026;Database=kba_sql;Trusted Connection]
>>>>>>>>
>>>>>>>>strSQL				  = [select * from claims where 1=1 ] && or what ever sql statement you are passing.
>>>>>>>>csrCursorToBeReturned = [csrNames]
>>>>>>>>
>>>>>>>>intHandle = SQLSTRINGCONNECT(strConnectionString)
>>>>>>>>
>>>>>>>>intResults = SQLEXEC(intHandle, strSQL, csrCursorToBeReturned)
>>>>>>>>
>>>>>>>>

>>>>>>>>
>>>>>>>>today it times out
>>>>>>>>with SQL management studio I connect just fine
>>>>>>>>
>>>>>>>>what could be wrong?
>>>>>>>>
>>>>>>>>Peter