How to create data security in SQL server 2005 so that the code will not be opened

15 pts.
Tags:
SQL Security
SQL Server 2005
SQL Server 2005 security
SQL Server security
how to create data security in sql server 2005 so that the code will not be opened

Software/Hardware used:
sql server 2005

Answer Wiki

Thanks. We'll let you know when a new response is added.

U can hide the implementation details of stored procedures from end users of the application using WITH ENCRYPTION option. ENCRYPTION indicates that SQL Server encrypts the syscomments table entry containing the text of the CREATE PROCEDURE statement. The WITH ENCRYPTION clause hides the text of a stored procedure from users.
It is true that, trigger, view and procedure encryption that comes with MSSQL 2008, 2005 is ineffective and easily broken. U may use SQL Shield is a tool for protecting SQL scripts from being viewed by anybody. And it does protect it from decryption. Don’t worry, it is free and easy to use.
If u want to hide instance….
Run SQL Server Configuration Manager and select the instance of SQL Server (which u want to hide), right click to select Properties. After selecting properties a window comes. In order to hide this, just set Hide Instance to Yes and click OK or Apply. After changing, again restart the instance of SQL Server.
Remember, The name of the instance is shown in the Local Servers list, but not in the Network Servers list.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    You might want to take a look at this question/answer which includes a small example of an encrypted function.
    70,220 pointsBadges:
    report
  • Denny Cherry
    You can use the WITH ENCRYPTION keyword when creating the objects. However this encryption can be broken with a quick google search for the decryption programs. It is better to simply trust your customers. The first thing that I do when a vendor puts encrypted procedures on my system is find a replacement system, or if one isn't available decrypt the procedures so that I can fix whatever problems the vendor is trying to hide.
    66,360 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following