Web Interface for Resource Manager 2.0

Got Citrix Resource Manager? Try out Web Interface for Resource Manager! Web Interface for Resource Manager is an ASP.NET 2.0 web application that contains several SQL queries to display useful information contained in the Citrix Resource Manager Summary Database.

version 2.0

Got Citrix Resource Manager?  Try out Web Interface for Resource Manager!

Web Interface for Resource Manager is an ASP.NET 2.0 web application that contains several SQL queries to display useful information contained in the Citrix Resource Manager Summary Database.  Web Interface for Resource Manager displays this information in a drill-down graphical and tabular manner.

What’s new in version 2.0?
Web Interface for Resource Manager version 2.0 includes everything in version 1.2, plus the following new features:

  • Concurrent usage of applications report
    See the concurrent usage of you applications within a specified date range. Also, this report will show you when the maximum number of concurrent sessions was reached.
  • Server metrics report
    See captured metrics for a particular server on a specified date. Any metrics you capture via the Citrix Presentation Server Console will be reported here.
  • Concurrent usage of servers report
    See how many concurrent sessions you are getting per server within a date range. This report will also show you when this max count was reached. Clicking on a row in this report will take you to the server metrics report for the particular date you reached the max count – showing you how your server was performing under the load.
  • Exporting reports
    You can now export reports to CSV for further analysis using an application such as Microsoft Excel
  • New calendar filtering option
    A new option on the Usage Calendar allows you to view all sessions that started per hour on a given day, or just unique users per hour. For example, if user1 started 2 or more sessions during the 11:00 hour, user1 would only be counted one time.

  Download Web Interface for Resource Manager version 2.0 (for Presentation Server 3.0 and above) 

What’s on the radar for the future?

  • Graphical configuration – no more editing Web.Config by hand.
  • Multiple language support.
  • Oracle Database support.
  • And, of course, more reports.

Known issues

If all database tables are not owned by dbo, you will receive errors. For more explanation on this phenomenon, see this article.

If you do not properly set up your database authentication, you will not be able to view any reports. Please refer to this article for database authentication guidelines.

Note: Version 2.0 is only intended for Presentation Server 3.0 and above. This is due to the differences in the Resource Manager Summary Database schema.  The MetaFrame XP Summary Database schema does not include the tables necessary to generate these new reports. Please use Web Interface for Resource Manager Version 1.1 for MetaFrame XP.

Screen Shots of Web Interface for Resource Manager

New buttons on the Sessions by Hour graph to show all sessions or just unique user sessions
(filters out multiple sessions started by the same user in the same hour).

Click to enlarge

Report showing max concurrent sessions per server and the date this max count was reached.

Click to enlarge

Report showing server metrics for a specified day.

Click to enlarge

Author: Jason Conger

Hey there. Hope you like the site.

