Hi,
My setup is that i have a IIS virtual directory with Anonymous user (
enable anonymous ) to access Reporting Server. Both are in same server
anyway.
I have a web page in the virtual directory with url link to the
Reprting Server.
if I grant this anonymous user with admin privilege , then it works.
Why ' what kind of privilege is needed in fact ? There are some clue
but i dont know how to intepret.
The error log from Event log is as below:
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 18/01/2006
Time: 10:41:23
User: NT AUTHORITY\NETWORK SERVICE
Computer: SVR071
Description:
The application-specific permission settings do not grant Local
Activation permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This
security permission can be modified using the Component Services
administrative tool.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.What is the configured identity of the 'ReportServer' service? Is it
interactive user? What is the security configuration for the
ReportServer virtual directory? What is the security configuration for
connecting to your SQL serrver?
If you're accessing the virutal directory as an anonymous user and the
RS service is configured to run as the interactive user, then the
interactive user (in this case anonymous) would need priviledges to
connect to SQL and any other necessary resources.
Andy Potter
Showing posts with label enable. Show all posts
Showing posts with label enable. Show all posts
Thursday, March 8, 2012
"Repeat report item with data region on every page" and Export PDF
Why elements with flag enable "Repeat report item with data region on every page" doesn't work with "Export PDF" ?
Anyone can say me why !??!?!
I have tried with ASP.NET and Local Reporting.
Hi Blackat.net,
I'm sorry that i'm so familiar with this issue. However i searched through internet and found a relevated post. Users their also said they cannot use "repeat report item with data region on every page" when exporting to to PDF file. I just wonder if it can give you some hints or do something helpful to you.
The thread is :http://forums.microsoft.com/msdn/showpost.aspx?postid=153680&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=0 (Wil Burton raised a qustion which seems resemble yours)
Wil Burton asked:I can't get this to work with a list. TheRepeatOnNewPageproperty for tables works,
butRepeat report item with data region on every page doesn't do anything.
Any help?
bluebunny answered:
Would using a parameter work instead? Did for me.
http://forums.microsoft.com/MSDN/showpost.aspx?postid=339319&siteid=1
Greg
Hope my suggestion helps
Thursday, February 16, 2012
"Full-Text Indexing" is Grayed Out, Disabled
I want to enable "Full-Text Indexing" in my Microsoft SQL Server 2000
database, except when I go into the SQL Server Enterprise Manager and
click on the "Tools" drop down menu in the tool bar, the option
"Full-Text Indexing" is grayed out (aka greyed out).
I think I need to start a service named MSSEARCH; however, when I go
into Start -> Settings -> Control Panel -> Administrative Tools ->
Services, I do not see any service whose name is close to "MSSEARCH".
I also tried `sqlftwiz` (SQL Full-Text Wizard) with several options,
but the closest I got was an error message stating "Cannot get
full-text default path from registry."
I also installed SQL Server Service Pack 3.
When I execute stored procedure `sp_fulltext_database 'enable'`, I get
this error message:
"Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
Line 46
Full-Text Search is not installed, or a full-text component cannot be
loaded"
Therefore, how do I get the "Full-Text Indexing" to no longer be
grayed out?
Or, how to I install, start or implement full-text indexing?
Sounds like SQL FTS has not been installed.
Put your SQL Server cd on the cd platter.
double click setup.bat from the cd. click next.
select local computer, click next.
select upgrade, remove, or add components to an existing instance of SQL
Server, click next.
select the instance you wish to add SQL FTS to, click next.
select add components to your existing installation, click next.
In the component section give focus to Server Component (it should be given
focus by default).
In the sub components section, select full text search, click next. click
next, and accept all remaining defaults.
<charismatic_evangelist@.yahoo.com> wrote in message
news:dd8e1652.0409081147.21b78b87@.posting.google.c om...
> I want to enable "Full-Text Indexing" in my Microsoft SQL Server 2000
> database, except when I go into the SQL Server Enterprise Manager and
> click on the "Tools" drop down menu in the tool bar, the option
> "Full-Text Indexing" is grayed out (aka greyed out).
> I think I need to start a service named MSSEARCH; however, when I go
> into Start -> Settings -> Control Panel -> Administrative Tools ->
> Services, I do not see any service whose name is close to "MSSEARCH".
> I also tried `sqlftwiz` (SQL Full-Text Wizard) with several options,
> but the closest I got was an error message stating "Cannot get
> full-text default path from registry."
> I also installed SQL Server Service Pack 3.
> When I execute stored procedure `sp_fulltext_database 'enable'`, I get
> this error message:
> "Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
> Line 46
> Full-Text Search is not installed, or a full-text component cannot be
> loaded"
> Therefore, how do I get the "Full-Text Indexing" to no longer be
> grayed out?
> Or, how to I install, start or implement full-text indexing?
|||C_E,
It is always a good idea to know what SQL Server version as well as Edition
is as the Full-Text Search (FTS) components are not supported on all SQL
Server 2000 Editions. See SQL Server 2000 Books Online (BOL) title "Features
Supported by the Editions of SQL Server 2000" as the "Microsoft Search
(MSSearch.exe) service is installed only with certain SQL Server editions.
Could you post the full output of the following SQL script?
select @.@.version
Installing SQL Server Service Pack 3 alone will not resolve this issue as
you will need to install the FTS components (if supported) and then
re-install SQL Server Service Pack 3 to fix any FTS bugs, issues, etc.
Depending upon the output of the sql script, you may be able to install the
FTS components from your SQL 2000 installation CD via custom installation
and select Full-Text Search under the server components list.
Regards,
John
<charismatic_evangelist@.yahoo.com> wrote in message
news:dd8e1652.0409081147.21b78b87@.posting.google.c om...
> I want to enable "Full-Text Indexing" in my Microsoft SQL Server 2000
> database, except when I go into the SQL Server Enterprise Manager and
> click on the "Tools" drop down menu in the tool bar, the option
> "Full-Text Indexing" is grayed out (aka greyed out).
> I think I need to start a service named MSSEARCH; however, when I go
> into Start -> Settings -> Control Panel -> Administrative Tools ->
> Services, I do not see any service whose name is close to "MSSEARCH".
> I also tried `sqlftwiz` (SQL Full-Text Wizard) with several options,
> but the closest I got was an error message stating "Cannot get
> full-text default path from registry."
> I also installed SQL Server Service Pack 3.
> When I execute stored procedure `sp_fulltext_database 'enable'`, I get
> this error message:
> "Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
> Line 46
> Full-Text Search is not installed, or a full-text component cannot be
> loaded"
> Therefore, how do I get the "Full-Text Indexing" to no longer be
> grayed out?
> Or, how to I install, start or implement full-text indexing?
|||Given that I had the same problem as charismatic_evangelist@.yahoo.com, I
tried the steps that you gave below. The instance of the Server that I
applied it to was the (local)(Windows NT) server, where my database resides.
Even after going through all the steps, and having turned SQL FTS on, the
full text search is still greyed out when I right click on the particular
table I need to be able to search. Any other ideas of what to do?
- MacL
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ukjtrBglEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Sounds like SQL FTS has not been installed.
> Put your SQL Server cd on the cd platter.
> double click setup.bat from the cd. click next.
> select local computer, click next.
> select upgrade, remove, or add components to an existing instance of SQL
> Server, click next.
> select the instance you wish to add SQL FTS to, click next.
> select add components to your existing installation, click next.
> In the component section give focus to Server Component (it should be
> given
> focus by default).
> In the sub components section, select full text search, click next. click
> next, and accept all remaining defaults.
>
|||Mac,
While you may have the same *symptoms* as Charismatic_Evangelist, you may or
may not have the same problem, especially as s/he never provided his/her SQL
Server 2000 version & edition info. It is always a good idea to know what
SQL Server version as well as Edition is as the Full-Text Search (FTS)
components are not supported on all SQL Server 2000 Editions. See SQL Server
2000 Books Online (BOL) title "Features Supported by the Editions of SQL
Server 2000" as the "Microsoft Search (MSSearch.exe) service is installed
only with certain SQL Server editions. Could you post the full output of the
following SQL script?
select @.@.version
You should also review the following KB article Q270671 (Q270671) "PRB: Full
Text Search Menus Are Not Enabled for Local Windows NT Accounts" at
http://support.microsoft.com/default...;en-us;q270671 depending
upon how you have the MSSQLServer service startup account setup.
If you did recently upgrade or install the FTS components, could you also
attach the following SQL setup log files: sqlstp.log (usually located at
C:\WINNT\Temp) and SearchSetup.log usually located at C:\WINNT\. These files
can also help in troubleshooting FTS installation issues.
Regards,
John
"Mac Littlefield" <warrenlittlefield@.sbcglobal.net> wrote in message
news:#Ai13dnpEHA.3708@.TK2MSFTNGP10.phx.gbl...
> Given that I had the same problem as charismatic_evangelist@.yahoo.com, I
> tried the steps that you gave below. The instance of the Server that I
> applied it to was the (local)(Windows NT) server, where my database
resides.[vbcol=seagreen]
> Even after going through all the steps, and having turned SQL FTS on, the
> full text search is still greyed out when I right click on the particular
> table I need to be able to search. Any other ideas of what to do?
> - MacL
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ukjtrBglEHA.2764@.TK2MSFTNGP11.phx.gbl...
click
>
|||There can be serveral causes of the Full-Text Index Table menu option not
being enabled
a.. SQL FTS is not enabled on this SQL server. Click here for instructions
on how to install SQL FTS on your SQL Server.
a.. You are not in the dbo role for this database
a.. The System Administrator role is not in the Local Administrators group
for this machine or the NTAuthority\Logon group is not in the System
Administrators group.
If you remove BUILTIN\Administrators and Full Text is enabled, add a login
account for the Local System account using sp_grantlogin [NT
Authority\System], and ensure that the login account is a member of the
sysadmin fixed server role. Here is some sample TSQL code to do this:
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
a.. Something else yet undetermined. Microsoft acknowledges this problem in
this kb article
(http://support.microsoft.com/default...1&Product=sql2
k) and recommends that you use the full text stored procedures to manage
your catalog or tables.
When I run across this problem (I don't run across is often as typically I
use the full text stored procedures) I normally use the SQLFTSWiz.exe
program which can be found by default in: C:\Program Files\Microsoft SQL
Server\80\Tools\Binn you can launch it by opening a command prompt and
typing for NT Authentication:
sqlftwiz /n /sSQLServerName[\InstanceName] /dpubs
or for SQL Authentication:
sqlftwiz /sSQLServerName[\InstanceName] /dpubs /uAccount /pPassword
In both of the above examples, SQLServerName[\InstanceName] is the name of
the SQL Server you wish to connect to. If you are using the default instance
you would use the below:
sqlftwiz /sSQLServerName /dpubs /uAccount /pPassword
If you are using an instance, other than the default instance you would use
the below (where InstanceName is the name of the instance you are using):
sqlftwiz /sSQLServerName\InstanceName /dpubs /uAccount /pPassword
Pubs is the database you wish to create your full text table in.
The dialogs you get are for the most part identical to the dialogs you would
get if you were to just right click on a table. After the initial splash
screen select the table you wish to index. The rest of the dialogs are
identical to the dialogs you will see if you were to right click on a table
in EM and select Full Text Index table.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Mac Littlefield" <warrenlittlefield@.sbcglobal.net> wrote in message
news:%23Ai13dnpEHA.3708@.TK2MSFTNGP10.phx.gbl...
> Given that I had the same problem as charismatic_evangelist@.yahoo.com, I
> tried the steps that you gave below. The instance of the Server that I
> applied it to was the (local)(Windows NT) server, where my database
resides.[vbcol=seagreen]
> Even after going through all the steps, and having turned SQL FTS on, the
> full text search is still greyed out when I right click on the particular
> table I need to be able to search. Any other ideas of what to do?
> - MacL
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ukjtrBglEHA.2764@.TK2MSFTNGP11.phx.gbl...
click
>
database, except when I go into the SQL Server Enterprise Manager and
click on the "Tools" drop down menu in the tool bar, the option
"Full-Text Indexing" is grayed out (aka greyed out).
I think I need to start a service named MSSEARCH; however, when I go
into Start -> Settings -> Control Panel -> Administrative Tools ->
Services, I do not see any service whose name is close to "MSSEARCH".
I also tried `sqlftwiz` (SQL Full-Text Wizard) with several options,
but the closest I got was an error message stating "Cannot get
full-text default path from registry."
I also installed SQL Server Service Pack 3.
When I execute stored procedure `sp_fulltext_database 'enable'`, I get
this error message:
"Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
Line 46
Full-Text Search is not installed, or a full-text component cannot be
loaded"
Therefore, how do I get the "Full-Text Indexing" to no longer be
grayed out?
Or, how to I install, start or implement full-text indexing?
Sounds like SQL FTS has not been installed.
Put your SQL Server cd on the cd platter.
double click setup.bat from the cd. click next.
select local computer, click next.
select upgrade, remove, or add components to an existing instance of SQL
Server, click next.
select the instance you wish to add SQL FTS to, click next.
select add components to your existing installation, click next.
In the component section give focus to Server Component (it should be given
focus by default).
In the sub components section, select full text search, click next. click
next, and accept all remaining defaults.
<charismatic_evangelist@.yahoo.com> wrote in message
news:dd8e1652.0409081147.21b78b87@.posting.google.c om...
> I want to enable "Full-Text Indexing" in my Microsoft SQL Server 2000
> database, except when I go into the SQL Server Enterprise Manager and
> click on the "Tools" drop down menu in the tool bar, the option
> "Full-Text Indexing" is grayed out (aka greyed out).
> I think I need to start a service named MSSEARCH; however, when I go
> into Start -> Settings -> Control Panel -> Administrative Tools ->
> Services, I do not see any service whose name is close to "MSSEARCH".
> I also tried `sqlftwiz` (SQL Full-Text Wizard) with several options,
> but the closest I got was an error message stating "Cannot get
> full-text default path from registry."
> I also installed SQL Server Service Pack 3.
> When I execute stored procedure `sp_fulltext_database 'enable'`, I get
> this error message:
> "Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
> Line 46
> Full-Text Search is not installed, or a full-text component cannot be
> loaded"
> Therefore, how do I get the "Full-Text Indexing" to no longer be
> grayed out?
> Or, how to I install, start or implement full-text indexing?
|||C_E,
It is always a good idea to know what SQL Server version as well as Edition
is as the Full-Text Search (FTS) components are not supported on all SQL
Server 2000 Editions. See SQL Server 2000 Books Online (BOL) title "Features
Supported by the Editions of SQL Server 2000" as the "Microsoft Search
(MSSearch.exe) service is installed only with certain SQL Server editions.
Could you post the full output of the following SQL script?
select @.@.version
Installing SQL Server Service Pack 3 alone will not resolve this issue as
you will need to install the FTS components (if supported) and then
re-install SQL Server Service Pack 3 to fix any FTS bugs, issues, etc.
Depending upon the output of the sql script, you may be able to install the
FTS components from your SQL 2000 installation CD via custom installation
and select Full-Text Search under the server components list.
Regards,
John
<charismatic_evangelist@.yahoo.com> wrote in message
news:dd8e1652.0409081147.21b78b87@.posting.google.c om...
> I want to enable "Full-Text Indexing" in my Microsoft SQL Server 2000
> database, except when I go into the SQL Server Enterprise Manager and
> click on the "Tools" drop down menu in the tool bar, the option
> "Full-Text Indexing" is grayed out (aka greyed out).
> I think I need to start a service named MSSEARCH; however, when I go
> into Start -> Settings -> Control Panel -> Administrative Tools ->
> Services, I do not see any service whose name is close to "MSSEARCH".
> I also tried `sqlftwiz` (SQL Full-Text Wizard) with several options,
> but the closest I got was an error message stating "Cannot get
> full-text default path from registry."
> I also installed SQL Server Service Pack 3.
> When I execute stored procedure `sp_fulltext_database 'enable'`, I get
> this error message:
> "Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
> Line 46
> Full-Text Search is not installed, or a full-text component cannot be
> loaded"
> Therefore, how do I get the "Full-Text Indexing" to no longer be
> grayed out?
> Or, how to I install, start or implement full-text indexing?
|||Given that I had the same problem as charismatic_evangelist@.yahoo.com, I
tried the steps that you gave below. The instance of the Server that I
applied it to was the (local)(Windows NT) server, where my database resides.
Even after going through all the steps, and having turned SQL FTS on, the
full text search is still greyed out when I right click on the particular
table I need to be able to search. Any other ideas of what to do?
- MacL
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ukjtrBglEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Sounds like SQL FTS has not been installed.
> Put your SQL Server cd on the cd platter.
> double click setup.bat from the cd. click next.
> select local computer, click next.
> select upgrade, remove, or add components to an existing instance of SQL
> Server, click next.
> select the instance you wish to add SQL FTS to, click next.
> select add components to your existing installation, click next.
> In the component section give focus to Server Component (it should be
> given
> focus by default).
> In the sub components section, select full text search, click next. click
> next, and accept all remaining defaults.
>
|||Mac,
While you may have the same *symptoms* as Charismatic_Evangelist, you may or
may not have the same problem, especially as s/he never provided his/her SQL
Server 2000 version & edition info. It is always a good idea to know what
SQL Server version as well as Edition is as the Full-Text Search (FTS)
components are not supported on all SQL Server 2000 Editions. See SQL Server
2000 Books Online (BOL) title "Features Supported by the Editions of SQL
Server 2000" as the "Microsoft Search (MSSearch.exe) service is installed
only with certain SQL Server editions. Could you post the full output of the
following SQL script?
select @.@.version
You should also review the following KB article Q270671 (Q270671) "PRB: Full
Text Search Menus Are Not Enabled for Local Windows NT Accounts" at
http://support.microsoft.com/default...;en-us;q270671 depending
upon how you have the MSSQLServer service startup account setup.
If you did recently upgrade or install the FTS components, could you also
attach the following SQL setup log files: sqlstp.log (usually located at
C:\WINNT\Temp) and SearchSetup.log usually located at C:\WINNT\. These files
can also help in troubleshooting FTS installation issues.
Regards,
John
"Mac Littlefield" <warrenlittlefield@.sbcglobal.net> wrote in message
news:#Ai13dnpEHA.3708@.TK2MSFTNGP10.phx.gbl...
> Given that I had the same problem as charismatic_evangelist@.yahoo.com, I
> tried the steps that you gave below. The instance of the Server that I
> applied it to was the (local)(Windows NT) server, where my database
resides.[vbcol=seagreen]
> Even after going through all the steps, and having turned SQL FTS on, the
> full text search is still greyed out when I right click on the particular
> table I need to be able to search. Any other ideas of what to do?
> - MacL
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ukjtrBglEHA.2764@.TK2MSFTNGP11.phx.gbl...
click
>
|||There can be serveral causes of the Full-Text Index Table menu option not
being enabled
a.. SQL FTS is not enabled on this SQL server. Click here for instructions
on how to install SQL FTS on your SQL Server.
a.. You are not in the dbo role for this database
a.. The System Administrator role is not in the Local Administrators group
for this machine or the NTAuthority\Logon group is not in the System
Administrators group.
If you remove BUILTIN\Administrators and Full Text is enabled, add a login
account for the Local System account using sp_grantlogin [NT
Authority\System], and ensure that the login account is a member of the
sysadmin fixed server role. Here is some sample TSQL code to do this:
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
a.. Something else yet undetermined. Microsoft acknowledges this problem in
this kb article
(http://support.microsoft.com/default...1&Product=sql2
k) and recommends that you use the full text stored procedures to manage
your catalog or tables.
When I run across this problem (I don't run across is often as typically I
use the full text stored procedures) I normally use the SQLFTSWiz.exe
program which can be found by default in: C:\Program Files\Microsoft SQL
Server\80\Tools\Binn you can launch it by opening a command prompt and
typing for NT Authentication:
sqlftwiz /n /sSQLServerName[\InstanceName] /dpubs
or for SQL Authentication:
sqlftwiz /sSQLServerName[\InstanceName] /dpubs /uAccount /pPassword
In both of the above examples, SQLServerName[\InstanceName] is the name of
the SQL Server you wish to connect to. If you are using the default instance
you would use the below:
sqlftwiz /sSQLServerName /dpubs /uAccount /pPassword
If you are using an instance, other than the default instance you would use
the below (where InstanceName is the name of the instance you are using):
sqlftwiz /sSQLServerName\InstanceName /dpubs /uAccount /pPassword
Pubs is the database you wish to create your full text table in.
The dialogs you get are for the most part identical to the dialogs you would
get if you were to just right click on a table. After the initial splash
screen select the table you wish to index. The rest of the dialogs are
identical to the dialogs you will see if you were to right click on a table
in EM and select Full Text Index table.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Mac Littlefield" <warrenlittlefield@.sbcglobal.net> wrote in message
news:%23Ai13dnpEHA.3708@.TK2MSFTNGP10.phx.gbl...
> Given that I had the same problem as charismatic_evangelist@.yahoo.com, I
> tried the steps that you gave below. The instance of the Server that I
> applied it to was the (local)(Windows NT) server, where my database
resides.[vbcol=seagreen]
> Even after going through all the steps, and having turned SQL FTS on, the
> full text search is still greyed out when I right click on the particular
> table I need to be able to search. Any other ideas of what to do?
> - MacL
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ukjtrBglEHA.2764@.TK2MSFTNGP11.phx.gbl...
click
>
Subscribe to:
Posts (Atom)
