Showing posts with label internal. Show all posts
Showing posts with label internal. Show all posts

Tuesday, March 20, 2012

Post Installation error with RS2000 on Win2000 Server

Hello,

I have installed RS2000 with no errors, but when i browse to localhost/Reports i get an RS error page that reads:

"An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

The profile for the user is a temporary profile.

I have checked the LogFiles (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles) and the error message reads as follows:

aspnet_wp!ui!1608!22/03/2006-14:22:27:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Runtime.InteropServices.COMException (0x80090024): The profile for the user is a temporary profile.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
aspnet_wp!ui!1608!22/03/2006-14:22:27:: e ERROR: HTTP status code --> 200
-Details--
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Runtime.InteropServices.COMException (0x80090024): The profile for the user is a temporary profile.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String Item) at Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item) at Microsoft.ReportingServices.UI.Permissions.GetPermissions() at Microsoft.ReportingServices.UI.Permissions..ctor(String path) at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath) at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser() at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain()
aspnet_wp!ui!1608!22/03/2006-14:22:28:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Seen as how the only thing in this that makes any sense to me at all is the phrase "The profile for the user is a temporary profile", i assume that this has something significant to do with the problem. However, Knowing this, i'm still not sure what to do to fix it as i'm not a newtowork/server admin.

Also, this server is a domain controller on windows 2000 server with sp4

Can someone please help.

Robbie,

I'm running into the exact same error with the exact same scenario. Did you ever resolve this issue?

Thanks,

Beau Lynch

Post Installation error with RS2000 on Win2000 Server

Hello,

I have installed RS2000 with no errors, but when i browse to localhost/Reports i get an RS error page that reads:

"An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

The profile for the user is a temporary profile.

I have checked the LogFiles (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles) and the error message reads as follows:

aspnet_wp!ui!1608!22/03/2006-14:22:27:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Runtime.InteropServices.COMException (0x80090024): The profile for the user is a temporary profile.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
aspnet_wp!ui!1608!22/03/2006-14:22:27:: e ERROR: HTTP status code --> 200
-Details--
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Runtime.InteropServices.COMException (0x80090024): The profile for the user is a temporary profile.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String Item) at Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item) at Microsoft.ReportingServices.UI.Permissions.GetPermissions() at Microsoft.ReportingServices.UI.Permissions..ctor(String path) at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath) at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser() at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain()
aspnet_wp!ui!1608!22/03/2006-14:22:28:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Seen as how the only thing in this that makes any sense to me at all is the phrase "The profile for the user is a temporary profile", i assume that this has something significant to do with the problem. However, Knowing this, i'm still not sure what to do to fix it as i'm not a newtowork/server admin.

Also, this server is a domain controller on windows 2000 server with sp4

Can someone please help.

Robbie,

I'm running into the exact same error with the exact same scenario. Did you ever resolve this issue?

Thanks,

Beau Lynch

Monday, February 20, 2012

Ports

What ports would I need to open for a web server in a DMZ to communicate
with an internal SQL server?
Peter,
If it is a standard install you would need to open TCP port 1433 (the
default instance) and/or UDP port 1434 on the same ip if you have any apps
that Sql needs to listen for. If Sql is a named instance the port is
dynamically assigned when the instance is first started unless you set an
alternate port during setup. You can also configure/customize these values
using the Client Network Utility.
Hope this helps.
|||Thanks for the advice!
"Brian Brown" <BrianBrown@.discussions.microsoft.com> wrote in message
news:74EABE7C-8E6B-4467-8728-6BEC92BF678E@.microsoft.com...
> Peter,
> If it is a standard install you would need to open TCP port 1433 (the
> default instance) and/or UDP port 1434 on the same ip if you have any apps
> that Sql needs to listen for. If Sql is a named instance the port is
> dynamically assigned when the instance is first started unless you set an
> alternate port during setup. You can also configure/customize these
values
> using the Client Network Utility.
> Hope this helps.