73 thoughts on “Web Interface for Resource Manager 2.0”

  1. 1st of all – Great Job. Love the tool. Better than what Citrix has pushed out for the stuff lately.

    Here are some feature requests:

    – Export to Excel for every report. (example: Click on all users of a specific client version, then export the user list.
    – Since Client versions are also workstation specific (and the workstation is the one that must be upgraded), it would be good to also have a Clients by Workstation report also.

  2. Great little application. (Ok not so little). New version has added some great functionality. Only issue was with the DBO owner so until I can get my DBA’s to fix I changed the queries to use citrix.tablename instead of dbo.tablename. Thanks to Jason for the help. Keep up the good work.

  3. Thank you again Jason for listening to us and taking the time to put this application together. I can’t tell you how much value this provides my organization. The ability for me to be able to tell application owners that they can drill down into the usage of their applications on their own without my interaction is a big deal. Keep up the good work!

  4. Jason,

    When I click All Unique users I get a lovely graph saying 5 at 9:00am but when I click on it there could be more than 5 unique users.

  5. I’m in the Central Time Zone, but for some reason I need to put -2 in this value for the times to match up with what I see on the Citrix Resource Manager Graphs.

    If I have 20% processor utilization at 12:00 noon, what does that actually represent? Is that a snapshot of processor util at noon, or is it an average for the hour or what?

    Thanks for all your effort on this project!

  6. The way the time zones are handled is as follows:
    1) if you specify a UTC offset in Web.Config, that offset is used.
    2) if no UTC offset is specified, a JavaScript function determines your local machine’s UTC offset and uses it.

    The Processor Utilization at 12:00 noon represents the highest metric count recorded for that counter. Keep in mind that Resource Manager only periodically samples metrics and there may be some spikes not caught by RM. Web Interface for Resource Manager can only report on what RM wrote to the Summary Database database.

  7. Are you seeing this limitation on the Usage Calendar, or on the calendar popup selectors to specify a date range?

    The calendar popup selectors use an algorithm to find the oldest and newest dates recorded in your RM summary DB and limits the choices to days between these dates.

  8. Jason,

    I like the Unique Users Button to filter out multiple launches but being that the button is not available on the Usage Calendar I still have to manually tabulate the number of Unique users for a given application.

    For example, I at the Usage Calendar and I select “Application A” in the filter options. That displays the Session Count for the application. If I click that I get redirected to the Graph view showing number of sessions per hour. There is a option to filter by Unique users but when I select it, no total is displayed. I have to manually calculate by adding every hour together. Also, when selecting “Unique Users” the title of the Graph remains “Number of Sessions…”.

    I would also like to see unique user information per application for a Date Range. for example: “Application A” had 320 Unique Users in the last 30 days.

    J.

  9. How is the Concurrent Sessions max count on the Concurrent Usage page derived?

    I’m assuming that it’s the maximum sum of the active and inactive sessions for the Terminal Services object for a given time period (hour).

    Am I making a wildly wrong assumption?
    I’m trying to understand how all the stats fit together.

  10. Hi Don’t know how much you want…

    So

    Server Error in ‘/RMS2’ Application.
    ——————————————————————————–

    Runtime Error
    Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

    Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a “web.config” configuration file located in the root directory of the current web application. This tag should then have its “mode” attribute set to “Off”.

    You can email direct at quintin dot smith at unn dot ac dot uk

  11. Calculating concurrent usage is logically a simple process but a complex coding process. Basically, the logic works like this:

    1) create a counter variable and set it to 0
    2) select the first session start time in the date range specified
    3) select the count of all other sessions that happened within this sessions start and end time
    4) if the count is greater than the variable, set the variable to this new count
    5) select the next session within the date range specified
    6) repeat steps 3 – 5 for all remaining sessions

    Note: this is the logic followed, but there are some coding “acrobatics” to make performance efficient.

    The Terminal Services object counter is a sampling of Microsoft’s Performance Monitor (perfmon.exe) data.

  12. i see.
    thanks for that jason.

    how would that be different to simply summing the terminal services active/inactive session count and getting the max sum for each hour?
    ie: does a citrix session = a terminal service session?

  13. There are a couple of distinctions.

    First, sessions that happen in the same hour are not necessarily concurrent. For example, take the following 3 sessions:

    Session A: Start = 08:35; End = 11:30
    Session B: Start = 8:00; End = 8:30
    Session C: Start = 10:00; End = 11:45

    Note that Session A and Session B are active in the same hour, but they are not concurrent. Also note that Session A and Session C are concurrent but span more than one hour.

    Second, I do not want to rely on a metric counter to calculate concurrent usage for a couple of reasons. One reason is the metric counters are only samplings taken at a timed interval and written to a text file hourly (meaning some data may be missed due to the sampling period). The other reason is metrics are configurable per server and can be deleted. I can safely rely on the SDB_SESSION table because there is no way to tamper with this table through the Citrix management consoles.

  14. When I use a SQL ID, I am able to get reports. However, when I use an AD ID, it constantly tells me that there is a logon failure, even when I use an admin of the box (and a built-in admin of the SQL server). Any suggestions?

  15. Excellent application. Only trouble is, I can only see up until 4th October. I believe this is the date when I first installed version 1.2. I have installed version 2 and I can still only see upto 4th Oct. I reinstalled 1.2 and again can only see upto 4th Oct. No error messages come up. Any ideas?

  16. There are 2 example connection strings in Web.Config (1 for Integrated (AD) Authentication, and 1 for SQL Authentication). If you want to use a Windows account, you must use the Integrated Authentication connection string. Using this connection string, the local workstation’s credentials are presented to the SQL DB. If you want to use a Windows account that is different from the local workstation’s credentials, you must add an impersonate section to Web.Config. To do this, add the following immediately after <system.web> in Web.Config:

    <identity impersonate=”true” userName=”domain\username” password=”password”/>

  17. Are you seeing this limitation on the Usage Calendar, or on the calendar popup selectors to specify a date range?

    The calendar popup selectors use an algorithm to find the oldest and newest dates recorded in your RM summary DB and limits the choices to days between these dates.

  18. Great app, I had already created a similar application to what Jason has done, but jason has done a better job, I have added a couple of tables into my summary database that allows me to report users by Budget code. Is there a way that people can create custom reports and have them as addon without have to change your code each time that you release a new version.

  19. this is a real great app. On my whishlist I would have reporting of the different Servermetrics within one Graph with free combination of the required. For example have Memory; CPU + active Terminal sessions combined into one server metrics report.

  20. Getting the following error when I click on the clients for reports:

    Invalid object name ‘dbo.SDB_CLIENTHISTORY’. Invalid object name ‘dbo.LU_CLIENTPROPERTIES’. Invalid object name ‘dbo.LU_CLIENTTYPEMAPPINGS’.

    ————

    Get the following when I try and run the server metrics:

    Server Error in ‘/RM’ Application.
    ——————————————————————————–

    Runtime Error
    Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

    Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a “web.config” configuration file located in the root directory of the current web application. This tag should then have its “mode” attribute set to “Off”.

    Notes: The current error page you are seeing can be replaced by a custom error page by modifying the “defaultRedirect” attribute of the application’s configuration tag to point to a custom error page URL.

  21. Jason,

    This is great (again)! Just keeps getting better and better. I especially like the Server Metrics. I wonder if you have considered doing the same sort of thing for application metrics (count)? I know not everyone sets them up but we are big users of published desktops and having graphs of the metrics I have set up for the applications would be useful.

  22. There are two things to check here. First, make sure you are using PS 3.0 or above. The tables you reference do not exist in lower versions. Second, make sure the owner of the SQL tables is dbo.

  23. The application dynamically pulls data it needs to display, so database size is not a major factor. That being said, you may run in to some delays trying to pull data from large date ranges (especially the concurrent usage reports since they are more intensive).

  24. Under server metrics, if I show the available memory for a given server in my farm, it shows 3,000,000 (3GB) on the left side, but all the bullets below that (4 of them) are listed as 0,000,000? Any idea why this would occur? If you hover over the data points in the graph they appear to give a correct number (not 0,000,000 or null).

  25. Hi, we use anonymous authentication for a silo that we have. This means that duplicate usernames are seen in the PS console, so Anon001 may be logged into one server and another server may have a user logged into it (different user) but the username is Anon001. How does Resource Manager treat this in the database? Is this counted as two connections in the unique sessions metrics listed in the web interface or as a single connection? It does not appear to differentiate connections for this case.

  26. Thanks for the great work on this product Jason. It is a great tool. I have one feature request that could be considered for a future release (export to PDF and the ability to export the bar/pie charts to excel or PDF as I believe it exports data but no chart currently).

  27. It doesn’t appear that a title tag was defined for the “Users” module. When I click on the Users module, the Title of the site is “Untitled”. The rest of the modules have the title tag “Web Interface for Resource Manager”

  28. As requested above by another user for a future feature request, it would be great to have the ability to report/view statistics for Resource Manager Applications as well as these are often used in environments with published desktops.

  29. Looks like this code is missing in line 1 from userreport.aspx file.

    Title=”Web Interface for Resource Manager – User Report”

  30. For some reason it defaults to midnight to about 2 pm for the x axis range on the Server Metrics page. If you select a date and click submit it will default to a 24 hour period. It would be preferrable to have it default to a 24 hour period by default on the first view, rather than what appears to be a 14 hour view approx.

  31. Definately seems like a scaling issue on the Y axis, as this is an issue with metrics that have a small count. Such as if you have only 1 inactive terminal service sessions, the Y axis shows data points of 1,1,1,0,0,0.

  32. It would be excellent to be able to view a line graph that shows concurrent usage for a specific application for a specified period of time. This is a report we often need to generate. This is opposed to a maximum number of concurrent session for a given application which is one of the reports available.

  33. First – Great app Jason – kudos.

    We are getting this error in our production web environment, using impersonation. I checked the rights on the %windir%/temp, as MS siggests, and the imprsonated user has full control. The Temp directory under the Framework version also has the correct permissions. The impersonated user is a member of the local admin’s group.

    Can you think of anything else we should look for on this error? Here’s a dump of it –
    Could not load file or assembly ‘conuse’ or one of its dependencies. Access is denied.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.IO.FileLoadException: Could not load file or assembly ‘conuse’ or one of its dependencies. Access is denied.

  34. I need some help please. I’ve tried installing it on both Server 2003 with IIS 6.0 and XP Pro with IIS 5.1. If the summary database is not named rmsummarydb, is that a show stopper? For some reason ours is named Citrix ReportsDB. I tried changing Web.Config to the correct name with SQL authentication, using both the IP and name of the SQL box and I can never the page to open.

    Please Help!!

  35. Here is my web.config file contents:

    The sql server is specified as well as sql authentication info. I went to the database connection server and verified the sql login info in the dsn and tested it, it is correct.
    I get the “You are not authorized to view this page error”.

  36. The only change I made to Web.Config was in the SQL authentication section, I changed the name of the server, user, password and initial catalog. I changed initial catalog to citrixreportsdb because the summary database is named CitrixReports

  37. The message “You are not authorized to view this page” is an IIS error. Make sure Default.aspx is your default document on your web site hosting Web Interface for Resource Manager.

  38. It will be really convenient to list another column in the “client” module that lists the computername next to the username rather than having to click on the username to find out which computer they were connecting from. Also, to be able to export the list of computers/users using a specific citrix client version to excel would be really nice.

  39. This looks like the product I have been looking for, but I am having some installation problems. It is set on a W2K3 SP1 IIS server with a SQL2000 summary database, on a MPS 4.0 Farm; I get a Line 42: error when I try to pull up the page.

    Please forward any suggestions, I would really be interested in seeing if it can pull the concurrent license report I have been looking for.

    Thank you!

  40. Can you please post the error message (including which .aspx file it occurred in)?

    As far as the concurrent license report goes, that information is not in the summary database, but I am experimenting with some WMI calls to get this information.

  41. This is entire error message when you try to pull up the default webpage:

    Server Error in ‘/Reporting’ Application.
    ——————————————————————————–

    Configuration Error
    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: Theme ‘WIRM’ cannot be found in the application or global theme directories.

    Source Error:

    Line 41:
    Line 42:
    Line 43:
    Line 44:
    Line 45:

    Source File: C:\Inetpub\wwwroot\Reporting\web.config Line: 43

    ——————————————————————————–
    Below is the event log flagged for this error. Please let me know if you need additional information.

    Event code: 3008
    Event message: A configuration error has occurred.
    Event time: 12/5/2006 10:44:52 AM
    Event time (UTC): 12/5/2006 6:44:52 PM
    Event ID: e154cad8b68847afbb7ab666255b0f27
    Event sequence: 6
    Event occurrence: 1
    Event detail code: 0

    Application information:
    Application domain: /LM/W3SVC/1/Root/Reporting-1-128098178912521035
    Trust level: Full
    Application Virtual Path: /Reporting
    Application Path: C:\Inetpub\wwwroot\Reporting\
    Machine name: SERVERNAME

    Process information:
    Process ID: 7896
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE

    Exception information:
    Exception type: ConfigurationErrorsException
    Exception message: Theme ‘WIRM’ cannot be found in the application or global theme directories. (C:\Inetpub\wwwroot\Reporting\web.config line 43)

    Request information:
    Request URL: http://localhost/reporting/Default.aspx
    Request path: /reporting/Default.aspx
    User host address: 127.0.0.1
    User: DomainName\Account01
    Is authenticated: True
    Authentication Type: Negotiate
    Thread account name: DomainName\Account02

    Thread information:
    Thread ID: 1
    Thread account name: DomainName\Account02
    Is impersonating: True
    Stack trace: at System.Web.Configuration.PagesSection.get_ThemeInternal()
    at System.Web.UI.PageParser.ProcessConfigSettings()
    at System.Web.UI.TemplateParser.PrepareParse()
    at System.Web.UI.TemplateParser.Parse()
    at System.Web.Compilation.BaseTemplateBuildProvider.get_CodeCompilerType()
    at System.Web.Compilation.BuildProvider.GetCompilerTypeFromBuildProvider(BuildProvider buildProvider)
    at System.Web.Compilation.BuildProvidersCompiler.ProcessBuildProviders()
    at System.Web.Compilation.BuildProvidersCompiler.PerformBuild()
    at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath)
    at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)
    at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)
    at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean noAssert)
    at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert)
    at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)
    at System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)
    at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig)
    at System.Web.HttpApplication.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Custom event details:

    For more information, see Help and Support Center at

  42. Here is what gets display when I try to launch Server Metrics.

    Server Error in ‘/wi_access’ Application.
    ——————————————————————————–

    Invalid object name ‘dbo.LU_SERVER’.
    Invalid object name ‘dbo.LU_SERVERNAME’.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: Invalid object name ‘dbo.LU_SERVER’.
    Invalid object name ‘dbo.LU_SERVERNAME’.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [SqlException (0x80131904): Invalid object name ‘dbo.LU_SERVER’.
    Invalid object name ‘dbo.LU_SERVERNAME’.]
    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857418
    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735030
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
    System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
    System.Data.SqlClient.SqlDataReader.get_MetaData() +62
    System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
    System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
    System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
    System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
    System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7
    System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141
    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
    System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
    System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +92
    System.Web.UI.WebControls.ListControl.PerformSelect() +31
    System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
    System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
    System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26
    System.Web.UI.Control.PreRenderRecursiveInternal() +77
    System.Web.UI.Control.PreRenderRecursiveInternal() +161
    System.Web.UI.Control.PreRenderRecursiveInternal() +161
    System.Web.UI.Control.PreRenderRecursiveInternal() +161
    System.Web.UI.Control.PreRenderRecursiveInternal() +161
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
    Any Ideas? My SQL users is dbo over database and tables.

  43. Is the owner of the tables dbo?

    Open your SQL Enterprise Manager and browse to your Summary Database. Click on the “Tables” node and look at the list of tables in the details. The owner column should say dbo for all tables.

  44. Yes I have to admit that they orginally were not, after I changed them to dbo the Server Metric tab started to work.
    Now that that is working when I click on Concurrent Usage I get Object reference not set to an instance of an object. I thought this was working prior to changing ownership of the tables but I’m not 100% positive.

  45. Hi,

    I created your Webinterface directly as a site and not as a virtual directory.
    I also changed the portnumber.
    The site itself is working correctly. Only problem is that no image or graphs are displayed. In the addressbar the URL is changed to (for example):
    http://website:86/(S(jhwgsert78weg))/apps.ConcurrentUsagase.aspx

    Any ideas?

  46. I keep getting the following error; please help! I have tried many, many different settings.

    Line 40:
    Line 41:
    Line 42:
    Line 43:
    Line 44:

  47. Hi everyone. I just installed and configured version 2.0. But when I browse to the web server, I get the following error on the the initial screen: “Directory Listing Denied –
    This Virtual Directory does not allow contents to be listed.”

    Any thoughts as to what I am doing wrong? Any help would be greatly appreciated.

    Thanks!

  48. Jason, made sure that the Default.aspx is set, but now I get an error “The page cannot be found”.

    Should I go to version 2.1? Does it fix the problems I am experiencing?

    Thank you!

  49. Jason,

    Yes, version 2.0. Here is the complete error message, but nothing more:

    The page cannot be found
    The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.
    ——————————————————————————–

    Please try the following:

    Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly.
    If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted.
    Click the Back button to try another link.
    HTTP Error 404 – File or directory not found.
    Internet Information Services (IIS)

    ——————————————————————————–

    Technical Information (for support personnel)

    Go to Microsoft Product Support Services and perform a title search for the words HTTP and 404.
    Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Web Site Setup, Common Administrative Tasks, and About Custom Error Messages.

  50. I was getting the same error (Page cannot be found). You may get a Page cannot be found message when you browse aspx pages in a Windows Server 2003 environment.

    That is because in Windows 2003, all the webservice extensions are “Prohibited” by default to ensure security.

    To resolve this, do the following steps:-

    1. From your Run command, type inetmgr and press enter.
    2. Expand the appropriate nodes in the IIS to locate the “Webservice Extensions” Node
    3. Click on the same.
    4. You will find a list of “prohibited” extensions in the right.
    5. Click on ASP.NET and “allow” it

    That should resolve this issue.

    This applies for Windows Server 2003, IIS 6.0 environment.

  51. i am getting an error when trying to host the sqlserver 2000 database to the server using asp.net2.0 System.Data.SqlClient.SqlException: Invalid object name ‘dbo.new_case’. Processed 3000 total records at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ASP.runsql1_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\Documents and Settings\feroz\Desktop\SQL Run1\RunSQL1.aspx:line 86
    please help me

  52. Any plans to support XPe Resource Manager databases? I am currently using version 1.1, however, I need more granular options and the ability to export the data to excel. 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *