General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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]
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only