Security

Ask something
Discussion Locked

Perform a secure SQL Server installation

0 helpful
2 replies

by debate

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!
http://nl.com.com/acct_mgmt.jsp?brand=techrepublic

2 replies

by agentasp

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?

by andypaul

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.

This discussion is closed to new replies.