General discussion


Perform a secure SQL Server installation

By debate ·
Have you installed SQL Server on your network, or do you plan to? Do you have any other installation security tips for SQL Server? Share your comments about performing a secure SQL Server installation, as discussed in the Jan. 16 Security Solutions e-newsletter.

If you haven't subscribed to our free Security Solutions e-newsletter, sign up today!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Web Services to SQL

by AgentASP In reply to Perform a secure SQL Serv ...

If you want your web site (hosted on a different server) to read and write to the SQL database, How should you setup the user access if anonymouse internet users are going to be doing the reading and writing eg. online notice board, online store?

Collapse -

Secured Web Transactions

by AndyPaul In reply to Web Services to SQL

Depending on how your Web Site is created, I would use a set SQL Account with limited read/write permissions to only the objects you want accessible.

You can reference this account through ODBC connectivity on your web site. DO NOT use a DB Owner account, such as SA. Manually apply the security and test before you implement.

Related Discussions

Related Forums