Hello
In Reporting Services 2000, only the first result set returned from
stored procedure is recognized. Does anyone know if this is stil
true in Reporting Services 2005? It appears to be in beta 2, but
just want to make sure I'm not missing anything. Has anyone heare
that using multiple result sets from a stored procedure will be a
added featureI have not heard anything about that. If you are seeing the same
functionality in Beta 2 then my guess is that nothing has changed in this
area.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"erobert1" <robclark496@.msn-dot-com.no-spam.invalid> wrote in message
news:LN-dnWugPNVOC0HfRVn_vg@.giganews.com...
> Hello,
> In Reporting Services 2000, only the first result set returned from a
> stored procedure is recognized. Does anyone know if this is still
> true in Reporting Services 2005? It appears to be in beta 2, but I
> just want to make sure I'm not missing anything. Has anyone heared
> that using multiple result sets from a stored procedure will be an
> added feature?
>|||Hi
I logged a suggestion with Microsoft on this and will post thei
answer if I get one. In the mean time if anyone else has informatio
on this please post it here too|||Hi
I got a response from my post on the Microsoft product feedbac
center. It will be considered for a future release. If this featur
is important to you, you can vote for it at
http://lab.msdn.microsoft.com/productfeedback/viewFeedback.aspx?feedbackid=38a81133-5e82-4a31-a6b3-2877929373c
Showing posts with label recognized. Show all posts
Showing posts with label recognized. Show all posts
Wednesday, March 28, 2012
Friday, March 9, 2012
Reporting service not starting - The user or group name 'VIDICOM\ASPNET' is not recognized.
Hi, I've been trying for the past week to get SQL 2005 Server up and running.
The SQL is up and running however I am unable to get the Reporting service to start. The log file is below but the main line is:
The SQL is up and running however I am unable to get the Reporting service to start. The log file is below but the main line is:
ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:The user or group name 'VIDICOM\ASPNET' is not recognized.
But the domain user ASPNET is present. Similar posts across the internet mention about the .NET Framework not be installed correctly. I have reinstalled it many times.
Any help is most appreciated.
Tom
Here is the full log file:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\ReportServerService__main_06_29_2006_14_33_39.log</Path>
<SystemName>CRM</SystemName>
<OSName>Microsoft Windows NT 5.0.2195 Service Pack 4</OSName>
<OSVersion>5.0.2195.262144</OSVersion>
</Header>
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!29/06/2006-14:33:45:: Total Physical memory: 267894784
ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!29/06/2006-14:33:47:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
Dear,
From question and log poseted above it seems that the user u are using to start the reporting services doesnt have right to access the reporting databases .
Flow these steps
Browse to the reporting services configuration manager.
delete the encription keys if delete option is enabled in the ecription key section.
check report server virtual directory is connect to Reportserver$..... database
report manager virtual directoy to Reports$...... database
Windows service identity : Service account must be NT Authority / Network Service
In the database connection
confirm that the database connection is ReportServer$......
Then backup the Encription keys.
HTH
from
sufian
|||Thanks for the reply but it hasnt worked. In the reporting configuration manager I have ticks next to:Report Server Virtual Directory
Report Manager Virtual Directory
Windows Service Identity
Database Setup
Email Settings
Execution Account
But have crosses next to:
Server Status
Web Service Identity
Initialization
and an exclaimation mark next to encryption keys.
On the Database setup page, what should the credentials type be set to? and also how about the execution account?|||
Dear,
On the database setup page the credential should be set to service credentials.
Leave the exection account and email seeting this time first start the reporting services.
Delete the encription keys.
Tell me onething do u have namedstance installed on the server.
Regards
sufian
|||Hi there. If I understand correctly, you are using win2K, with SQL 2k5, and want to get Reporting Service to Start? (And this is a fresh install?)
have you seen this ? http://support.microsoft.com/default.aspx/kb/911846
It says that you should make your Rsreportserver.config file's <WebServiceAccount></WebServiceAccount> tag the IWAM_ComputerName for windows 2000.
Hope This helps
-Hoovie
P.S. Is you Server a Domain Controler? "For more information about potential problems running version 1.1 on a domain controller, see article Q824308, "IWAM Account is Not Granted the Impersonate Privilege for ASP.NET 1.1 on Windows 2000 Domain Controller with SP4," in the Microsoft Knowledge Base at http://support.microsoft.com. For more information about running version 1.0 of the .NET Framework on a domain controller, see article Q315158, "ASP.NET Does Not Work with the Default ASPNET Account on a Domain Controller," in the Microsoft Knowledge Base at http://support.microsoft.com."
Reporting service not starting - The user or group name 'VIDICOM\ASPNET' is not recognized.
Hi, I've been trying for the past week to get SQL 2005 Server up and running.
The SQL is up and running however I am unable to get the Reporting service to start. The log file is below but the main line is:
The SQL is up and running however I am unable to get the Reporting service to start. The log file is below but the main line is:
ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:The user or group name 'VIDICOM\ASPNET' is not recognized.
But the domain user ASPNET is present. Similar posts across the internet mention about the .NET Framework not be installed correctly. I have reinstalled it many times.
Any help is most appreciated.
Tom
Here is the full log file:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\ReportServerService__main_06_29_2006_14_33_39.log</Path>
<SystemName>CRM</SystemName>
<OSName>Microsoft Windows NT 5.0.2195 Service Pack 4</OSName>
<OSVersion>5.0.2195.262144</OSVersion>
</Header>
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!29/06/2006-14:33:45:: Total Physical memory: 267894784
ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!29/06/2006-14:33:47:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
Dear,
From question and log poseted above it seems that the user u are using to start the reporting services doesnt have right to access the reporting databases .
Flow these steps
Browse to the reporting services configuration manager.
delete the encription keys if delete option is enabled in the ecription key section.
check report server virtual directory is connect to Reportserver$..... database
report manager virtual directoy to Reports$...... database
Windows service identity : Service account must be NT Authority / Network Service
In the database connection
confirm that the database connection is ReportServer$......
Then backup the Encription keys.
HTH
from
sufian
|||Thanks for the reply but it hasnt worked. In the reporting configuration manager I have ticks next to:Report Server Virtual Directory
Report Manager Virtual Directory
Windows Service Identity
Database Setup
Email Settings
Execution Account
But have crosses next to:
Server Status
Web Service Identity
Initialization
and an exclaimation mark next to encryption keys.
On the Database setup page, what should the credentials type be set to? and also how about the execution account?|||
Dear,
On the database setup page the credential should be set to service credentials.
Leave the exection account and email seeting this time first start the reporting services.
Delete the encription keys.
Tell me onething do u have namedstance installed on the server.
Regards
sufian
|||Hi there. If I understand correctly, you are using win2K, with SQL 2k5, and want to get Reporting Service to Start? (And this is a fresh install?)
have you seen this ? http://support.microsoft.com/default.aspx/kb/911846
It says that you should make your Rsreportserver.config file's <WebServiceAccount></WebServiceAccount> tag the IWAM_ComputerName for windows 2000.
Hope This helps
-Hoovie
P.S. Is you Server a Domain Controler? "For more information about potential problems running version 1.1 on a domain controller, see article Q824308, "IWAM Account is Not Granted the Impersonate Privilege for ASP.NET 1.1 on Windows 2000 Domain Controller with SP4," in the Microsoft Knowledge Base at http://support.microsoft.com. For more information about running version 1.0 of the .NET Framework on a domain controller, see article Q315158, "ASP.NET Does Not Work with the Default ASPNET Account on a Domain Controller," in the Microsoft Knowledge Base at http://support.microsoft.com."
Reporting service not starting - The user or group name 'VIDICOM\ASPNET' is not recognized
Hi, I've been trying for the past week to get SQL 2005 Server up and running.
The SQL is up and running however I am unable to get the Reporting service to start. The log file is below but the main line is:
The SQL is up and running however I am unable to get the Reporting service to start. The log file is below but the main line is:
ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:The user or group name 'VIDICOM\ASPNET' is not recognized.
But the domain user ASPNET is present. Similar posts across the internet mention about the .NET Framework not be installed correctly. I have reinstalled it many times.
Any help is most appreciated.
Tom
Here is the full log file:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\ReportServerService__main_06_29_2006_14_33_39.log</Path>
<SystemName>CRM</SystemName>
<OSName>Microsoft Windows NT 5.0.2195 Service Pack 4</OSName>
<OSVersion>5.0.2195.262144</OSVersion>
</Header>
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!29/06/2006-14:33:41:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!29/06/2006-14:33:45:: Total Physical memory: 267894784
ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!29/06/2006-14:33:47:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
Dear,
From question and log poseted above it seems that the user u are using to start the reporting services doesnt have right to access the reporting databases .
Flow these steps
Browse to the reporting services configuration manager.
delete the encription keys if delete option is enabled in the ecription key section.
check report server virtual directory is connect to Reportserver$..... database
report manager virtual directoy to Reports$...... database
Windows service identity : Service account must be NT Authority / Network Service
In the database connection
confirm that the database connection is ReportServer$......
Then backup the Encription keys.
HTH
from
sufian
|||Thanks for the reply but it hasnt worked. In the reporting configuration manager I have ticks next to:Report Server Virtual Directory
Report Manager Virtual Directory
Windows Service Identity
Database Setup
Email Settings
Execution Account
But have crosses next to:
Server Status
Web Service Identity
Initialization
and an exclaimation mark next to encryption keys.
On the Database setup page, what should the credentials type be set to? and also how about the execution account?|||
Dear,
On the database setup page the credential should be set to service credentials.
Leave the exection account and email seeting this time first start the reporting services.
Delete the encription keys.
Tell me onething do u have namedstance installed on the server.
Regards
sufian
|||Hi there. If I understand correctly, you are using win2K, with SQL 2k5, and want to get Reporting Service to Start? (And this is a fresh install?)
have you seen this ? http://support.microsoft.com/default.aspx/kb/911846
It says that you should make your Rsreportserver.config file's <WebServiceAccount></WebServiceAccount> tag the IWAM_ComputerName for windows 2000.
Hope This helps
-Hoovie
P.S. Is you Server a Domain Controler? "For more information about potential problems running version 1.1 on a domain controller, see article Q824308, "IWAM Account is Not Granted the Impersonate Privilege for ASP.NET 1.1 on Windows 2000 Domain Controller with SP4," in the Microsoft Knowledge Base at http://support.microsoft.com. For more information about running version 1.0 of the .NET Framework on a domain controller, see article Q315158, "ASP.NET Does Not Work with the Default ASPNET Account on a Domain Controller," in the Microsoft Knowledge Base at http://support.microsoft.com."
Subscribe to:
Posts (Atom)