Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>how do i setup a computer connected to the internet through DSL as an SQL server for the software we developed using foxpro? what are the client computer requirements and what are the server computer requirements?
>
>Thanks in advance....your advice will really be of help to me....
>
>Sincerely,
>
>Steph
Steph -
Server Comments:
some places use a VPN, other places use a DIFFERENT PORT # for SQL access [like 10234, for example] on the SQL SERVER BOX in question.
Server Computer Requirements should MATCH what MicroSoft says they should be - plus I would add some more firewall stuff there - you don't wanna open up the sql port on a server for internet access to the world [ok - maybe you do - but don't use the STANDARD SQL PORT or you will get hacked].
You do NOT want to use named pipes or SQL SERVER AUTHENTICATION / NT Authentication for your DSN connection type at all - try to stick to using TCP/IP ONLY.
Lock down the guest account or kill it completely.
Make new specific sql accounts for your vfp app in the sql server admin stuff.
lemme know how it goes..
mondo regards [Bill]
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement