Wednesday, March 28, 2012
How to assign Server roles to database role?
context) to a database role?
Thank you in advance,
LeonNo...but it isn't much work if you are using Windows Groups.
The Windows group can just be assigned to the database role
as well as the fixed server role.
-Sue
On Wed, 21 Mar 2007 09:23:21 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:
>Is there any way to assign a Server Fixed Role ("Security Admin" in this
>context) to a database role?
>Thank you in advance,
>Leonsql
Friday, March 23, 2012
How to allow FULLTEXT SEARCH INDEXING to non-admin user?
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help
Cheers
LuckyHelllooooo.....does anyone know abt it?sql
How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?
I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)
Hey
So no one knows abt it?
Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --
"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."
But logging with admin a/c it shows green Flag (started FullText Service)
Also does activating RPC service have any security issues.
Thanks :-)
Wednesday, March 21, 2012
How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?
I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)
Hey
So no one knows abt it?
Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --
"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."
But logging with admin a/c it shows green Flag (started FullText Service)
Also does activating RPC service have any security issues.
Thanks :-)
How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?
I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)
Hey
So no one knows abt it?
Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --
"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."
But logging with admin a/c it shows green Flag (started FullText Service)
Also does activating RPC service have any security issues.
Thanks :-)
How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?
I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)
Hey
So no one knows abt it?
Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --
"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."
But logging with admin a/c it shows green Flag (started FullText Service)
Also does activating RPC service have any security issues.
Thanks :-)
Sunday, February 19, 2012
how to access web.config
I am using vs2005 and have a solution file with 4 projects, 2 of which are presentation layers (admin sections), 1 is a business logic layer, the other a data access layer.
The data access layer project is simply a class library that will provide data access functionality. Im using a dataset (xsd) to create my data access objects. My question is how do I select a connection string from the web config file (which is in each of the presentation layer projects) as the data access layer is a class library there is no web.config. Using the connection string selector in the dataset wizard doesnt show any available connection strings.
Reference the System.Confiuration dll and you can use the System.Configuration classes to obtain this data.
In 1.1 you use the ConfigurationSettings class
in 2.0 you utilise the System.ConfigurationManager and this supports the System.ConfigurationManager.ConnectionStrings for <ConnectionStrings> entries.