468,747 Members | 1,790 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,747 developers. It's quick & easy.

Internet Facing SQL Server, Login Security? How?


Internet Facing SQL Server, Login Security? How?

I would think that our Project is fairly common. We're stuck on a
security question.

We have a typical SQL Server 2000, running under Windows 2000 Server.

Our app is a VB, RDO. The Users are nationwide, in various client
companies, all sorts of PC platforms.

The VB App works fine with SQL Server Login Authentication, but this
leaves Port 1433 (I know we can select a different port) open to the
world, but we can see that Hackers are trying to break in.

We're trying to use Windows (NT) Authentication, ie Not Mixed Mode,
but can figure out how to get our VB App clients (nationwide) logged
in. We were hoping that VB could 'Impersonate' a passed in Windows ID
& PW, but we're been unseccessful. We're using RDO.

We're searched the Web and Newgroups, but most do not address SQL
Servers which are facing the Internet.

Q: How do we allow our client Users into our SQL Database ?? While
keeping security manageable.

Any Comments or Hints are really appreciated.

John


John@NoSpam_SensorySIMS.com
(please remove "NoSpam_" from return address to respond directly)
Jul 20 '05 #1
0 1704

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Matt Hawley | last post: by
14 posts views Thread by John Spiegel | last post: by
13 posts views Thread by Edward Mitchell | last post: by
6 posts views Thread by pradeep_TP | last post: by
3 posts views Thread by =?Utf-8?B?ZGF2aWQ=?= | last post: by
17 posts views Thread by Anil Gupte | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.