Encryption

Is there any way I can encrypt the stored procedure and that only I can only
decrypt it none of other user can do?
I can't use Ecryption reserve word becuase that can also be decrypted
through third party tool, is there any other way I can encrypt my stored
procedure with my own key or like that?
Thanks in advance.
Rogers wrote:
> Is there any way I can encrypt the stored procedure and that only I
> can only decrypt it none of other user can do?
> I can't use Ecryption reserve word becuase that can also be decrypted
> through third party tool, is there any other way I can encrypt my
> stored procedure with my own key or like that?
> Thanks in advance.
There are some thrid-party solutions for object encryption. In general,
you should be working/developing your stored procs (and other objects)
using external files and version control software like PVCS or
SourceSafe. It's not advisable to edit objects directly in the database.
If you use one of the third-party solutions, that should help secure the
objects, but I don't know if those tools support decryption or a more
permanent type of encryption.
I just came across one of these tools today (I have no experience with
the product or affiliation with them):
http://www.sql-shield.com/
David Gugick - SQL Server MVP
Quest Software
|||Thanks David.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%237MM5gwQGHA.4900@.TK2MSFTNGP09.phx.gbl...
> Rogers wrote:
> There are some thrid-party solutions for object encryption. In general,
> you should be working/developing your stored procs (and other objects)
> using external files and version control software like PVCS or SourceSafe.
> It's not advisable to edit objects directly in the database. If you use
> one of the third-party solutions, that should help secure the objects, but
> I don't know if those tools support decryption or a more permanent type of
> encryption.
> I just came across one of these tools today (I have no experience with the
> product or affiliation with them):
> http://www.sql-shield.com/
>
> --
> David Gugick - SQL Server MVP
> Quest Software
>

enable caching error during sql dependency registration

Hey, I can't enable caching on my local computer..I use d

aspnet_regsql -S "localhost\SQLEXPRESS" -E -d books -ed

and

aspnet_regsql -S "Admin\SQLEXPRESS" -E -d books -ed

to try to start but i get a login error...

cannot open database "books" requested by login. The login failed. Login failed for user Computer2/Admin
unable to connect to SQL database for cache dependency registration

I tested connection with vwd and sql express management and it connects so I don't know what i'm doing wrong since I followed the direction and I googled for answer but not coming up with anything that's helping me..anyone have this problem and know how to resolve so i can cache some data output on my project

So you're encountering connection failure when you tried to connect to SQL Express instance in aspnet_regsql, right? I see you use Windows Authentication to connect to SQL, so first make sure there is a database named books on the SQLEXPRESS instance, and the login you're using (Windows logon account in this case) has permissions on the books database (you can simply add the account to the db_owner role on the books database).

BTW, why not aspnet_sql without parameter? Then you have a friendly GUI and the registration will become much easier.

|||

Well..I'm not sure how it worked out but this is what i basically did...attached database to sql express management...then detached...then called it like before but with its full map of c:/website/blah/books.mdf and that worked but I don't think it should have...and to answer post above i just followed examples located on microsoft.com...i don't know about asp_sql gui...didn't know they had one in cmd lines...anyhow..this is my first windows server so it's a bit of a learning curve..still learning how to use ashx and httphandlers...well..to the next problem now...weeeeeeeeeeeee