Showing posts with label moved. Show all posts
Showing posts with label moved. Show all posts

Wednesday, March 21, 2012

encrypting data of config table

hi. i need some help please. i had a problem with using configuration files in april ctp so i moved to sql server configuration which i found as a better solution for storing connection info since it can encrypt the password. this as far as i know as i'm moving from beta 1 version.

when creating the database at the client's server, the configuration table needs to be created as well and the data manually inserted using insert statements.

in this case, how do i enter the data in a way that is encrypted?

that's my question
thanks
I'm not sure I understand your question, but I think the answer is you can't do this. We don't support encrypting SQL Server configurations.|||I believe the question is just about writing data to an encrypted column. In that case, you should be able to just write values as you were writing them before, SQL Server would take care of encrypting the contents.

Sunday, February 26, 2012

Enabling Fulltext Service on database

Hi guys,
one of my customers moved a SQL Database from one server
to another. The database had 2 fulltext catalogs associated.
On the new DB Server the fulltext service doesn't start using
sp_fulltext_database 'enable'.
QA shows "Executing Query Batch..." but never returns.
I googled on the newsgroups and found the solution to update the
path in the sysfulltextcatalogs to a physical existent folder on the
new server. I tried again with sp_fulltext_database but again it
doesn't work.
The only thing I need is to clean/remove the two catalogs, rebuild
them and enabling the fulltext. What can I do ?
I read also the support ms doc #240867.
So, what am I missing ? Thank you all.
David De Giacomi
Microsoft MVP
Blog @. http://blogs.dotnethell.it/david/
http://www.dotnethell.it
sp_fulltext_database 'disable' in your problem database and run profiler to
see where it is getting stuck (if it does at all). Then I would try to
reenable it (sp_fulltext_database 'enable') and again run profiler to see
where it is getting stuck.
Make sure you kick all users out of this database when you run this command.
I would also bounce the box if you have this luxury before running this
command.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David De Giacomi [dotNetHell.it]" <david_NOSPAM@.dotnethell.it> wrote in
message news:uv%23YZTGOGHA.812@.TK2MSFTNGP10.phx.gbl...
> Hi guys,
> one of my customers moved a SQL Database from one server
> to another. The database had 2 fulltext catalogs associated.
> On the new DB Server the fulltext service doesn't start using
> sp_fulltext_database 'enable'.
> QA shows "Executing Query Batch..." but never returns.
> I googled on the newsgroups and found the solution to update the
> path in the sysfulltextcatalogs to a physical existent folder on the
> new server. I tried again with sp_fulltext_database but again it
> doesn't work.
> The only thing I need is to clean/remove the two catalogs, rebuild
> them and enabling the fulltext. What can I do ?
> I read also the support ms doc #240867.
> So, what am I missing ? Thank you all.
> --
> David De Giacomi
> Microsoft MVP
> Blog @. http://blogs.dotnethell.it/david/
> http://www.dotnethell.it
>