Can't Administer

I am trying for the first time on this SQL server to use the FULL TEXT
SEARCH. I can successfully use it on other similar servers. When I try to
add a FULL TEXT CATALOG to a database I get this message when the wizard is
trying to do the work:
The Microsoft Search Service cannot be administered under the present
account.
I am logged in with an account in the Administrator group. The Search
Service is started. The server is itself is running with an account in the
Administrator group. I have checked and rechecked and everything I can think
of is the same as systems where I can make this work. I am likely missing
the obvious but can't find it. Any ideas.
Thanks
Tom G.
Can you verify that the MSSearch account is running under the local system
account. Has anyone modified the SQL Server service account through the
services applet in control panel as opposed to using EM? To fix this, right
click on your server in EM, select properties, click the security tab,
change it to run under the system account, bounce your SQL Server, and then
modify it again to run under a local admin account.
Also verify that no one has removed the builtin\admin account from the
system administrators role. To do this connect to your SQL Server in EM,
expand the security folder and expand the server roles node. Double click on
the system administrator role and ensure the builtin\administrators account
is present.
if not run the following in qa.
if not exists (select * from master.dbo.syslogins where
loginname = N'NT Authority\System')
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System',
N'us_english'
GO
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
GO
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Tom Groszko" <newscorrespondent@.charter.net> wrote in message
news:%238ktUtRmEHA.2504@.TK2MSFTNGP14.phx.gbl...
> I am trying for the first time on this SQL server to use the FULL TEXT
> SEARCH. I can successfully use it on other similar servers. When I try to
> add a FULL TEXT CATALOG to a database I get this message when the wizard
is
> trying to do the work:
> The Microsoft Search Service cannot be administered under the present
> account.
> I am logged in with an account in the Administrator group. The Search
> Service is started. The server is itself is running with an account in the
> Administrator group. I have checked and rechecked and everything I can
think
> of is the same as systems where I can make this work. I am likely missing
> the obvious but can't find it. Any ideas.
> Thanks
> Tom G.
>
|||I am curious as to whether this solved the problem. I am having the same
problem and can't seem to resolve. I am trying to execute
sp_fulltext_database in Query Analyzer and get the following error
.. Msg 7635 The Microsoft Search service cannot be administered under the
present user account
1) The builtin\admin account is a member of the System Administrators roles
2) The MSSearch service is running under a Local System account (Log On tab
in services). I have also tried the "This account" selection using a local
administrator account"
3) MSSQLSERVER service is running under a local admin account, changed
through EM per your instructions below. I have also tried running it under a
System Account.
4) I guess I am confused about what the correct combination for MSSearch
and SQL Server is with regards to accounts.
5) Any help would be greatly appreciated.
Thanks,
Tom Shalloe
"Hilary Cotter" wrote:

> Can you verify that the MSSearch account is running under the local system
> account. Has anyone modified the SQL Server service account through the
> services applet in control panel as opposed to using EM? To fix this, right
> click on your server in EM, select properties, click the security tab,
> change it to run under the system account, bounce your SQL Server, and then
> modify it again to run under a local admin account.
> Also verify that no one has removed the builtin\admin account from the
> system administrators role. To do this connect to your SQL Server in EM,
> expand the security folder and expand the server roles node. Double click on
> the system administrator role and ensure the builtin\administrators account
> is present.
> if not run the following in qa.
> if not exists (select * from master.dbo.syslogins where
> loginname = N'NT Authority\System')
> exec sp_grantlogin N'NT Authority\System'
> exec sp_defaultdb N'NT Authority\System', N'master'
> exec sp_defaultlanguage N'NT Authority\System',
> N'us_english'
> GO
> exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> GO
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Tom Groszko" <newscorrespondent@.charter.net> wrote in message
> news:%238ktUtRmEHA.2504@.TK2MSFTNGP14.phx.gbl...
> is
> think
>
>
|||Tom,
Is the master the default database for the BUILTIN\Administrator account as
well as a member of the Sysadmin role?
When you changed it to run under the System Account (LocalSystem) did you do
this via the Enterprise Manager's server security tab?
The Enterprise Manager code runs an internal system extended proc -
xp_updateFTSSQLAccount - when any change to the MSSQLServer account is
executed, this xp proc makes similar change to the MSSearch service as well.
You should review the following KB articles:
317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/default...b;en-us;317746
277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default...B;EN-US;277549
Regards,
John
"Shallotx" <Shallotx@.discussions.microsoft.com> wrote in message
news:35629999-FB98-4407-98C8-5307CF9EF861@.microsoft.com...
> I am curious as to whether this solved the problem. I am having the same
> problem and can't seem to resolve. I am trying to execute
> sp_fulltext_database in Query Analyzer and get the following error
> .. Msg 7635 The Microsoft Search service cannot be administered under
the
> present user account
> 1) The builtin\admin account is a member of the System Administrators
roles
> 2) The MSSearch service is running under a Local System account (Log On
tab
> in services). I have also tried the "This account" selection using a
local
> administrator account"
> 3) MSSQLSERVER service is running under a local admin account, changed
> through EM per your instructions below. I have also tried running it
under a[vbcol=seagreen]
> System Account.
> 4) I guess I am confused about what the correct combination for MSSearch
> and SQL Server is with regards to accounts.
> 5) Any help would be greatly appreciated.
> Thanks,
> Tom Shalloe
> "Hilary Cotter" wrote:
system[vbcol=seagreen]
right[vbcol=seagreen]
then[vbcol=seagreen]
click on[vbcol=seagreen]
account[vbcol=seagreen]
to[vbcol=seagreen]
wizard[vbcol=seagreen]
the[vbcol=seagreen]
missing[vbcol=seagreen]

CanShrink Question

Hello all,

I have a report with a dataset similar to this:

description0 35
description1 0
description2 0
description3 0
description4 0
description5 45
description6 0
description7 0
description8 50
description9 10
.....

I don't care to see the records with a zero numeric value so I've configured the two text boxes the list box to set their values to "nothing" if the numeric value is 0. I've also configured both text boxes canshrink property to true.

When the report renders, I get this:

desc. header numeric header
--
description0 35

description5 45

description8 50
description9 10
....

I get one blank line where the grouping of 0 valued numeric records are. That tells me the canshrink is working, somewhat. What I'm confused about is why the blank line and what I need to stuff into the text box value.

In this particular case, I can go back to the db stored proc and just omit the 0 valued records. But, that doesn't help me if I run into a situation where I don't have that option.

Any help would be appreciated,

Thanks in advance,

Greg Wilkerson

Well, I need to add something. I deployed this report and the can shrink does not work in the deployed version. Through BIDS, it works as described above.

Greg

|||Hi Greg.

I didn't fully understand the question but from what I understod - may be instead of changing the "canshrink" property you should try and change the "visibility" property if the value is zero (Also, you can try and change the width or height of the cells).

Good luck,
Roy.|||

Roy,

You understood things fine. The visibility settings did work out fine, and is a pretty clean implementation. I thought I had tried that in an earlier attempt but I guess didn't get something right. I'm going to have to figure out the intracacies of this canshrink property. And, this rendering differently in BIDS vs. the deployed report is troublesome.

But, I'll figure it out.

Thanks.