I enabled TCP/IP protocols in the SQL Server 2008 but still am not able to connect from my VFP application. And it looks to me that the issue is not with login name/password but rather IP connection. Is there a test you can recommend to check if my client computer can connect to the SQL Server? (rather than trying to connect from the application)
>You should use SQL Server Configuration Manager to enable/disable network protocols.
>
>>
>>I want to enable remote access to the SQL Server 2008. So from SSMS I select Facets -> Surface Area Configuration.
>>The only item in the list of Surface Area Configuration that seem to be what I am looking for is "RemoteDacEnabled". Is this the item I should Enable for the remote data access?
>>
>>TIA.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham